Search found 1173 matches

by Tom
Fri Oct 06, 2023 4:02 am
Forum: PostGreSQL
Topic: DbRegisterClient() with PostGres
Replies: 15
Views: 3985

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

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

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

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

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

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

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

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

Re: BBS seems to be back up..

I missed the board.
by Tom
Tue Jun 20, 2023 1:37 am
Forum: eXpress++ Support
Topic: XML Signature
Replies: 17
Views: 8476

Re: XML Signature

Hi, Diego. If you can't register LIBXML2.DLL with REGSVR32, although it's in your path and you're working as an administrator , maybe there are files missing needed by the library. Since I can't find a reliable source to download it from, I can't tell you which files are needed in addition. Some con...