Hi,
> I am not shure if I need to.
>
> Here's why I am asking:
>
> I have a table that does not have a primary key and I need to update only
> one row.
> This complicates my Update Query since I cannot specify a Where clause.
Well, as you have figured out, without some kind of unique ID, it's
pretty much impossible to update a row.
> I did had a primary key RowID (AUTO INCREMENT) to be sble to specify a row
> in my query.
> But this Field (RowID) can now be seen when I do a SELECT query. I did not
> find a
> way to hide this field.
>
> So my first question should be : Is there a way to hide a field ??
Well, that depends on how you are displaying the data, doesn't it :-)
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com
