FiveTech Support Forums

Dear All,

I try to use Tdolphin:Seek() but I've got many question that comparison with DbSeek() function.

1. ::Seek( cString, oQry:FIELDNAME )
1.1 how to seek with expression (an example didn't success)

1.2 how to seek DATE field
2. After Open Table with out specific qurey ( ::Query( 'select * from dbtable') )
2.1 how to ReQuery after open table (alike dbsetfilter())

Thanks for any idea.

• Has anyone got an idea about seek?
• Has it must be got an index?

Thanks for any idea and help.

Regards,
Dutch

Hello

Sorry for delay...

you first should understand the differences between DBF and SQL, them are not same
TDolphin is a tool to do more easy work with mysql, using method we know (like SEEK, LOCATE, END, BOTTOM, FIRST,e tc) to handle the recordset, it not means that dolphin handle the MYSQL the same way like a DBF

1.
you can use SEEK on a field(s) of a query ordered by it or them,
the seek not work over date field, convert to string it inside the query and seek over it...
look sample : https://bitbucket.org/danielgarciagil/tdolphin/src/d9d98a01d60923d0958c93fd23d7e8b84ff34a8e/samples/testseek.prg?at=master
2.
the tables in mysql do not open, use a recordset

Dear Daniel,

Thank you so much. I get more idea and more understanding now.

Daniel Garcia-Gil wrote:Hello

Sorry for delay...

you first should understand the differences between DBF and SQL, them are not same
TDolphin is a tool to do more easy work with mysql, using method we know (like SEEK, LOCATE, END, BOTTOM, FIRST,e tc) to handle the recordset, it not means that dolphin handle the MYSQL the same way like a DBF

1.
you can use SEEK on a field(s) of a query ordered by it or them,
the seek not work over date field, convert to string it inside the query and seek over it...
look sample : https://bitbucket.org/danielgarciagil/tdolphin/src/d9d98a01d60923d0958c93fd23d7e8b84ff34a8e/samples/testseek.prg?at=master
2.
the tables in mysql do not open, use a recordset