Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
A question about SELECT SQL?
Message
From
04/10/2000 16:15:10
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00424948
Message ID:
00424994
Views:
13
>>>
>>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform