Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a code sequence
Message
From
07/09/2005 03:59:44
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01046401
Message ID:
01047268
Views:
20
This message has been marked as the solution to the initial question of the thread.
>select max(cod) from mytable ;
> into array lctemp
> lctemp[1] = lctemp[1] + 1
> appe from array lctemp fields cod
>
>If the table already contain data it works fine
>However it the table is empty, an operand/operator mismatch error appears
>
>Moises
dimension lctemp[1]
select max(cod) from mytable ;
    into array lctemp
  lctemp[1] = IIF(_tally=0,1,lctemp[1] + 1)
  appe from array lctemp fields cod
If you use this in a shared table you won't go far.
Previous
Reply
Map
View

Click here to load this message in the networking platform