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's what most do. No idea whether VFP does or not - I no idea it even supported SQL.

quick wrote:
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?
.

Relevant Pages

  • Re: Need help Regarding executing select query
    ... I am using the same pattern with MS SQL Server and I get the results in the expected order. ... because SQL semantics require that IN not have any reliable influence on result set order. ...
    (comp.lang.java.programmer)
  • Re: Need help Regarding executing select query
    ... I am using the same pattern with MS SQL Server and I get the results in the expected order. ... because SQL semantics require that IN not have any reliable influence on result set order. ...
    (comp.lang.java.programmer)
  • RE: Datatable Update method not updating
    ... underlying database, and then update the current value to database. ... What does the update SQL statement looks like in your application? ... 3, start trace. ... Would you please post the trace log in the newsgroup? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Windows forms application and database back-up
    ... underlying database is copied to a location of his choice ... The design of the application is with VS2008 and is deployed with sql ... database file only get attached whilst the application is running? ... If the latter is true I should be able backup & restore by writing a ...
    (microsoft.public.dotnet.general)
  • Re: Upload document
    ... SharePoint stores documents in its underlying database (e.g. MS SQL or MSDE) ...
    (microsoft.public.sharepoint.portalserver.development)