Stephen, At another VFP group someone said that this problem can be solved with some settings at the connection string, but he could not say what setting . I will try to find this connection string setting, because I all my classes (grids, forms, combo, ...) are based on vfp logical (.T.,.F.).
My last option will be a fake column or base the analysis on "1" or "0". Thank you. -- 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 15:19 > Para: [EMAIL PROTECTED] > Assunto: 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:profoxtech- > [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.
