 | | | Problem with NULL Text field but being stored as (Memo) in MYSQL database | Problem with NULL Text field but being stored as (Memo) in MYSQL database 2005-09-15 - By Shepherd Madziwa
Back
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.
Earn $52 per hosting referral at Lunarpages.
|
|
|