FiveTech Software tech support forums

... Even there, there are several ways of fine tuning server and database performance. When we are using extremely primitive libraries like tmysql, hbpgsql there is no point in discussing these issues.

Now FWH 17.05 revised build provides support for hbpglib's query object.

... to this codeblock. If bColor or bColorBlock are not assigned, the normal behavior of the Gets continue. * NEW: Support for PostGreSQL using hbpgsql of Harbour or pgsql of xHarbour: - XBROWSE and XBROWSER support oQuery object like any other datasources. - Support AUTOCOLS or specified columns ...

This is how I implemented Instead of copying into array and then browsing, i am able to browse the Query directly. We can also edit data inline and save. #include "fivewin.ch"REQUEST DBFCDXstatic cPassword := <yourpassword>//-----------------------------------------------------------...

... BLOCK_SIZE     4096#include "FileIO.ch"#include "hbclass.ch"#include "postgres.ch"#require "hbpgsql"#include "DbStruct.ch"#define _STRU_FIELDNAME             1#define _STRU_FIELDTYPE     ...

Mr Fafi

Thanks for the good example.
I never used Postgresql and interested in learning.

I tested with PostgreSQL versi 9: #include "fivewin.ch"#include "xbrowse.ch"#require "hbpgsql"#include "DbStruct.ch"REQUEST DBFNTXREQUEST DBFCDXREQUEST DBFFPTREQUEST DBFDBTstatic aData,oBrwDataPROCEDURE Main( cHost, cDatabase, cUser, ...

compubrion wrote:Saludos !

Revisa las contribs de harbour alli esta la hbpgsql

Gracias,

Saludos

Si ya lo vi voy a construir las librerias. Al contruir las librerias faltan unos .h
como pg_config_ext.h pg_config.h libpq-fe.h postgres_ext.h donde los ubico no los encuentro.

Saludos !

Revisa las contribs de harbour alli esta la hbpgsql

Saludos !

Yo, estoy usando actualmente PostgreSQL 9.1 con harbour usando la hbpgsql que esta en las contribs, animate asi compartimos experiencias

Cruz Alfredo Oses

Saludos !
En las conribs de harbour encontraras hbpgsql y en las de xharbour encontraras pgsql

... libmisc hbmisc hbmisc libnf nf hbnf msql msql hbmsql mysql hbmysql hbmysql odbc hbodbc hbodbc ole hbole hbole pdflib hbpdflib (DELETED) pgsql hbpg hbpgsql rdd_ads rddads hbrddads samples samples hbclipsm telepath telepath hbtpathy tip tip hbtip what32 what32 hbwhat32 win32 hbwin32 hbw32 xhb xhb ...

luiz53 wrote:I did the test shows only one record ...
and the bank has 10 000 records

I am sorry, there was a small mistake in the code I posted originally. I corrected the above code in PgSkipper() function.
Please use the revised code above

I did the test shows only one record ...
and the bank has 10 000 records

Please try adopting the following code to your query. function PgQryBrowse( oQry )   DEFINE WINDOW oWnd      @ 0,0 XBROWSE oBrw OF oWnd ;         FIELDS oQry:FieldGet( 1 ), oQry:FieldGet( 2 ) ;         HEADERS oQry:FieldName( 1 ), oQry:FieldName( 2 ) ;        ...