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.
