This table p_a has 130 field, I only changed a field, and then use the update to update, so the query is too complicated!
Below is the update statement in error window:

UPDATE p_a SET name='lily' WHERE at='people's hospital AND p_id=' 645832 'AND opname IS NULL AND ophospita IS NULL AND opstatus IS NULL...

Behind it all "and the field name IS NULL," this IS 128 and, IS really too much!

Do you have any good solution?

CodePudding user response:

Remove not line?
The condition that you must meet?

CodePudding user response:

Database design problem, what do you use something to differentiate between the two records are the same, should only use than the key

CodePudding user response:

Fields behind didn't fill, empty ah, don't know why all the update statement in the where?

CodePudding user response:

Use table automatic updates? You check the update, there are three optional, isn't it. If you don't write back manually

CodePudding user response:

Primary key is at and p_id, I was directly in dw_1. The update (), that's it, above statement is wrong in the window, not myself!

CodePudding user response:

You do p_id keyword, update the condition that the p_id.

CodePudding user response:

Datawindow
The update condition here, don't choose 2, choose 1 or 3,

The where clause for update/delete
1 the key columns
2 key and updateable columns
Three Key and modified the columns

CodePudding user response:

refer to 7th floor smilysoft response:

datawindow
The update condition here, don't choose 2, choose 1 or 3,

The where clause for update/delete
1 the key columns
2 key and updateable columns
Three Key and modified columns

Support, is to do so