>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.
If you mean to use unique values for cursor names, then it's useless and you better use meaningful names. Using unique names only makes sense if you're generating a permanent table.
If it's not broken, fix it until it is.
My Blog