I have a big and strange bug:
We have a function that creating a cursor with name acc the sys(2015).
the cursor calld 'gettempalias'.
here is the function syntax:
Local cRetvalue
cRetvalue=substr(sys(2015),3,10)
If used(cRetvalue)
Use in &cRetvalue.
Endif
Return cRetvalue
The function worked very good in many places in the project.
for example:
cAlias=gettempalias()
SELECT name,id;
from prudact ;
into cursor &cAlias. nofilter ;
where sprudact.usefor=.t. ;
order by 1
Today we started to get error message 'Syntax error' when I use with this function in all the places in the program.
I moving back the system date and the program working good, but if I use with date of today (or later) I getting the bug (I don't get the bug when the function creating, I get it when I using with the function) .
***********************************************************************
Someone can resolve it?
Thank you
Thank you
Chaim