Re: Logical fields in MySQL, field mapping from VFP to MySQL

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Christian Ehlscheid (ehlscheid-no-spam_at_edv-ermtraud.de)
Date: 03/17/04 

Date: Wed, 17 Mar 2004 11:53:13 +0100

Hello,

there's no real bool in MySQL ..
bool exists but it's a synomym for tinyint(1) which maps to "I" (integer) in
FoxPro

the other types map to vfp types as with every other SQL Server
C = Character
D = Date
M = Memo
I = Integer
B = Double
Y = Currency
T = DateTime

char/ varchar up to 254 -> C(XXX)
char/varchar greater 254 -> M
tinytext/text/mediumtext/longtext -> M
tinyblob/blob/mediumblob/longblob -> M (Binary)
date -> D
datetime -> T
bit -> I
float -> B **
double/real -> B **
decimal/numeric -> Y
timestamp -> not supported
bigint -> not supported ..

** i've tested returning double and float values from mysql with
Sql-Pass-through
the number of decimal places is not correctly propagated from mysql to vfp,
or it's not exchanged at all ..
the number of decimals in the resulting cursor is determined by the current
SET DECIMALS setting .. if it's too small the values are rounded ..- a
cursoradapter with a CursorSchema set seems to better suited to transfer
data of these types

Regards

Christian

"Ook" <outlookexpress@nospam@embertsdotcom> schrieb im Newsbeitrag
news:uCdq5l6CEHA.3280@TK2MSFTNGP09.phx.gbl...
> Is there any support in MySQL for logical fields? I see the BOOL type
field,
> but I'm not sure if the odbc driver will directly map that to a VFP
logical,
> and I'm thinking I should use numeric, 1 or 0, for my logical needs. On
the
> same subject, does anyone have/know of a list of VFP fields and the best
> matches in MySQL?
>
>

Relevant Pages

  • Re: VFP8 & MySQL
    ... Copy the VFP xCase model to a MySQL model, xCase will take care of the field type ... Generate the remote tables from xCase. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Update MySQL table
    ... remote mySql database via a system DSN [which is not what you're asking ... IF your php script is callable from your web page [not that secure, ... imo] then you can [back in your vfp app] instantiate a browser and go to the ... don't allow for odbc connections. ...
    (microsoft.public.fox.vfp.forms)
  • Re: Performance of Rushmore
    ... I use the PSP Libraries and xCase2VPM which also makes creating C/S with VPM ... >I built one app in VPME8 with MySQL before I finally abandoned VPM. ... >about network bandwidth consumption when you have a lot of users hammering ... VFP retrieves the CDX portions it needs to determine ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Performance of Rushmore
    ... Edhy Rijo ... I've found MySQL to be roughly twice as fast as VFP. ... > limitation - it can shove data to the workstation at a high rate of speed. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: MySql through ODBC driver problem
    ... Heya Jean - silly question here - are you using the Cursor Adaptor for any ... for mysql on the mysql side? ... VFP Webhosting? ... No problem in the connection designer, when I try to create a remote view in ...
    (microsoft.public.fox.vfp.queries-sql)