[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: Problems with Memo Field Using Remote View in FoxPro connecting to MySQL
From:       "Carl Karsten" <carl () personnelware ! com>
Date:       2001-02-28 13:30:03
[Download RAW message or body]

in MySQL, the TEXT datatype is the same as VFP's MEMO.  so there are 2
things you can do:

You can either create the table with char datatypes:

> CREATE TABLE kd (
>    ckunde char(10) NOT NULL,
>    cstrasse char(30) NOT NULL,
>    cplz varchar(50) NOT NULL,

or

adjust the way VFP sees the field:
? DBSETPROP( "v_kd.ckunde", "FIELD", "DataType", "c(10)" )
? DBSETPROP( "v_kd.cstrasse", "FIELD", "DataType", "c(30) ")
? DBSETPROP( "v_kd.cplz", "FIELD", "DataType", "c(50)" )

HTH - be sure to ask more questions if it dosn't.

Carl

----- Original Message -----
From: "Michael Gudlautzki" <mg@conne.net>
To: <myodbc@lists.mysql.com>
Sent: Wednesday, February 28, 2001 2:39 AM
Subject: Problems with Memo Field Using Remote View in FoxPro connecting to
MySQL


> Hello,
>
> here the Problem:
> I am using a remote view in Visual Fox Pro 6 to connect to a MySQL Table
(on
> Linux). The Table structure is like following:
>
> CREATE TABLE kd (
>    ckunde text NOT NULL,
>    cstrasse text NOT NULL,
>    cplz text NOT NULL,
>    cort text NOT NULL,
>    cbemerkungen text NOT NULL,
>    nidkd int(11) DEFAULT '0' NOT NULL auto_increment,
>    KEY pid (pid),
>    PRIMARY KEY (pid, pid)
> );
>
> When viewing the structure of the view, the datatype for every textfield
is
> set to Memo. In the MyODBC Driver I activated the Checkbox Don't optimize
> column width.
> How can I automatically let set the datatype to text of the corrrect
length?
> How can I tell MySQL to limit the Fieldwidth of a textfield?
>
>
> Regards
> Dipl.-Ing. Michael Gudlautzki
>
> connedata GmbH
> Software+Systemberatung
> Saegemuehlenstrasse 49
> D-26789 Leer
>
> Tel:     0491 92765 - 22
> Fax:    0491 92765 - 43
> eMail: mg@conne.net
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread2884@lists.mysql.com
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@lists.mysql.com instead.


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread2885@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]