>Hi Sergey
>
>I am sorry it was my bad. I was putting a comment to the code and I somehow managed to put the code *inside* the text endtext.
You could put comments as many as you wish, but don't use VFP comments chars [* or &&] use SQL Server ones [-- or /* */]
Something like:
TEXT TO cVar NOSHOW
SELECT MyField, -- This is the first field
SecondField -- SecondSelected field
FROM MyTable /* This is the table */
ENDTEXT
SQLEXEC(.....)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.