dbedit mysql 4.1.12

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Jose Vazquez Fri, 03 Jun 2005 13:55

#833

Author: Jose Vazquez
Date: Fri, 03 Jun 2005 13:55

11 lines
1402 bytes

 Hi there,

I am developing an application with Mysql server version 4.1.12 and Borland 
Builder 6. Using a dbedit when the table is empty it shows "(memo)" on the 
field though it's a varchar(16) field type. The thing is that when I try to 
insert something through the dbedit it says "cannot access field MY_FIELD as 
Text type". What really amaze me is that this error only occurs when it's 
empty because it would show any field previously inserted by any "insert SQL 
sentence".

Any ideas folks?

Re: dbedit mysql 4.1.12

#834

Author: Matt Jacobs
Date: Sat, 04 Jun 2005 05:16

16 lines
1643 bytes

"Jose Vazquez" <jose_vaz@teleline.es> wrote:

> Hi there,
>
>I am developing an application with Mysql server version 4.1.12 and Borland 
>Builder 6. Using a dbedit when the table is empty it shows "(memo)" on the 
>field though it's a varchar(16) field type. The thing is that when I try to 
>insert something through the dbedit it says "cannot access field MY_FIELD as 
>Text type". What really amaze me is that this error only occurs when it's 
>empty because it would show any field previously inserted by any "insert SQL 
>sentence".
>
>Any ideas folks? 

Are you using the ODBC driver? If so, try adding OPTION=19 to the
connection string and see if you have better luck.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads