using AsMemo and Text var in SQL and returning a dataset error
Posted on 2003-12-09
I have a data which exceeds the SQL limit for a varchar which is 8000 so i decided to use the Text variable instead for my table. As input parameter, i used AsMemo. The stored procedure that i called to which i pass the AsMemo param should return a simple "select 'SUCCESS' " or " select 'Error' " after i call "Open". But instead i get an error saying "error creating cursor handle.". why is this? any solution ot my problem?
thanks in advance!