memo field content being deleted

[RoyS]

URGENT help needed on this one please.

Versions:
Delphi 2007; Vista Premium; MyDac 5.20.1.14; MySQL 5.0.51b

Structure:
Client dataset -> ds provider -> TMyQuery ...

Steps to reproduce:
On a form with a memo and text field linked to the MySQL table put data in both fields and post the changes.
edit the memo field, post and refresh - the changes are stored OK.
edit the text field ONLY, post and refresh - the memo field has been set to null.
post data into the memo field and refresh.
amend both fields, post and refresh - the changes are stored OK

Roy

[eduardosic]

URGENT help needed on this one please.

Versions:
Delphi 2007; Vista Premium; MyDac 5.20.1.14; MySQL 5.0.51b

Structure:
Client dataset -> ds provider -> TMyQuery ...

Steps to reproduce:
On a form with a memo and text field linked to the MySQL table put data in both fields and post the changes.
edit the memo field, post and refresh - the changes are stored OK.
edit the text field ONLY, post and refresh - the memo field has been set to null.
post data into the memo field and refresh.
amend both fields, post and refresh - the changes are stored OK

Roy

Try Upgrade to new version of MyDAC first... 5.50.0.36

[RoyS]

Now that I have posted a question on this forum, I have just found the solution! The TDatasetProvider component needs "Resolve to dataset = true".

However I would still like to upgrade but I am waiting on a reply from your colleagues as I can't find where to download the code.

Thanks for the excellent response.

Roy

[Dimon]

We have answered you by e-mail.