saving data to a memo field in a jet database via a stored procedure 
Author Message
 saving data to a memo field in a jet database via a stored procedure

Hello,

I have a jet stored procedure which is trying to insert data into a table
which has a column which is a memo field.

When I try and set the parameter value, it give me a "Application uses a
value of the wrong type for the operation" error.

The code to set this parameter is as follows:

Set pmNotes = cmd.CreateParameter("pmNotes", _
                                                           adLongVarWChar,
adParamInput, 255)
cmd.Parameters.Append pmNotes
pmNotes.value = m_notes

Any ideas ?

Thanks
Bruce



Thu, 04 Dec 2003 11:38:37 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Storing binary file data in a Jet memo field

2. Saving TMemo field data to a Blob field (Interbase Table) via SQL Update Query

3. Stored procedure + memo datatype + jet engine

4. stored procedure + memo datatype + jet engine

5. How to save data to Memo field?

6. Storing memo fields in Oracle via ODBC

7. save file to blob column via stored procedure

8. Storing Memo fields in Databases (Blob Fields?)

9. DAO and Jet-Database access on Memo-fields

10. US/UK Date corruption: Jet 3.5 stored procs via Jet 4

11. Saving Binary Data to a Paradox Binary Field via Code

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


 
Powered by phpBB® Forum Software