Search found 1173 matches

by Tom
Tue Oct 17, 2023 4:10 am
Forum: eXpress++ Support
Topic: ADS
Replies: 24
Views: 5397

Re: ADS

Don't hesitate to modernize and advance your applications with true SQL. Its not the future, its the present and you have to catch it. SQL is just language . It's a way to get data back from a database. SQL ist not a technique (not a technical solution). You can have bad or good servers, or good or...
by Tom
Mon Oct 16, 2023 6:21 am
Forum: eXpress++ Support
Topic: ADS
Replies: 24
Views: 5397

Re: ADS

Are you saying that this is possible now?
No, it isn't. There is an upsize file (XML) and the DbfUpsize() function, which does the job. But we created our own UI for that, using the responses of DbfUpsize(). The function still awaits physical tables.
by Tom
Sun Oct 15, 2023 11:42 pm
Forum: eXpress++ Support
Topic: ADS
Replies: 24
Views: 5397

Re: ADS

These are the most important tasks: 1. Get the upsizing done. We don't use the automatic upsizing. We create upsize files by ourselfes and control the work of the dbfupsize.dll. You need server data in your app, you may need to create the target database with SQL, which is not a big issue. Good to k...
by Tom
Sun Oct 15, 2023 7:16 am
Forum: eXpress++ Support
Topic: ADS
Replies: 24
Views: 5397

Re: ADS

This should take significantly less time than a year.
by Tom
Sun Oct 15, 2023 4:41 am
Forum: eXpress++ Support
Topic: ADS
Replies: 24
Views: 5397

Re: ADS

We moved a really large, very complex application to PostGreS using PGDBE/ISAM. Migration was about one hundred times faster than moving all navigational code to SQL. The result works excellent, is much faster than any ADS version ever was, is easy to maintain and very reliable. Access from other ap...
by Tom
Wed Oct 11, 2023 11:15 pm
Forum: PostGreSQL
Topic: DbRegisterClient() with PostGres
Replies: 15
Views: 3987

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

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

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

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

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...