Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Random search in a table
Message
From
09/12/2004 11:20:34
 
 
To
09/12/2004 11:15:53
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00968006
Message ID:
00968036
Views:
9
>>You can use something like this:
>>
>>LOCAL lcNumber, llExists
>>
>>RAND(-1)
>>
>>DO WHILE NOT llExists
>>   lcNumber = PADL(INT(RAND()*100000000),8,'0')
>>   llExists = SEEK(lcNumber,'cTableAlias')
>>ENDDO
>>
>>
>
>Hi Jim,
>
>This is exactly what I've been looking for.. Thank you..
>
>Claudio

My pleasure,
Jim
Previous
Reply
Map
View

Click here to load this message in the networking platform