Update a Paradox Memo field from Delphi3? 
Author Message
 Update a Paradox Memo field from Delphi3?

I'm trying to update a Paradox Memo field from Delphi3 C/S. Below is
the code I'm using. qryEntry is a TQuery object.

    frmMain.qryEntry.Close;
    frmMain.qryEntry.SQL.Clear;
    frmMain.qryEntry.SQL.Add ('UPDATE entries SET notes = ''test''');
    frmMain.qryEntry.ExecSQL;

The above code will properly update any of the other fields in the
table. But when I try to update the 'notes' field, which is a Paradox
Memo type, nothing happens...I don't get an error, but the field
isn't being updated. I opened the table in Paradox8 and verified that
the data was not written to the memo field.

As you can see in the code above, I'm not doing anything fancy...just
trying to insert some text into the Memo field. Any ideas what I'm
doing wrong? TIA.

Dave



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. SQL Updates of Paradox Memo fields Fail

2. Example of retrieving/updating Paradox Memo field?

3. 2nd update after update memo field corrupts row

4. 2nd update after update memo field corrupts row

5. Updating data to a memo field using SQL UPDATE

6. DTS - Paradox to Access Truncation Of Memo Fields

7. Truncation of Paradox Memo Fields

8. Formatted memo field paradox 4.5 + delphi 5

9. Searching a Paradox 7 memo field

10. Help needed of Paradox 7 Memo field.

11. GPF after loading large Paradox table with MEMO field

12. Need help accessing Paradox memo fields as TMemos


 
Powered by phpBB® Forum Software