Re: Boolean

Ian,

Did you mean Axxess Memo field ?
From what I gathered SQL server doesn't explicitly have a MEMO field.

Best Regards

Roger De Four
Database Developer
*RAD Financial Systems*

Cell #/WhatsApp: +1-(868)-342-8587
Email: radfinancialsystems(at)gmail(dot)com

On Mon, 27 Jul 2020 at 13:51, Ian <ian(at)ces-ltd(dot)co(dot)uk> wrote:

> Hi All
>
>
>
> Thanks for your help.
>
>
>
> That worked great.
>
> Now I have the same sort of problem with PostgreSQL Text types not filling
> MSSQL MEMO fields.
>
>
>
> I’ve looked in the DSN definition but I didn’t see anything obvious.
>
>
>
> Any ideas please?
>
>
>
> Regards
>
> Ian
>
>
>
>
>
> *From:* Jack C. Wei [mailto:jackcwei+pgsql(at)gmail(dot)com]
> *Sent:* 27 July 2020 16:28
> *To:* ian(at)ces-ltd(dot)co(dot)uk
> *Cc:* pgsql-odbc(at)postgresql(dot)org
> *Subject:* Re: Boolean
>
>
>
> There's a "Bools as Char" option in psqlodbc. Try turning it off. If
> you're using DSN, the option is in page 1 of the Options dialog box. If
> you're using a connection string, add "BoolsAsChar=0;" to it. See
> https://odbc.postgresql.org/docs/config.html
>
> Disclaimer: I've never used this option myself so can't say for sure. I
> actually use smallint instead of boolean in my design.
>
>
>
>
>
>
>
> On Mon, Jul 27, 2020 at 7:40 AM Ian <ian(at)ces-ltd(dot)co(dot)uk> wrote:
>
> Hello
>
>
>
> I am trying to use PostgreSQL as an alternative to MS SQL express.
>
> But when my Delphi table opens, the Boolean field fails as it says that it
> expects Boolean but receives string.
>
>
>
> How can I get Boolean to be a BIT?
>
>
>
> Thank you
>
>
>
> Ian
>
>
>
> Ian Burrows
>
>
>
> 07767 834329
>
> *CES Ltd.*
>
> 11 Alverton Close
>
> YO17 6RR
>
> Ces-ltd.co.uk
>
> https://ces-ltd.co.uk/the-croft-business-park/
>
> [image: ceslogo2_small]
> [image:
> CroftBusinessPark small]
>
>
>
>
>
>
>
>