Hi Gar,
That's probably it. I actually need an Integer identifier, so I'll do val(substr(sys(2015,2,9)).
Thanks a lot. I'll give it a try.
>>Hi everyone,
>>
>>Do you know, is there a way to add unique identifier in SQL, which operates on several tables.
>
>Hi Nadya
>
>If you don't need them to reflect recno() -- that is you don't care if they contain meaingful info so long as they are unqiue try:
>
>SELECT *, SUBSTR(SYS(2015),2,9) AS id FROM MYTABLE1 inner join mytable2 on mtable1.pk=mytable2.fk into cursor mycursor
>
If it's not broken, fix it until it is.
My Blog