Search found 1168 matches

by Tom
Wed Oct 11, 2023 11:15 pm
Forum: PostGreSQL
Topic: DbRegisterClient() with PostGres
Replies: 15
Views: 3816

Re: DbRegisterClient() with PostGres

Having the company ID as a table column and/or having the business year as a table column is elegant and simplifies the work for the service. Database normalization is much easier when having all together. With a new project, I would go that way. But some authorities in Germany and Europe expect sep...
by Tom
Wed Oct 11, 2023 4:18 am
Forum: eXpress++ Support
Topic: Open database in thread ?
Replies: 6
Views: 1894

Re: Open database in thread ?

Hi, Victorio. Sometimes, closing tables fails for some reasons. The main reason is open relations, but sometimes, closing tables even fails because of record locks, some kind of scopes or other reasons. But: The runtime error system raises a "Table cannot be closed" error in that situation. Maybe yo...
by Tom
Wed Oct 11, 2023 2:37 am
Forum: eXpress++ Support
Topic: Open database in thread ?
Replies: 6
Views: 1894

Re: Open database in thread ?

How can I close database in all threads ? Close them in the threads. Put a DbCloseAll() just right before the "RETURN". Another way would be to transfer the tables from the workspace of the thread to the "zerospace" and collect them from there in the main thread. DbRelease() and DbRequest() can do ...
by Tom
Tue Oct 10, 2023 6:11 am
Forum: Xbase++ 2.0
Topic: Opening A Website
Replies: 16
Views: 4083

Re: Opening A Website

Since last year, Alaska delivers the "XbpHtmlViewer2"-asset with Xbase++ 2.0, which is a wrapper to the Microsoft WebView2 control, which is the base of Edge. This is a state-of-the-art-control to show any kind of HTML with all stuff needed in there. Just add the asset to your project and navigate t...
by Tom
Mon Oct 09, 2023 10:58 pm
Forum: eXpress++ Support
Topic: ADS
Replies: 24
Views: 5079

Re: ADS

There was no new ADS version since almost ten years. SAP bought the ADS because it was part of a kind of bundle. They were never really interested in improving the server. Anyway, it still runs and version 12 is stable. After SAP announced that it would also stop selling licenses, there were some in...
by Tom
Fri Oct 06, 2023 4:02 am
Forum: PostGreSQL
Topic: DbRegisterClient() with PostGres
Replies: 15
Views: 3816

Re: DbRegisterClient() with PostGres

Some of our tables are for one year only aswell. We added the year to the table name. No additional folder structure needed for that, works together with our multi-tenancy-model. The table opening method has a year number as an optional parameter. Edit: In addition, there is a get-set-function for t...
by Tom
Wed Oct 04, 2023 6:32 am
Forum: PostGreSQL
Topic: DbRegisterClient() with PostGres
Replies: 15
Views: 3816

Re: DbRegisterClient() with PostGres

Slobodan,

my way is a variant of solution #1, switching databases. This is what I'm doing for the (sub-)companies, while one connection for shared tables always stays open. I think we will finish this approach lately in November.
by Tom
Wed Oct 04, 2023 4:27 am
Forum: PostGreSQL
Topic: DbRegisterClient() with PostGres
Replies: 15
Views: 3816

Re: DbRegisterClient() with PostGres

And there is not a single PDR concerning schemes in the Alaska knowledgebase. :cry: To be a little more concrete. Upsized tables are always added to the "public" schema, and the PGDBE looks for tables only there . If schemes should be used to organize multi-tenancy, using the PGDBE and the upsize me...
by Tom
Tue Oct 03, 2023 11:42 pm
Forum: eXpress++ Support
Topic: Auto-open
Replies: 3
Views: 1586

Re: Auto-open

Hi, Fred. You may store this or all menu actions in an array: aActions := { ... , { || MDIBlock( {||Pudisp()},'Load Status Screen' ) } } , ... } Use this array when building the menu DCMENUITEM .... ACTION aActions[2] If you want one of these actions to be called elsewhere, just Eval() the item: IF ...
by Tom
Tue Oct 03, 2023 3:34 am
Forum: PostGreSQL
Topic: DbRegisterClient() with PostGres
Replies: 15
Views: 3816

Re: DbRegisterClient() with PostGres

I am urgently waiting for support for different schemes. We need this in order to be able to map our multi-tenant-model because the route via different databases is too unwieldy. But when I see how little has been implemented in the last Xbase++ update, my hope is fading. :( Here's what Alaska sugge...