Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
A question about SELECT SQL?
Message
De
04/10/2000 16:15:10
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00424948
Message ID:
00424994
Vues:
12
>>>
>>>CREATE CURSOR mycomp (comp_name C(nn))
>>>APPEND FROM ARRAY myarray
>>>
>>>SELECT * FROM master_table WHERE company_name
>>>  IN (Select comp_name FROM mycomp )
>>>  INTO mycursor
>>>
>>Hi Sergey:
>>for some reasons the code is only getting the first element of the array
>>and does not append the whole array into a cursor...am I doing something
>>wrong?
>
>I forgot that that APPEND FROM ARRAY command creates only one record if array is one-dimensional.
>Try
>DIME myarray[ ALEN(myarray,1), 1] before APPEND FROM ARRAY
>
>or loop thru array and insert records into cursor
That works... I do not knwo why, but it works...can I do this SELECT
using a WHERE CLAUSE that uses a array instead of another cursor?
I can not get ASCAN to work for me....:)
Robert Keith
Independent Developer
San Antonio, Texas
E-mail address:
rebelrob1@yahoo.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform