Multiple Rows Automatic Update

[ritzi]

Hello all,

The automatic update when multiple rows are the same (i want to update descriptions in result window) is a good feature but i don't want to use it always. For example, i got a list of 23 same descriptions. When I modify one, all the other are modified too. In my case today, i wish to disable that feature because i want to enter 23 different description without create a query per record. The only choice that i have is to enable or disable the prompt but the the automatic update.

How can i do that ?

Thanks a lot for your answers.

[peterlaursen]

you can manually issue a SQL command like

UPDATE table SET …. WHERE … LIMIT x.

(x is a number – '1' for instance)

But better you should have a Primary key in the table and include that PK column in the SELECT that opens a RESULT tab

[ritzi]

Ok thanks. I will try that.

Best regards.

🙄

peterlaursen wrote on Oct 17 2007, 02:14 PM:

you can manually issue a SQL command like

UPDATE table SET …. WHERE … LIMIT x.

(x is a number – '1' for instance)

But better you should have a Primary key in the table and include that PK column in the SELECT that opens a RESULT tab

[Author]

Posts