Update Memo-Column with SQL UPDATE Statement

Update Memo-Column with SQL UPDATE Statement

Post by Stefan Boeth » Tue, 30 Jan 1996 04:00:00

How did I update a Memo field in a server table with SQL statements. I don't
want to use TTable for this.

INSERT INTO Test (Id,Memo) VALUES (:Id,:Memo)

This ever produce a error "BLOB not supported".

- Mfg Stefc-


1. 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

2. DBCC SHOWCONTIG not working correctly?

3. puzzling issue with inserted, updated and IF UPDATE(column) in an update trigger

4. Unix/Sybase Performance Management Tool

5. Recorset.Update vs SQL Update statement

6. Access 97 and SQL 7.0 sp2 Errors - Does anyone know

7. Update statement to renumber a SQL column

8. Problems Installing Office2000 MSDE

9. 2nd update after update memo field corrupts row

10. Syntax error in UPDATE statement while using a Memo field

11. SQL Server update error: row cannot be update for updating

12. UPDATE statement may update more records than expected