HMGSQL with PosgreSQL?

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
paulomhouse
Posts: 30
Joined: Fri Aug 02, 2013 11:47 am

HMGSQL with PosgreSQL?

Post by paulomhouse »

I would like to use PosgreSql with HMGSQL.

ConnectDB2(), Sql() and MiscSql()

What I need to do it? .CH, lib????

I need a example, please.

Best regards.
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: HMGSQL with PosgreSQL?

Post by Rathinagiri »

In your project *.hbp file, please include this line.

libs=hmgpgsql

And you can use HMGSQL features, as mentioned in the hmgsql doc.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
paulomhouse
Posts: 30
Joined: Fri Aug 02, 2013 11:47 am

Re: HMGSQL with PosgreSQL?

Post by paulomhouse »

File: error.log
Harbour 3.2.0dev (r1407111333)
Copyright (c) 1999-2014, http://harbour-project.org/" onclick="window.open(this.href);return false;" onclick="window.open(this.href);return false;
c:/hmg.3.3.1/mingw/bin/../lib/gcc/mingw32/4.6.2/../../../../mingw32/bin/ld.exe: cannot find -lhmgpgsql

Best regards
jucar_es
Posts: 82
Joined: Thu Nov 13, 2008 11:12 pm

Re: HMGSQL with PosgreSQL?

Post by jucar_es »

hola, adjunto ejemplo de funciones basicas en postgresql migrando desde dbf

son funciones basicas, espero le sirva

para CONECTARSE BD postgres

usuario postgres
clave postgres


para aplicacion polla

USUARIO 1234
clave 0000

para crear ejecutable

build POLLA

aunque tengo poca experiencia en postgresql, cualquier duda.. con gusto
Attachments
POLLA (2).zip
(9.81 MiB) Downloaded 214 times
paulomhouse
Posts: 30
Joined: Fri Aug 02, 2013 11:47 am

Re: HMGSQL with PosgreSQL?

Post by paulomhouse »

I am working with "C:\hmg.3.3.1\HARBOUR\contrib\hbpgsql\tests\simple.prg

and libs=libpq

There are all dll from Postgres\bin in my Project's Folder

I'm so grateful to you for helping me.
Post Reply