Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Go bottom
Message
From
15/10/2004 15:56:19
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00950231
Message ID:
00951837
Views:
5
Hi Mike

Since he's running a sql, _tally will be set, however if the SQL returns no records, the array will not be created an alen will crash.

>_TALLY is for tables, if you are using an array try using ALEN()
>
>>Hi,
>>Make sure that is at least ONE record matched in your query.
>>
>>
>>SELECT MAX(myField) FROM (ALIAS()) INTO ARRAY laArray
>>
>>IF _TALLY > 0
>>  THISFORM.txt.Value = laArray + 1
>>ENDIF
>>
>>
>>HTH
Previous
Reply
Map
View

Click here to load this message in the networking platform