Hello List,
can anyone tell me if it is possible to reference a column using
a smallint variable when using the Update statement?
eg. Update table_name Set col(smallint)=blah where rowid=blahblah
Its possible to do it when reading the contents of a table eg.
table_name.col(SmallInt), so it would seem logical to me that you should
also be able to use a similar syntax when updating a table, but this seems
to not be the case.
Obviously, the above syntax doesnt work, but is there a way to do this that
I have missed in the help files, or does somebody know of some other way
around it?
Any help, or even confirmation that it cant be done, would be appreciated.
regards,
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Darren Murphy TO4 (Inspector)
Regional Observations Section Darwin NT
Phone (08) 89203818 Fax (08) 89203842
http://www.nt.bom.gov.au/ntregion/obs/obs.html (work)
http://www.darwin8ball.org (play)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
