Hi Chaim.

>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.

Either use SYS(2015) in its entirety (that is, instead of SUBSTR(SYS(2015, 3, 10), use SYS(2015) or add a character in front of the SUBSTR() value (eg. "X" + SUBSTR(SYS(2015, 3, 10))

Doug