Master Detail Form does not update

Applications Forms
#1

Hello,
I am having a problem updating detail records linked to a Master form.
I execute the main form where detail records are listed.
When deleting a detail record, scriptcase asks me if I really want to delete the record, I respond yes but then I get an error that says: “Error al excluir en la base de datos: registro inexistente”.

I turned the “debug” option and I see two errors I don’t understand:

  1. “Transaction not supported in mysql driver, use ‘mysqlt’ or ‘mysqli’ driver”.
  2. “(mysql): Select count(*) from detail_table_name where pr_p_id = 1)”

I am using mysql.
I have a parent record with key p_id = 1
I have several detail records with matching parent key p_dtl_id = 1
The detail record does exist and has a matching key.
On the Master/Detail option of the main Form I do have the options to "enable Insert button, enable Update button, enable Delete button, enable Navigate button turn on.

This just to work fine before but not anymore any ideas ??

Thank you.

#2

Re: Master Detail Form does not update

Do you have something on the details event? Can you put a print to see exactly the error?


I have a parent record with key p_id = 1
I have several detail records with matching parent key p_dtl_id = 1

The error is testing pr_p_id = 1 in the select statement.

#3

Re: Master Detail Form does not update

Thank you Diego,
I found my problem I had an error on the DB table itself that prevented finding the right record.
Thanks

#4

Re: Master Detail Form does not update

:slight_smile: