Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select into array
Message
From
12/10/2006 02:03:10
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
 
 
To
12/10/2006 01:11:25
Suhas Hegde
Dental Surgeon
Sirsi, India
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01161377
Message ID:
01161385
Views:
15
Suhas,

if you didnt' have created the array befor SELECT SQL then
IF TYPE('YourArray')='U' THEN
*not created
ENDIF &&TYPE('YourArray')='U'
An other way is to create the array before with the number of columns and one row lenght and fill it with default values.
For example: If the SELECT SQL returns a number in column one you can do something like
LOCAL ARRAY;
 laSQLReturn(1,2)

SELECT;
 nNumber,cString;
 FROM SomeTable;
 INTO ARRAY laSQLReturn

IF VARTYPE(laSQLReturn)='L' THEN
*no value returned
ENDIF &&VARTYPE(laSQLReturn)='L'
HTH Agnes
>hi,
>I am facing a problem
>
>Select into array ...
>
>how do i know that the arrry is created other than the use of _tally ?
>
>TIA
>suhashegde
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Previous
Reply
Map
View

Click here to load this message in the networking platform