Using SQL to insert record wth memo 
Author Message
 Using SQL to insert record wth memo

 I am trying to insert a record containing memo field.
 Suppose the table has the following field

 Name              Type
 DocumentNumber    Alpha
 Notes             Memo

 I use the following SQL to insert a record:
 insert into documangmain (DocumentNumber, Notes) VALUES
 ("D00001","This is a test string for memo file")

 When I executed the statement using Database Explorer,
 I get the "type mismatch error"

 Any idea what's wrong with the SQL statement?  Thanks

Jackal Yu                                                     o___o  
Forth Year Electrical Engineering     |Tel:   (403) 434-1397  |0.0|___    
University of Alberta                 |Mobile:(403) 680-9388   \u/___|=\

Sat, 14 Nov 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Inserting text into a memo field using SQL.

2. How to INSERT a RECORD using SQL??

3. trapping key violation error when inserting new record using SQL

4. INSERT MEMO fields using BDE

5. Inserting Data into a Memo / Blob Field Using Paradox

6. inserting a memo field with sql - HELP

7. SQL INSERT for a memo variable

8. Problem with using MEMO BLOB fields when creating a new record in INTERBASE

9. Q: regarding using AppendRecord or Insert Record

10. Q : SQL and INSERT and Multi-Records

11. using ttable/tdataset to insert rows into sql server

12. inserting lots of records in a sql anywhere database


Powered by phpBB® Forum Software