Thank you, but I already know the basics of SQL SELECT statements.
What I am trying to say is, if a User writes a SELECT clause, I do not want
see the RowID field. I do not want him to write a long SELECT statement,
especially if my
table has 20 FIELDS or more. (Can you imagine the user writing these queries
all the time).
I want him to be able to write SELECT * FROM ATABLE.
Well, that pretty much misses the point then, doesn't it? Are your records not unique?
There is no way that you can write an update statement that would perform the operation on
the proper record? Can you show us a bit of the table? With more information we can help.