Page 3 of 6
Re: PostgreSQL native from Phil Ide
Posted: Fri Sep 08, 2017 1:37 pm
by digitsoft
Hi Auge_Ohr
The field I use to record photos is character varying
and burn them to Base64
that does the lib I'm preparing for PGSQL using the
methods: FieldPutPhoto ("photo", cFile) y: FieldGetPhoto ("photo")
Auge_Ohr wrote:hi,
digitsoft wrote:Attached is an example
nice work
how does your CLASS SQLRecordSet FieldPutPhoto()/ FieldGetPhoto() Methode look like ?
how do you store Image in PostgreSQL ?
not sure what Alaska now use with PgDBE to store Image. early Version have use "BYTEA"
Re: PostgreSQL native from Phil Ide
Posted: Mon Sep 11, 2017 4:42 am
by digitsoft
DLL for Alaska 2.0 with your example for Express, usando la lib de Pablo Botella y la Clase de Hector Pezoa
digitsoft wrote:Hi Auge_Ohr
The field I use to record photos is character varying
and burn them to Base64
that does the lib I'm preparing for PGSQL using the
methods: FieldPutPhoto ("photo", cFile) y: FieldGetPhoto ("photo")
Auge_Ohr wrote:hi,
digitsoft wrote:Attached is an example
nice work
how does your CLASS SQLRecordSet FieldPutPhoto()/ FieldGetPhoto() Methode look like ?
how do you store Image in PostgreSQL ?
not sure what Alaska now use with PgDBE to store Image. early Version have use "BYTEA"
Re: PostgreSQL native from Phil Ide
Posted: Mon Sep 11, 2017 10:13 am
by PedroAlex
[quote="digitsoft"]DLL for Alaska 2.0 with your example for Express, usando la lib de Pablo Botella y la Clase de Hector Pezoa
HI, Nolberto.
Can Not Compile your sample.
Same files fault..
_dcbrowse.prg
xbpgsql.lib
etc...
Re: PostgreSQL native from Phil Ide
Posted: Mon Sep 11, 2017 10:20 am
by PedroAlex
Auge_Ohr wrote:comercial wrote:Do you have this example working in XB 2.0 ?
you will find Source of libpq4xb.DLL / LIB in 1st Msg of this Thread
Hi, Jimmy
The sample you refer can not be compiled..
piCommon.ch is fault..
Where I Can find it?
Thanks..
Re: PostgreSQL native from Phil Ide
Posted: Mon Sep 11, 2017 12:22 pm
by Auge_Ohr
comercial wrote:Auge_Ohr wrote:comercial wrote:Do you have this example working in XB 2.0 ?
you will find Source of libpq4xb.DLL / LIB in 1st Msg of this Thread
The sample you refer can not be compiled..
piCommon.ch is fault..
that is in Phils Code.
i "think" "piCommon.ch" is for using NoiVAR and not need when using "my" o:Datalink
comercial wrote:Where I Can find it?
Re: PostgreSQL native from Phil Ide
Posted: Mon Sep 11, 2017 5:26 pm
by digitsoft
Hi, eXample
Re: PostgreSQL native from Phil Ide
Posted: Thu Sep 14, 2017 5:50 pm
by digitsoft
Example
Re: PostgreSQL native from Phil Ide
Posted: Mon Sep 18, 2017 5:30 pm
by digitsoft
Soon I will leave a copy of the Api of Pablo Botella and the Class of Hector Pezoa with some modifications of some DLL that I am preparing for eXpress 1.9.355, attached an example screen.
Re: PostgreSQL native from Phil Ide
Posted: Tue Sep 19, 2017 10:22 am
by PedroAlex
digitsoft wrote:Soon I will leave a copy of the Api of Pablo Botella and the Class of Hector Pezoa with some modifications of some DLL that I am preparing for eXpress 1.9.355, attached an example screen.
Hi, many thanks for your posts
this is the future way to the DBFs files.
This topic is very interesting.
All the possibilities of using SQL and xbase are very important.
I just do not understand why SQL has had so little attention here in the forum.
as soon as I have some time I will try this..
Re: PostgreSQL native from Phil Ide
Posted: Tue Sep 19, 2017 11:47 pm
by skiman
Hi,
Yes, this is very interesting and I will try it also.
Phil Ide was a brilliant programmer, and posted a lot of tools for Xbase which were far ahead.
For those who are interested, Phil is now an author, and published his first novel about a 6 months ago.