Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL SELECT and Arrays
Message
De
06/04/2018 20:25:37
 
 
À
06/04/2018 17:05:34
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01659198
Message ID:
01659206
Vues:
56
>Hello.
>I have an array full of primary-key values for a table.
>
>Is there a way in VFP that I can query against this array to extract values from a table?
>
>Something like
>SELECT * FROM mytable where mytable.PK in myarray
>
>Thank you.

Well, there is a way, but it's not optimizable:
SELECT * FROM mytable WHERE ASCAN(myarray,PK,1,-1,-1,2+4) > 0
Another way is copying the array to a cursor and using a normal Query.
Fernando D. Bozzo
Madrid / Spain
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform