From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Barry Bell <Barry(dot)Bell(at)hartehanks(dot)com>, Hiroshi Saito <hiroshi(at)winpg(dot)jp>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> |
Cc: | Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>, Anna Gershnik <agershnik(at)tableausoftware(dot)com>, "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: psqlODBC text length with no records |
Date: | 2014-05-14 16:18:33 |
Message-ID: | 53739759.1040303@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 05/14/2014 09:08 AM, Barry Bell wrote:
> None of the below information helps because we are taking the output cursor
> From the postgrest sql, putting it into a VFP grid and displaying to the user.
>
> With theB0(Max varchar)=254 setting, Postgres for lengths 1-254 returns a "char"
> In vfp, when displayed to the user in a grid, the value of field is shown
>
> With theB0(Max varchar)=254 setting, Postgres for lengths=0 or null returns a "Memo"
> In vfp, when displayed to the user in a grid, "Memo" is shown in the field instead of the value
>
> With theB0(Max varchar)=254 setting, Postgres for length over 256 returns a "Memo"
> In vfp, when displayed to the user in a grid, "Memo" is shown in the field instead of the value
> We only have some code after the sql that sorts the cursor and VFP is unable to sort on the MEMO fields.
>
> Our issue is when Postgres is returning a fireld with 0 or null length,
> The driver is not using the B0(Max varchar) setting.
Well you could always try Parse Statements:
http://psqlodbc.projects.pgfoundry.org/docs/config.html
>
> Barry Bell
> Senior Developer/Analyst
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-05-14 16:22:35 | Re: psqlODBC text length with no records |
Previous Message | Adrian Klaver | 2014-05-14 16:09:32 | Re: psqlODBC text length with no records |