Page 2 of 2

Re: Xbase++ DBF application to Upsize PostgreSQL application

Posted: Sat Nov 04, 2023 1:45 am
by slobodan1949
E R R O R C O R R E C T I O N

In the source code I posted to the forum:
Alaska Xbase++ To PostgreSQL (Part 1-2-3-4).zip
there is a file C-PGDB.INI which was damaged by processing with NOTEPAD.EXE
(I didn't know it could do that too!)

so you have two options:

1. to delete file C-PGDB.INI and start the program
C-POSTGRESQL-DATABASE.EXE
who will make it again.
But then in it you need instead:
_db_=coba
write down
_db_=kasa

2. to use the C-PGDB.INI file that I send

The C-PGDB.INI file must have the following structure and content:

[COBA Systems]
[DATABASE]
_server_=localhost
_uid_=postgres
_pwd_=coba#1949
_db_=kasa
_she_=public
_tab_=coba_systems
_lAlert_=0
_lMsg_=0
_lDBcontrol_=0

otherwise, the connection string will not be correct which the program will
show in the error message.

Re: Xbase++ DBF application to Upsize PostgreSQL application

Posted: Sun Nov 05, 2023 3:29 am
by slobodan1949
PART 5b
Alaska Xbase++ To PostgreSQL (Part 5b).zip

and source code
Alaska Xbase++ To PostgreSQL (Part 5a-5b).zip
password=cobasystems

Re: Xbase++ DBF application to Upsize PostgreSQL application

Posted: Tue Nov 14, 2023 2:49 am
by slobodan1949
2023-11-11 COBA Systems
OPEN SOURCE PROJECT:
BAST
Business Account Software Techology
Application: Fiscal Cash register for sale of food and drinks in a restaurant
Aplikacija: Fiskalna Registar Kasa za prodaju hrane i pića u restoranu

DEMO APPLICATION: KASA-STOLOVI-DATABASE.EXE AND KASA-STOLOVI.EXE (SOURCE CODE)
Alaska Xbase++ 2.0 build 1503 and eXpress++ build 268
Database: PostgreSQL server ver. 9.4
COBA Systems auxiliary libraries:
BASE.DLL/LIB
BAZNEX.DLL/LIB
C-PGDB.DLL/LIB

Install PostgreSQL server 9.4 or later
Install the attached fonts
Install Alaska Xbase++ ver 2.0
Install eXpress++ 2.0
Set Windows to Serbian Latin font and set date German

Copy this folder to C: or D: or ...
Best to rename it to KASA because I don't know how some things will behave with folder names that have blanks
DLL/LIB/CH OR BIN/LIB/INCLUDE for Xbase++ and eXpress++ MUST BE INSTALLED AND AVAILABLE THROUGH THE PATH IN THE ENVIRONMENT

Build EXE applications at startup
KASA-STOLOVI-DATABASE.BAT -> KASA-STOLOVI-DATABASE.EXE
KASA-STOLOVI.BAT -> KASA-STOLOVI.EXE

If Xbase++ and eXpress++ RUNTIME (DLL files) are not in PATH, copy them all to this folder.


FIRST, START:

KASA-STOLOVI-DATABASE.EXE

to create a 'cash register' database
(now it creates all the tables and writes their names in the system table "alaska-software.isam.tables"
If you already have a 'kasa' database name, delete it and create it from this program.
From that program, enter data for 196 ARTICLES (products) items in the table 'kroba_11'

After that, start

KASA-STOLOVI.EXE

and read the INSTRUCTIONS:

Alaska Xbase++ To PostgreSQL (Part 5c source for application).pdf


Documentation for this application is provided in the files:

Alaska Xbase++ To PostgreSQL (Part 1).pdf
Alaska Xbase++ To PostgreSQL (Part 2).pdf
Alaska Xbase++ To PostgreSQL (Part 3).pdf
Alaska Xbase++ To PostgreSQL (Part 4).pdf
Alaska Xbase++ To PostgreSQL (Part 5).pdf
Alaska Xbase++ To PostgreSQL (Part 5a-5b).pdf
Alaska Xbase++ To PostgreSQL (Part 5c source for application).pdf

Note: I am available for all questions and clarifications

Re: Xbase++ DBF application to Upsize PostgreSQL application

Posted: Fri Nov 17, 2023 2:35 am
by slobodan1949
CORRECTIONS in the KASA-STOLOVI.EXE program:

(1)

from file:
1_KASA_stolovi_screen.prg
two lines of code should be deleted:
***************************************************************************
* " DONJI TOOLBAR"
*************************************************************************** END
PUBLIC HIDE:=.F. D E L E T E
oLOGO(GetList) // SHOW D E L E T E
*************************************************************************** START
* "STEALT BUTTONS"
***************************************************************************
These lines are repeated immediately before the DCGETOPTIONS command.


(2)

Should be added to __ARTICLES_CODEBOOK.PRG file and __ARTICLES_GROUP.PRG file
line: OWNER ooDlg in:

DCREAD GUI TITLE bTitle OPTIONS GetOptions ;
FIT ;
SETFOCUS @oBrowse ;
PARENT @oDlg ;
OWNER ooDlg ; // PUBLIC ooDlg -> 1__KASA_stolovi_scree.prg
MODAL ;
EVAL {|o| SetAppWindow(o)}