Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>>Native data Senario.
>>localcur
>>select somefields from mytable where mytable.keyfield in (select keyfield from localcur)
>>the above works fine with native VFP data.
>>
>>SQL data senario
>>localcur
>>*** the localcur can not be used in SQLEXEC, therefore i populate the data into an array:
>>select keyfield from localcur into array myarray
>>Is there an SQL syntax similar to:
>>sqlexec(lhandle,[select somefields form mytable where myrable.keyfield in myarray)
>>Please note: I would like to avoid the creation of a string with data from the array.
>
>Nope, you can't do that.
>But you can create an SQL query that would return you the same results using only SQL Server tables.
Hi Boris,
What kind SQL query. SQL cannot see the cursor I created at runtime ?
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