>Sir I have these codes
>
>

>
>db1='xyz'
>file_name='E:\HOURLY\at20\20190901_1159'
>
>		if m.con1>0
>		TEXT TO cmd noshow
>			backup database &db1 to disk='&file_name\&db1..bak'
>		endtext
>			
>			if sqlexec(m.con1,cmd)<0
>			aerror(laerror)
>			messagebox(laerror[1,2])
>				return.f.
>		ENDIF
>

>
>
>It says:
>Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '&'.
>
>Please help me to sort out the error message

LOCAL foo AS String

m.foo = "bar"

TEXT TEXTMERGE
Macros are not expanded inside a TEXT...ENDTEXT
Foo inside textmerge delimiters: <<m.foo>>
Foo expanded as a macro: &foo.
ENDTEXT


? TEXTMERGE("but are normally expanded when preparing a TEXTMERGE() call: &foo.")