>>>>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.
>>
>>I always thought that using meaningful names could be a problem of one cursor "stepping" on another. Thank you.
>
>As long as you use a different meaningful name for each cursor in the same data session, there's no problem.
>
>Tamar
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
