Search found 1174 matches

by Tom
Mon Oct 09, 2023 10:58 pm
Forum: eXpress++ Support
Topic: ADS
Replies: 24
Views: 5498

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: 4056

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: 4056

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: 4056

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: 1700

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: 4056

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...
by Tom
Mon Oct 02, 2023 4:42 am
Forum: Xbase++ 2.0
Topic: How to ALTER a Column using ADS SQL
Replies: 2
Views: 1492

Re: How to ALTER a Column using ADS SQL

The Advantage documentation for ALTER TABLE ALTER COLUMN is terrible.
This is true for the complete documentation.
by Tom
Fri Sep 29, 2023 6:48 am
Forum: eXpress++ Support
Topic: moving xbase/express to new computer
Replies: 11
Views: 3310

Re: moving xbase/express to new computer

for example, I have no idea what a '#pragma' means
Nobody knows that. 8-)

Glad to hear it works now.
by Tom
Wed Sep 13, 2023 11:01 pm
Forum: Announcements
Topic: BBS seems to be back up..
Replies: 8
Views: 3709

Re: BBS seems to be back up..

We all missed you too, Tom.
<3
by Tom
Wed Sep 13, 2023 6:51 am
Forum: Announcements
Topic: BBS seems to be back up..
Replies: 8
Views: 3709

Re: BBS seems to be back up..

I missed the board.