Is there a way to maximize XPA with action inside of XPA? The system toolbar is hidden ... Is there a c# code or some other windows function to do this?
I have tried "call windowMode" in a batch file and it does nothing. Tried "call windowMode" with title and pid and had no success. I also tried winmax(), winrestore() ...

Any ideas if this is even possible?

Regards,
A

Charles and Michael, thanks for your helpful replies!

I use MySQL Community Edition. Free and works with Magic Express license. Works great!

Mike,
I would start here:
Migrating DB2 Databases to SQL Server (DB2ToSQL) - SQL Server | Microsoft Learn

Run the SQL Server Migration Assistant to completion and then change your Magic DB source entries from DB2 to SQL Server.

Also check out this resource: Migrate Databases From IBM Db2 to SQL Server in 8 Easy Steps - Learn | Hevo (hevodata.com)
Charles

PS - the BB2023 treats were enjoyed, thank you :)

--
Charles Coe, CPA, MCSE

New Orleans, Louisiana

Doing some research..., I'm sure this has an easy and non-controversial answer :)...

What's the best free / low cost SQL (or non-sql) DB for Magic & AWS these days?

We plan to move our XPA application's data from legacy DB2 to MS SQL server.

I am considering one of the turn-key services (i. e. GoUp), developing an internal procedure, hiring SQL consultant.

It seems that there are three activities:

1. Create the MS SQL database & schema
2. Change the XPA project's data source entries from DB2 to MS-SQL
3. Migrate the data from DB2 to MS-SQL

Does anybody have any experience or suggestions in evaluating the best way to complete this?


Thank you.

The following files and folders have been uploaded to the Files area of the main@magicu-l.groups.io group.

• /ColorFontUtils.zip

By: Bob Witte <BobWitte@...>

Description:
Even more help with converting v8 files to v9.

Thanks Hans!  By way of another friend of mine in your neck of the woods, I'm uploading another copy of not only MSE's original Zip, but some other useful utilities as well.  This will help any even later arrivals to this need than my procrastination self.  This much larger file is called "ColorFontUtils.zip"

Normally that is a good idea and actually, I did just that a few weeks ago.  But like what happens to so many of us, her copy of the Zip file apparently went the way of some of our constitutional rights and just disappeared.

Hello,

i have an application which is 45MB large. This app also has components. And those components also have their own components ...
The total size is between 120MB and 130MB.

In my working environment this application loads in 15 sec. But at one customer it takes 35 sec before the 1st component even starts
loading and it takes 35 sec before the 1st line appears in logging file ...

I do believe all the security and other stuff contributes to this. But is there any way to speed this up? Any ideas?

Also one question about components. Lets say i have apps A, B, C, D
A has D
B has A and D
C has A, D and B

And if i open up the C app, how many times should the D component load? 3 times or just 1?

Thank you.

Steven,
Thank you for this last explanation, it clears up a lot of questions.
Thanks
Andy

Yep, I have it and it recommends using the ColorFont.zip utility, thus my request.

After 36 years of using this stuff, I have lots of changes below the 100 mark and even more over 100.

Andy,

Again, please see replies interspersed:

Steven,

I tried using the open mode Reindex as John suggested, but it kept stopping along the way to index ...

This observation is prima facie evidence that your program tree opens and closes the data file, repeatedly, during the process.

When Open=Reindex in a task, Magic drops all indexes once,  immediately after opening the file but before executing the task's Task Prefix. Magic subsequently recreates those indexes also only once, immediately after the task's Task Prefix has been executed but before closing the file. (You can observe this activity in Magic's Monitor using a simple test program with a dummy file.)

This means that, if you observe evidence of indexes being rebuilt repeatedly during the data load process, it can only be because the specific task in which the table is being opened in Reindex Mode has completed processing its entire Data View and its Task Suffix — also repeatedly.

In this case, you need to open the affected data file in Reindex Mode at least one level farther up the task tree.

On the other hand, if what you observe are simply lulls in processing, when everything seems to pause, it's more likely that the server has had to pause client-comms while it flushes its dirty cache buffers to disk. (suggests a larger cache?) I suggest you use the Zen Monitor to observe activity quantitatively.

And if I were to create the table with no indexes, it may be much faster creating the table, but would it not then take just as long later to build the 5 indexes once the 2 billion records are in?

No. When loading a new Btrieve data file, it's always significantly faster to load the data and then add indexes, separately, rather than having to maintain all existing indexes (lots o' juggling goin' on) in real time. If Magic won't/can't do it for you using Reindex Mode, then yes, by all means, create the empty file without any indexes (or use BUTIL to drop them from an empty file first) and then, after the data has been loaded, add the indexes one at a time using the Btrieve Maintenance Utility.

... and eventually jammed up the machine.

Last, regardless of whether you get Reindex Mode to work or use BUTIL to drop and add indexes manually, it just takes a long time to add indexes on a gazillion records — especially that 254-byte whopper — perhaps even as long or longer than it took to add the data in the first place.

Again, during reindexing, you can use the Zen Monitor to observe the MicroKernel Sessions' Read Records counts and other activity, if only to reassure yourself that the reindexing process is not hung, even if Windows reports "Not Responding" somewhere.

Thanks

Andy

HTH.

Steven G. Blank
Ξ SGBlank Consulting