Information générale
Forum:
Microsoft SQL Server
Thanks, so far so good, it was a great help to us. We have used the "SP_HELPSORT" function which made clear that the sqlserver uses case insensitive set order.
a =sqlconnect("relasqlserver")
? a
? sqlexec(a,"SP_HELPSORT","Temp")
How to creat an index is also pretty clear.
However, concerning our question:
'How to create indexes on a field in a related database?'
In VFP we use two tables: rela and contracts. We mean by "a related database" a relation set from one table into the other. Example code:
USE Contracts in 0
USE Rela in 0
SELECT Rela
SET ORDER TO R_relcode
SELECT Contracts
SET RELATION TO C_relcode into RELA
INDEX ON rela.relname INTO C_RELNAME
Translated in words:
We like to order to rela.relname with corresponding Contracts.
In return we like this code transformed into SQL.
We are very pleased with any help.
Jan & David
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement