General information
Title:
How to retrieve records in SQL server and its indexes
I am on the process of migrating my database to SQL Server 2000.
My existing apps was developed in VFP8 and the Native VFP as its database.
Many of my existing forms uses the SET RELATION command to relate child tables.
Example:
sele department
set order to department
sele items
set rela to department into department
my problem is when is use SPT i need to index each cursor after the retrieval of the recordset if i need to relate it or issue a set order to
such as:
=SQLEXEC(pnhconn,”select * from department”,"department")
sele department
index on department tag department
set order to department
is there a way in VFP8 to automate this?
Many thanks
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only