PostgreSQL native from Phil Ide

This forum is for ideas and or code to be contributed for general use.
Message
Author
User avatar
digitsoft
Posts: 458
Joined: Thu Jan 28, 2010 1:33 pm
Location: Republica Dominicana
Contact:

Re: PostgreSQL native from Phil Ide

#21 Post 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 :clap:

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"
Nolberto Paulino
Regards

User avatar
digitsoft
Posts: 458
Joined: Thu Jan 28, 2010 1:33 pm
Location: Republica Dominicana
Contact:

Re: PostgreSQL native from Phil Ide

#22 Post 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 :clap:

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"
Attachments
sql2.0.rar
DLL for Alaska 2.0 with your example
(1.92 MiB) Downloaded 1384 times
Nolberto Paulino
Regards

User avatar
PedroAlex
Posts: 234
Joined: Tue Feb 09, 2010 3:06 am

Re: PostgreSQL native from Phil Ide

#23 Post 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...
Pedro Alexandre

User avatar
PedroAlex
Posts: 234
Joined: Tue Feb 09, 2010 3:06 am

Re: PostgreSQL native from Phil Ide

#24 Post 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..
Pedro Alexandre

User avatar
Auge_Ohr
Posts: 1422
Joined: Wed Feb 24, 2010 3:44 pm

Re: PostgreSQL native from Phil Ide

#25 Post 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?
picommon.zip
(1.9 KiB) Downloaded 1383 times
greetings by OHR
Jimmy

User avatar
digitsoft
Posts: 458
Joined: Thu Jan 28, 2010 1:33 pm
Location: Republica Dominicana
Contact:

Re: PostgreSQL native from Phil Ide

#26 Post by digitsoft »

Hi, eXample
Attachments
SQL-PRG-CH.rar
(49.85 KiB) Downloaded 1427 times
SQL-LIB.rar
(122.56 KiB) Downloaded 1460 times
SQL-DLL.rar
(1.86 MiB) Downloaded 1469 times
Nolberto Paulino
Regards

User avatar
digitsoft
Posts: 458
Joined: Thu Jan 28, 2010 1:33 pm
Location: Republica Dominicana
Contact:

Re: PostgreSQL native from Phil Ide

#27 Post by digitsoft »

Example
Attachments
Ejemplo.jpg
Ejemplo.jpg (304.13 KiB) Viewed 27260 times
Nolberto Paulino
Regards

User avatar
digitsoft
Posts: 458
Joined: Thu Jan 28, 2010 1:33 pm
Location: Republica Dominicana
Contact:

Re: PostgreSQL native from Phil Ide

#28 Post 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.
Attachments
Ejemplo.jpg
Ejemplo.jpg (314.69 KiB) Viewed 27218 times
Nolberto Paulino
Regards

User avatar
PedroAlex
Posts: 234
Joined: Tue Feb 09, 2010 3:06 am

Re: PostgreSQL native from Phil Ide

#29 Post 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..
Pedro Alexandre

skiman
Posts: 1195
Joined: Thu Jan 28, 2010 1:22 am
Location: Sijsele, Belgium
Contact:

Re: PostgreSQL native from Phil Ide

#30 Post 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.
Best regards,

Chris.
www.aboservice.be

Post Reply