Infopath row cannot be located for updating

So, There are two Options on Cursor Location: The "Use Server Side Cursors" and "Use Client Side Cursors". I notice taht the option for forward -only is on the Server side... I'm working with Delphi (XE3) and need to connect to a My SQL database.

infopath row cannot be located for updating-84infopath row cannot be located for updating-65infopath row cannot be located for updating-32

Close; end; [email protected] on db SET NAMES latin1 SET character_set_results = NULL SET SQL_AUTO_IS_NULL = 0 select database() select database() SHOW GLOBAL STATUS SELECT @@tx_isolation set @@sql_select_limit=DEFAULT select * from facility SHOW KEYS FROM `facility` UPDATE `db`.`facility` SET `Facility Address1`=? UPDATE `db`.`facility` SET `Facility Address1`='mickey street22' WHERE `facilityid`='' SHOW GLOBAL STATUS [email protected] on db SET NAMES latin1 SET character_set_results = NULL SET SQL_AUTO_IS_NULL = 0 select database() select database() SELECT @@tx_isolation set @@sql_select_limit=DEFAULT select * from facility SHOW KEYS FROM `facility` UPDATE `db`.`facility` SET `Facility Address1`=? // SUCCESSFUL UPDATE `db`.`facility` SET `Facility Address1`='mickey street22' WHERE `facilityid`='' SHOW GLOBAL STATUS SHOW GLOBAL STATUS SHOW GLOBAL STATUS db select * from facility UPDATE `db`.`facility` SET `Facility Address1`=?

I have a piece of code that is inserting a new row into a table and then retrieving the Serial No, updates the Reference No column using the Serial No and then again updates the database.

However on the second update I get an error of: Row cannot be located for updating.

You could also try opening a Dynamic type recordset which might better reflect the updates to the data.

I think you'll be opening a forward-only recordset by default.

Leave a Reply