bb.donnay-software.com

Moving an DBF-based program to PostgreSQL, is a good idea using transaction. But in existing source code I use Rlock(). My questions are: - if Rlock() with PgDbe make simple transaction? - is possible "group" more updates (with RLock()) with BEGIN TRANSACTION... END TRANSACTION or is here an conflic...

I solved these problem. With DCBROWSE based on DC_XbpBrowse class from Express 252 works good (wrong was
DC_XbpBrowse class from Express 242). C'est la vie and now back to tests

Piotr

Jimmy,
I now that these command work properly "inside" PgAdmin. I use these with ODBCDBE (with MSSQL) and in
this case I can "USE" table with these information. Alaska's Xbase 2.0 Guide is incomplete, and informations
about use PgDbe with SQL language are very poor...

Piotr

Jimmy, are you sure? These problem exist only if deleted record(s) is/are first or last record in selected scope. If these are "inside scoped group" of records, are not visible (SET DELETED is ON!) and all works correctly. But when deleted record is first (the same with last) in "scoped group" of re...

Hi, I still test Pgdbe using Express library. Now I have problem with deleted records. I use a table, set scope with DC_SetScope(), (for example, record #1 is not deleted, record #2 is deleted (in column __deleted is TRUE)) after DC_DbGoTop() only not deleted records are available (I test it wit DO ...

Jimmy, when I use directly in my source: SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME like 'V_%' ORDER BY TABLE_NAME I becam an error during compilation [Hint] : usqlstmt(1) : lexer error 1 : [Hint] : Unexpected character at offset 43, near 'A' : [Hint] : ABLES WHERE TABLE_NA Wh...

Roger
thanks for your reply. In this case in DCBROWSE a THUMBLOCK option os a good solution for the vertical scrollbar.
Piotr

Hi,
how can I simulate ADir() and Directory() functions on PostgreSQL tables?

Piotr

Hi Roger, hi all, after a few years i am back ;) Last week I begin test with Alaska Xbase 2.0 with PostgreSQL. My first experience was good, it's look like a good way for transformation existing DBF-version to SQL. For me is important, that it's possible to have only one (the same) version of PRGs u...