Dear Sir/Madam;
I downloaded a MYSQL 4.1.14 database, created a table with fields of Char, Varchar, Text,
Date and Double as data types. I developed a small VB 6.0 application to write data into
the table and it works fine. I captured 5 records. On 3 records I did not enter any data
in the Text field datatype. I have also found out that this Text field data is being
stored as (Memo) when I open the table in datasheet. I have gone further and tried to
retrieve the records using a recordset and assign the values from the recordset into a
field say Text1 on a form. This works fine if the Text field stored as (Memo) has value.
In cases where it as NULL, I get this error mesage from my small VB application -
"Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if
available. No work was done."
In my VB application the code is like this:
"If NOT ISNULL(rs!Rep) then Text1.text = rs!Rep." The (NOT ISNULL) I am using it to test
if there is any value.
I have tried to use "If len(trim(rs!Rep)) > 0 then Text1.text = rs!Rep" and it does not
work either - same error.
I have checked my Data Source Name and the Login is fine, Connect Options I did not select
any option and Advanced I selected the first top 3 options.
So I don't know where I am going wrong if you can help please because I have a project
waiting for this break-through.
Thanks.
