Text Memo - Mailing list pgsql-odbc

From Ian
Subject Text Memo
Date
Msg-id 01a301d66442$84a58ef0$8df0acd0$@ces-ltd.co.uk
Whole thread Raw
List pgsql-odbc

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@gmail.com]
Sent: 27 July 2020 19:00
To: ian@ces-ltd.co.uk
Cc: pgsql-odbc@postgresql.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

 

 

 

On Mon, 27 Jul 2020 at 10:40, Ian <ian@ces-ltd.co.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/

                                  ceslogo2_small                                                              CroftBusinessPark small

 

 

 

Attachment

pgsql-odbc by date:

Previous
From: Roger De Four
Date:
Subject: Re: Boolean
Next
From: "Ian"
Date:
Subject: Text and Memo or Widestring