Updating but not inserting on the database php
From the Designer in Sql Data Source and then bring up the Properties window (from the View menu, choose Properties window, or simply hit F4).Select the Delete Query property, which will bring up a set of ellipses.The Workbench has a preference setting to toggle safe-updates on the SQL Editor screen.Turn that off if you are certain that a non-indexed field will not yield unpredictable field linking: 336 row(s) affected Rows matched: 336 Changed: 336 Warnings: 0 Id title release_year rental_rate restricted 1 ACE GOLDFINGER 2006 4.99 0 2 AIRPLANE SIERRA 2006 4.99 0 3 AIRPORT POLLOCK 2006 4.99 1 4 ALADDIN CALENDAR 2006 4.99 1 5 ALI FOREVER 2006 4.99 0 For maximum confidence in a one-to-one relationship between table rows, you can’t beat a PK to PK link.
For now, let s use the Properties window in the Designer, although the Configure Data Source wizard or declarative syntax option would work just as well.
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.
To disable safe mode, toggle the option in Preferences - SQL Editor and reconnect.
Recall that to support inserting, updating, and deleting, with the Object Data Source we needed to specify the object layer methods to invoke to perform the insert, update, or delete action.
With the Sql Data Source, we need to provide SQL statements (or stored procedures) to execute.