SQL Updates of Paradox Memo fields Fail 
Author Message
 SQL Updates of Paradox Memo fields Fail
David,

It might be better to use a parameterised update rather that create the SQL
yourself. ie. Use a Tquery and insert the following SQL :-

Update MyTable
Set MyMemo = :SomeMemotext
Where MyId = SomeId

Then set the data type of the parameter SomeMemoText to MEMO. In your code
you just need to assign the MEMO Text to the memo parameter and the call
EXECSQL.

Just a suggestion.

regards

Campbell Fuller



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

 Relevant Pages 

1. Updating SQL Server Memo Field from Access Fails.

2. Update a Paradox Memo field from Delphi3?

3. Updating data to a memo field using SQL UPDATE

4. Example of retrieving/updating Paradox Memo field?

5. 2nd update after update memo field corrupts row

6. 2nd update after update memo field corrupts row

7. Problem with Paradox/BDE 5 loading MS-SQL Memo Fields

8. local SQL: memo field update problem

9. ADO/SQL - Updating large memo field

10. Updating SQL memo fields - Invalidates log

11. VB5/ADO/SQL 6.5 currency field update fails?

12. memo field fail--help!!


 
Powered by phpBB® Forum Software