| Daniel Kasak 2005-09-16, 3:24 am |
| Shepherd Madziwa wrote:
>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 e
nter 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 D
B 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.
>
>
>
>
You'll probably need to send more info than that to get help. Try
sending your table definition, from:
show create table table_name
.... replace table_name with the name of your table.
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting
.com.au
website: http://www.nusconsulting.com.au
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc? unsu...sie.nctu.edu.tw
|