FiveTech Software tech support forums

... / Fivewin Way --- when build TPQServer LIB there is a File rddcopy.c it have HB_FUNC( HB_PQCOPYFROMWA ) Question : how to use "PostgreSQL RDBMS low-level (client API) interface code" with CLASS TPQServer :?:

This is not true:

Yes, not true for MsAccess, MSSQL and ALL other RDBMS with ADO.
But true for Excel ADO recordset

... use memo fields. ( DataType 'M' ) If you are using any RDMS use BLOB fields. DBF: FIELD->IMAGE := MEMOREAD( "picture.jpg" ) RDBMS: oRs:image := MEMOREAD( "picture.jpg" ) If you are browsing in XBrowse, you can copy image from any source and paste into the ...

... use memo fields. ( DataType 'M' ) If you are using any RDMS use BLOB fields. DBF: FIELD->IMAGE := MEMOREAD( "picture.jpg" ) RDBMS: oRs:image := MEMOREAD( "picture.jpg" ) If you are browsing in XBrowse, you can copy image from any source and paste into the ...

... the bug a few days back when I was testing postgre samples. From now, we will pay equal attention to postgre support. It is really a wonderful RDBMS This is the bugfix: In xbrowse.prg, inside the method SetPostGreCol(...) please locate this line:            :cFooterPicture ...

... AND HDATE < '2023-02-01'" Note: It is safer to use "HDATE < (date + 1 )" than "HDATE <= (date)", because many RDBMS use datetime fields. How to easily generate these expressions? We better make it a habit to open an ADO connection using FW_OpenAdoConnection() ...

... If using ADO aDb := FW_AdoCatalogs( oCn )? AScan( aDb, { |c| Lower( c ) == cDatabase } ) This works for all RDBMS including MySql

We can not distribute servers. (server software)
But we can distribute any application using ADO or Harbour or FWH libraries either for free or at cost without any licenses to work with any RDBMS/database installed or hired by the user.

ADO is free for all of us and we can work with any RDBMS. In addition, Harbour provides an excellent Library for working with PostGre. I think we should be able to use this library even with HMG. For MySQL/MariaDB, we have FWH built-in library in ...

ADO is free for all of us and we can work with any RDBMS. In addition, Harbour provides an excellent Library for working with PostGre. I think we should be able to use this library even with HMG. For MySQL/MariaDB, we have FWH built-in library in ...

... good as well for MSSQL or is this only for MariaDB? ALL eg.,Dbase,FoxPro,MSAccess,Microsoft SQL,SQLite,Oracle,PostGre (natively) and any other RDBMS with connectionstrings.

... by your postings, we introduced automatic SeekNext by pressing F3 key from FWH2304. As of now, this works for arrays, DBF, TDatabase, all ADO rdbms, FW MySql. Yet to implement for dolphin,tmysql,eagle1,postgre, etc.

XBrowse and TDataRow (alias FW_Record) work with all kinds of datasources viz., dbf, tdatabase, ado (any rdbms), dolphin, tmysql, fw-mysql, postgre, eagle, etc. This enables the application programmer to write highly portable code. He can use exactly the same code with any ...

... morning There is a folder in c:\harbour\contrib\hbfbird\ that as it says: README 2003-12-23 - Harbour low-level API for Firebird and Interbase RDBMS This work is not finished yet. It's planned to be similar to Harbour TMysql routines. For full firebird documentation look at: Firebird home: ...

... )  This rolls back any modifications (including DBDELETE() and DBRECALL()) made to the current record in the current work area. Just like any RDBMS, RollBack does not work after COMMIT. FWH was using this feature in TDataBase class for many years. Please see METHOD RollBack(). Limitations ...