I recall back in 1997 I had to alter all my VFP code to hit Oracle tables with numeric (or was it integer) with 0 or 1, instead of VFP tables using logical fields. One of our members had convinced our benefactor that Oracle was the only real way to build our app, despite the fact the VFP version was already in beta test at several locations, and running great. That was a PITA. After another year I moved to Rochester, NY, (no, not to be near Ed, although 9 years later he moved to Texas to get away from me I think <g>), and in 2001 I released my enhanced version of a similar app in VFP. I almost retained the use of numeric fields for logical fields, but at the last moment opted for logical as I was once again hitting VFP tables. The app has been extremely stable, running all over the US with no app related crashes. But now I am looking at moving to a PostgreSQL back end (scalability for > 2Gb file sizes, plus other goodies). So, now I am wishing I had retained the numeric 0/1 logical field approach. I would not be having any logical vs character vs numeric value issues. Oh well, I guess I ought to have coded to the lowest common denominator (Oracle, heh-heh).
Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Stephen Russell > Sent: Thursday, February 07, 2008 12:19 PM > To: [EMAIL PROTECTED] > Subject: Re: PostGreSQL +VFP: Logical data type ??? > > > On Thu, 7 Feb 2008 13:34:48 -300, Ailsom F. Heringer (OSKLEN) < > [EMAIL PROTECTED]> wrote: > > > Stephen, > > As I Said, VFP is showing Boolean as CHAR (1) ("1","0"). > > > > --------------------------------------------- > > OK let's go back to the start. It either IS or it ISN'T. "1" / > "0" is the > only way that VFP sees it. Other environments see it as True False. > > So you are going to have to make a FAKE column and .t. where > needed, or base > your analysis of your data off of what they give you a "0", "1" > > I've been there and done the latter. But things could be > different in VFP 9 > and I don't know about it. <-- See Charlie. > > It is a PITA but you have to adjust with data translations in all of the > other dbs as well. > > > > > > > > > -- > > Aílsom F. Heringer > > [EMAIL PROTECTED] > > Skype: ailsom.osklen > > Analista de Sistemas > > ---------------------------------- > > Osklen > > Departamento de Informática > > Rio de Janeiro - RJ > > BRASIL > > http://www.osklen.com.br > > 55 21 22198971 > > > > > -----Mensagem original----- > > > De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > Em nome de Stephen Russell > > > Enviada em: quinta-feira, 7 de fevereiro de 2008 13:25 > > > Para: [EMAIL PROTECTED] > > > Assunto: Re: PostGreSQL +VFP: Logical data type ??? > > > > > > On Thu, 7 Feb 2008 11:52:35 -300, Ailsom F. Heringer (OSKLEN) < > > > [EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > At a PostGreSql database, a BOOLEAN column is shown in VFP as CHAR > > > (1) > > > > ("1","0"). Does anyone know what PostgreSql data type VFP translates > > > to > > > > Logical (.T.,.F.) ? > > > > > > > > --------------------------------------------- > > > It is Boolean, Bool > > > > > > try http://www.postgresql.org/docs/8.0/interactive/datatype.html > > > > > > > > > > > > -- > > > Stephen Russell > > > Sr. Production Systems Programmer > > > Mimeo.com > > > Memphis TN > > > > > > 901.246-0159 > > > > > > > > > --- StripMime Report -- processed MIME parts --- > > > multipart/alternative > > > text/plain (text body -- kept) > > > text/html > > > --- > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
