reserved work lineno as field

[benah]

I have a sql database on sql server. The following works.

lnsql = sqlstringconnection('blah blah blah') && I know this is wrong .

lnok = sqlexec(lnsql, 'select bbshipto.ljob from bbshipto', 'mycursor')


The following blows up:

lnok = sqlexec(lnsql, 'select bbshipto.lineno from bbshipto', 'mycursor')

When I tried to create a view in the view designer, that blows up as well complaining about lineno, yes the field really is lineno.

Any suggestions?

Thanks in advance.

 

[benah]

I found my own answer.

lcsqlcmd = 'select bbshipto.[lineno] from bbshipto'