Text Memo

Hi

Ah well the Memo field is in Delphi.

I’ve just checked the MS SQL data field and it is type Text.

Hum same as Postgresql. !?!

So I’ll see if I can define a table.field type that reads both database data sources.

Any suggestions please?

Thanks

Great to have you there.

Regards

Ian

From: Roger De Four [mailto:radfinancialsystems(at)gmail(dot)com]
Sent: 27 July 2020 19:00
To: ian(at)ces-ltd(dot)co(dot)uk
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Boolean

Sorry, meant MS ACCESS :: "Did you mean Axxess Memo field ?"

Best Regards

Roger De Four

Database Developer

RAD Financial Systems

Cell #/WhatsApp: +1-(868)-342-8587

Email: radfinancialsystems(at)gmail(dot)com <mailto:radfinancialsystems(at)gmail(dot)com>

On Mon, 27 Jul 2020 at 10:40, Ian <ian(at)ces-ltd(dot)co(dot)uk <mailto: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 <http://Ces-ltd.co.uk> https://ces-ltd.co.uk/the-croft-business-park/