stored procedure + memo datatype + jet engine 
Author Message
 stored procedure + memo datatype + jet engine

I NEED MEMO DATATYPE IN STORED PROCEDURE

I added stored procedure to the access database using ADOX.Procedures.Append
method.
Everything works, I can select, delete, insert and update rows in the
database but ...
I can't find a way how to create stored procedure with MEMO datatype
argument.
Everytime this datatype is converted to TEXT, which has limitation to 255
characters.
I tried to use varchar, longtext, longchar, memo, char(number of chars),
text(number of chars) but the result is ... TEXT. Obviously, when I'm trying
to send string longer than 255 chars to the database an error occurs.
I've found that adox adLongVarWChar datatype should be MEMO datatype in the
access, but I didn't find any way how to force ADOX to use it.

The same conversion happened when I tried to create stored procedure using
SQL syntax CREATE PROCEDURE and executed it against db engine. The memo
datatype is always converted.

Any ideas what should I use??



Sun, 09 Nov 2003 13:32:34 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Stored procedure + memo datatype + jet engine

2. Stored procedures and MS Jet database engine

3. saving data to a memo field in a jet database via a stored procedure

4. Storing and editing paintbrush pics in Jet engine

5. Storing binary file data in a Jet memo field

6. jet engine engine.idle

7. jet engine engine.idle

8. ODBC engine vs. Jet engine

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

10. Stored Procedures and Text Datatypes

11. Stored procedure and image datatype?

12. Concatenating TEXT datatypes inside stored procedure


 
Powered by phpBB® Forum Software