Updating data to a memo field using SQL UPDATE 
Author Message
 Updating data to a memo field using SQL UPDATE

I am having trouble updating data to a memo field using an SQL
UPDATE query in VB 4.0 with jet2.5.

The following code is generating the error message 3075 (Syntax
error in query expression):

  SQL_Stat = "UPDATE Mailings SET [Mailing_Fields] = '" & Sats & "' WHERE [Mailing_Name] = '" & Text2.Text & "'"
  Dbase.Execute SQL_Stat

The field Mailing_Fields is defined as a memo field.

Any suggestions would be grateful

Axel Bendix



Tue, 09 Jun 1998 03:00:00 GMT  
 Updating data to a memo field using SQL UPDATE

Quote:

>I am having trouble updating data to a memo field using an SQL
>UPDATE query in VB 4.0 with jet2.5.

You should probably take a closer look at the AppendChunk function
desribed in the help file.


Wed, 10 Jun 1998 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. 2nd SQL Server update after update text field corrupts row - using RDO

2. ADO/SQL - Updating large memo field

3. Updating Memo Fields in MS Access using ADO Parameter / Stored Procedures

4. Using VB 3.0 to Update DBase III Memo Field

5. Updating Memo Fields in MS Access using ADO Parameter / Stored Procedures

6. ADO Update (using VB) of Memo fields in Access 97 DB

7. Populating memo field using update query from VB5

8. Update Oracle data using Data control and SQL?

9. Using--After Update-- to update field in table.

10. How to update datetime field with NULL using ADO update

11. Using Update to update an Access field

12. Problem updating memo field

 

 
Powered by phpBB® Forum Software