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-
by Stefan Boeth » Tue, 30 Jan 1996 04:00:00
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