Hi Stéphane, > Here's an example : > > > I have a table named Product. > > TABLE : PRODUCT > +-------------+-------------+-------------+-------------+-------------+ > | RowID | Name | Company | Price | Warranty | > > | | | | | | > +-------------+-------------+-------------+-------------+-------------+ > | 1 | PC 1000 | MyCom Inc. | 1000.00 | 1 year | > > | 2 | PC 1000 | MyCom Inc. | 1200.00 | 2 year | > > | 3 | PC 1000 | MyCom Inc. | 1300.00 | 3 year | > > | 4 | PC 2000 | MyCom Inc. | 1200.00 | 1 year | > > | 4 | PC 2000 | MyCom Inc. | 1300.00 | 2 year | > > | 4 | PC 2000 | MyCom Inc. | 1400.00 | 3 year | > > | 4 | PC 3000 | MyCom Inc. | 1500.00 | 1 year | > > | 4 | PC 3000 | MyCom Inc. | 1600.00 | 2 year | > > | 4 | PC 3000 | MyCom Inc. | 1700.00 | 3 year | > > | 4 | PC AR3 | SPCom Inc. | 1200.00 | 2 year | > > | 4 | PC AR3 | SPCom Inc. | 1300.00 | 3 year | > > | 4 | PC AR4 | SPCom Inc. | 1400.00 | 4 year | > > +-------------+-------------+-------------+-------------+-------------+ > > >From My Server Side Application (C code) > > I can Update my Rows using my RowID. > > Example : "UPDATE TABLE product SET Price="2000.00" WHERE RowID="3""; > > > But For My Client Side Applications : > > User logs in my Client app. > User types in "SELECT * FROM product".
Why?? In what application do you allow users to construct their own SQL statement and run UPDATE SQL statements? I never do that and I see no reason why I should. > User does NOT WANT TO SEE RowID numbers. Why not? > User wants to see this output : > > +-------------+-------------+-------------+-------------+ > | Name | Company | Price | Warranty | > | | | | | > +-------------+-------------+-------------+-------------+ > | PC 1000 | MyCom Inc. | 1000.00 | 1 year | --8<-- > | PC AR4 | SPCom Inc. | 1400.00 | 4 year | > +-------------+-------------+-------------+-------------+ > > I know there are ways to bypass this problem, but it involves much more > coding in my Delphi applications > on my Client side. You can do this in the "after open" event, I think. > So my question is, Is there a way to hide a field from select statements. > > Of course, if my user wrote "SELECT RowId, Name, Company, Price, Warranty > FROM product" > he would get the RowId in his query output. How do you expect your users to update rows without an unique ID? With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
