Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select SQl data using arrays
Message
De
15/08/2009 06:35:25
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Select SQl data using arrays
Divers
Thread ID:
01418215
Message ID:
01418215
Vues:
120
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform