Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How often is SYS(2015) changed?
Message
From
27/08/2011 08:08:31
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01521892
Message ID:
01521981
Views:
67
>Hi,
>
>I have a routine where the application gets (via SQL select) records into one cursor from one table, then into another cursor from another table, and then again into the 3rd one. For each cursor I use value of SYS(2015). Since the SQL Select time from one cursor to another may take a second or two or could be less than a second. Can I rely that each value of SYS(2015) is unique if it is called within less than a second?
>
>UPDATE: I did a test of running from one .prg SYS(2015) one after another (obviously with less than a second between each) and all names appear to be unique.

I am not sure what exactly you want to achieve, but selecting ... INTO CURSOR TEMP for example, will automatically assign random names (presumably based on sys(2015)) to the underlying temporary table created for the cursor. For the cursor as seen from your program, I would prefer to assign consecutive names, like MyCursor001, MyCursor002, etc., or MyCursor1, MyCursor2, etc. - that would make it easier to follow-up. These names won't conflict with the same names used by another user, since the underlying temporary tables.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform