Board index » delphi » indexname not supported for VFP

indexname not supported for VFP


2007-12-18 06:30:32 AM
delphi126
The VFP ole db provider does not support the indexname property. But, it
does support the 'set order to' command. Is there any way to use 'set
order to' in an SQL statement?
 
 

Re:indexname not supported for VFP

SQL has Order By. You would hope the underlying database would choose an
appropriate index when you do that - that is what most do. No idea
whether VFP does or not - I no idea it even supported SQL.
quick writes:
Quote
The VFP ole db provider does not support the indexname property. But, it
does support the 'set order to' command. Is there any way to use 'set
order to' in an SQL statement?