|
COM Interface Builder in Local Engine
Eduardo Coelho
Hi group, I'm trying to use the COM interface Builder with the Object Type in Local Engine. It created fine the dll , but when I trying to call the Method MagicEngieLoad. It's always returning Failed to load Magic Engine. It never started the Runtime Engine. I'm using Unipaas1.5sp2.I did tests with the XPA 2.3 but it didn't worked too. I'm trying to call the dll Local as a API not by Remote as Request Server. My ActivateRequest Server is inactive. I'm not using the Broker. I'm tried to call from C# and straight from a program Unipaas, but it not starting the Runtime Engine. I used the set properties from documentation as ApplicationName, MagicEnginePath and other. It's setting the properties but is not running the methods. My program method is not being executed too. I can see all the methods and the properties from magic but just the methods not being executed. Possibly because the Magic Engine not beeing running from the method. Has anyone ever experienced it? Thanks
|
||||||||
|
|
||||||||
|
Re: playstore magic xpa client
Todd Baremore
xxxx, As a rule, I never use the playstore app. Always use the apk installed at \RIAModules\Android\MagicDev.apk for the version of XPA you are working with. If you wish to build your own apk with your company logo and
other customizations, try the video below. At the 34:00 mark
devprops.txt and how to have your phone automatically locate it is
discussed. Todd
On 1/24/2017 11:27 AM,
xxxxxinet@... wrote:
|
||||||||
|
|
||||||||
|
Re: playstore magic xpa client
Diego Bale
Jordan. Thanks a Lot for your quick response
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
In V9:
"Open table in Reindex mode must be exclusive" ...
-----Oorspronkelijk bericht----- Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Steven Blank Verzonden: woensdag 25 januari 2017 1:47 Aan: main@magicu-l.groups.io Onderwerp: Re: [magicu-l] Changing A Btrieve index If all you do is drop and create indexes, you don't need to have exclusive access to the file. Of course, no one else can be using an index when you drop it, nor is any user allowed to begin a transaction during the time that the MKDE is creating the index. Luckily, creating an index is very, VERY fast. But yeah, Reindex mode is obscure for a reason. Steve
At 04:31 PM 1/24/2017, you wrote:
>Just thinking about complaints from the other users on the system since >it locks the table > >Sherm > > >> On Jan 24, 2017, at 7:21 PM, Steven Blank <sgblank@...> wrote: >> >> Sherm, >> >> Ideally, yes - run only once. >> >> But running it more than once won't hurt anything. Magic drops the old index by number and creates the new index as the index is defined in the Tables Repository. Running the program more than once will just drop and recreate the same index structure. >> >> Benign redundancy. >> >> Kinda like me. >> >> Steve Blank >> >> >> At 03:59 PM 1/24/2017, you wrote: >>> Steve, >>> >>> If I understand you correctly, you would write just one program to >>> do this....and ensure that it's run only once, as the first action >>> by the first person who uses the new version. >>> >>> ? >>> >>> Sherm >>> >>> >>>> On 01/24/2017 06:55 PM, Steven Blank wrote: >>>> Hi Jim, >>>> >>>> Using the Reindex option for a program's Open mode will work ok - the index will be dropped and recreated when the program is executed; no data will be lost. However, you'll have to disable Check Definition for the Database beforehand. You can turn it back on after the file has been reindexed. >>>> >>>> You could also achieve the same thing using the Btrieve Maintenance Utility. Open the Information Editor and get information for the file. Then use the Index menu's Drop... and Create... options. >>>> >>>> Steve Blank >>>> >>>> P.S. Come to think of it, you may run with CheckDef turned off all >>>> the time, in which case, never mind. ;) >>>> >>>> >>>> >>>> At 03:03 PM 1/24/2017, you wrote: >>>>> Hi, >>>>> >>>>> I use Magic 8.3 and Btrieve. I need to change an index on one of the databases. If I change an index on a database in a control file and then release the code with a program that does a “Reindex†when I open the file, will it reindex the database without exporting and importing the data? Or will it corrupt the file? >>>>> >>>>> Jim Gelles >>>>> Membership Management Services >>>>> 818/988-0008 >>>>> >>>> >>>> >>> >>> >>> >> >> >> >> > > >
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
What about trying the following
Have an instance of Magic running on the server and not from a user that has a passed in parameter that tells Main Program to run a Magic Rebuild program.
In the Data Repository, change the indexes that you want but do not run the conversion.
Duplicate the table in the repository and give it a new name (something like <original filename_tmp>, but not .tmp because Pervasive’s locking doesn’t recognize name differences based on the extension (at least from what I remember)
The program (999) defined above does the following when launched from Main Program
Block Loop Try to rename the original filename to the _tmp filename. This has a delay and continues to loop until the rename is successful. End Loop
Call a subtask (999.1) that opens the original file (which now has been renamed so doesn’t exist) as Read/None. This creates an empty file but because it has the share of the file set to none doesn’t allow any other program using the table to run. This task is set to end task = Yes, Before.
This subtask (999.1) in task suffix, calls another subtask that does the following:
Subtask (999.1.1) Opens the duplicated _tmp table as Write/None/Reindex. This task has end task = Y, Before. Once this task ends, the indexes will be dropped and rebuilt.
The program returns to subtask (999.1) and then exits back to the parent root task (999) and in the next statement after the call subtask to (999.1) has Block Lopp Try to Delete the small empty original table created by the subtask Continue loop until it can be deleted End Loop
Block Loop Try to rename the _tmp table that had the index rebuilt back to the original filename. Continue loop until the table renames End Loop
Parent program now ends and returns back to Main Program. Exit Magic
HTH
Keith
From: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] On Behalf Of wes@...
Sent: Tuesday, January 24, 2017 8:29 PM To: main@magicu-l.groups.io Subject: Re: [magicu-l] Changing A Btrieve index
But in our case we have close to 250 clients and all of them will get a definition mismatch. When clients receive an update all users must be out of the system, the the first user back in will trigger the conversions. As we are working toward SQL, we have changed alot of our table definitions to make the transition easier. This has taken a big load off our support team as they don't have to worry about running conversions! In addition, if a 'scratch' file has changed and deleting it doesn't hurt anything, we just delete the file and re Declare it in the main program. We also take 2 additional precautions. 1) We have a 1 field, 1 index test table that is never used or changed. We have experienced on rare occasions that Pervasive does not load as expected so an 'unknown database' error occurs on the first file uniPaaS attempts to open (when this happens it really screws things up because the first definition rebuild occurs thinking there is a definition mismatch even though there isn't ) The first call in our main program is a subtask to 'Declare' this test table, if there is ANY error, we give the user a message they must restart our application and then exit without processing the main program logic. 2) When a definition mismatch occurs we write a ConversionInProgress.txt file so anyone logging in with this file in existense will get a message that conversions are running please try again later, then exit the application without executing any more of the main program logic. This way only one user will run all the necessary conversions. The last operation in the main program is to delete the text file after all the conversions have been completed. On occasion should something go south and this file doesn't get deleted, we have had to manually delete it. Wes
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
Wes Hein
But in our case we have close to 250 clients and all of them will get a definition mismatch. When clients receive an update all users must be out of the system, the the first user back in will trigger the conversions. As we are working toward SQL, we have changed alot of our table definitions to make the transition easier. This has taken a big load off our support team as they don't have to worry about running conversions! In addition, if a 'scratch' file has changed and deleting it doesn't hurt anything, we just delete the file and re Declare it in the main program. We also take 2 additional precautions. 1) We have a 1 field, 1 index test table that is never used or changed. We have experienced on rare occasions that Pervasive does not load as expected so an 'unknown database' error occurs on the first file uniPaaS attempts to open (when this happens it really screws things up because the first definition rebuild occurs thinking there is a definition mismatch even though there isn't ) The first call in our main program is a subtask to 'Declare' this test table, if there is ANY error, we give the user a message they must restart our application and then exit without processing the main program logic. 2) When a definition mismatch occurs we write a ConversionInProgress.txt file so anyone logging in with this file in existense will get a message that conversions are running please try again later, then exit the application without executing any more of the main program logic. This way only one user will run all the necessary conversions. The last operation in the main program is to delete the text file after all the conversions have been completed. On occasion should something go south and this file doesn't get deleted, we have had to manually delete it. Wes
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
Too soon to tell.
toggle quoted messageShow quoted text
We'll have to wait and see how many believe it. Steve
At 05:04 PM 1/24/2017, you wrote:
Was I at least alt+correct?
|
||||||||
|
|
||||||||
|
Re: playstore magic xpa client
Jordan Slappendel
 Kind Regards Jordan Slappendel  PO Box 1186, Rotorua, New Zealand Ph Office: +64 7 350 1174 DDI: +64 7 282 2431 Fax: +64 7 350 1185 This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorised and may be illegal.
On Wed, Jan 25, 2017 at 2:09 PM, Jordan Slappendel <jordan@...> wrote:
|
||||||||
|
|
||||||||
|
Re: playstore magic xpa client
Jordan Slappendel
Yes this is for testing without compiling the APK. Yes you will need to update the generic one with your app details. These 3 things need to be changed.  The DevProp.txt file will then need to be saved into c:\xpa25\scripts Kind Regards Jordan Slappendel PO Box 1186, Rotorua, New Zealand This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorised and may be illegal.
On Wed, Jan 25, 2017 at 12:21 PM, <xxxxxinet@...> wrote:
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
sherman levine
Was I at least alt+correct?
toggle quoted messageShow quoted text
Sherm
On Jan 24, 2017, at 7:46 PM, Steven Blank <sgblank@...> wrote:
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
If all you do is drop and create indexes, you don't need to have exclusive access to the file. Of course, no one else can be using an index when you drop it, nor is any user allowed to begin a transaction during the time that the MKDE is creating the index. Luckily, creating an index is very, VERY fast.
toggle quoted messageShow quoted text
But yeah, Reindex mode is obscure for a reason. Steve
At 04:31 PM 1/24/2017, you wrote:
Just thinking about complaints from the other users on the system since it locks the table
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
sherman levine
Just thinking about complaints from the other users on the system since it locks the table
toggle quoted messageShow quoted text
Sherm
On Jan 24, 2017, at 7:21 PM, Steven Blank <sgblank@...> wrote:
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
Wes,
toggle quoted messageShow quoted text
Certainly good practice if you need to alter record structure. However, if all you need to do is add, modify, or delete, one or more indexes, then you don't need to rebuild the file; you can just drop and/or create index(es) in place, via either the Btrieve Maintenance Utility (my preference) or Open:Reindex. Steve Blank
At 04:00 PM 1/24/2017, you wrote:
Jim,
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
Sherm,
toggle quoted messageShow quoted text
Ideally, yes - run only once. But running it more than once won't hurt anything. Magic drops the old index by number and creates the new index as the index is defined in the Tables Repository. Running the program more than once will just drop and recreate the same index structure. Benign redundancy. Kinda like me. Steve Blank
At 03:59 PM 1/24/2017, you wrote:
Steve,
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
Wes Hein
Jim, Unless someone else knows a way, you must copy the original definition in your control file that matches your clients data with a new file name, create a program to export/import the data either with a link create or import/export text files, then update the definition with the file changes you need. Your original file will not be corrupted, any programs using the original file will get a Definition Mismatch error and close. There are 2 ways to hande the conversion, 1) if you have a small number of clients, put the conversion program in the menus and run it when you give them the update, or 2) this is my process to run the conversion automatically. Keep in mind I haven't worked in 8.3 for about 10 years so hopefully this should work. Don't beleive 8.3 has an else option for blocks so you will probably need to create 2 sepearate ones. Create 2 logical virtuals in the main program v.DefinitionMismatch, v.ConversionError Call a subtask to Declare the file in question that may require conversion, if there is an error, set Magic to ignore it and update v.DefinitionMismatch to True Block: v.DefinitionMismatch = True Rename file to the conversion file name Run the conversion - send the v.ConversionError virtual to this program and on any error trap it and set v.ConversionError to True. Block: v.ConversionError = False Delete renamed conversion file Else Delete new file created Rename old file back to original name so you don't lose data. End Block update v.DefinitionMistach and v.ConversionError to false End Block Repeat for additional conversions Wes
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
sherman levine
Steve,
toggle quoted messageShow quoted text
If I understand you correctly, you would write just one program to do this....and ensure that it's run only once, as the first action by the first person who uses the new version. ? Sherm
On 01/24/2017 06:55 PM, Steven Blank wrote:
Hi Jim,
|
||||||||
|
|
||||||||
|
Re: Changing A Btrieve index
Hi Jim,
toggle quoted messageShow quoted text
Using the Reindex option for a program's Open mode will work ok - the index will be dropped and recreated when the program is executed; no data will be lost. However, you'll have to disable Check Definition for the Database beforehand. You can turn it back on after the file has been reindexed. You could also achieve the same thing using the Btrieve Maintenance Utility. Open the Information Editor and get information for the file. Then use the Index menu's Drop... and Create... options. Steve Blank P.S. Come to think of it, you may run with CheckDef turned off all the time, in which case, never mind. ;)
At 03:03 PM 1/24/2017, you wrote:
Hi,
|
||||||||
|
|
||||||||
|
Accounting Software Base on U.S. GAAP Standard - uniPaas 1.9
Lado Wali
Hi Group, My company is looking for a Accounting Software written in uniPaaS 1.9 based on U.S. GAAP Standard and it should be better than Sage 50 Quantum. If some has written accounting software that can fulfill our requirement and can be linked with our current ERP software which is also written in uniPaaS 1.9 and can use our purchase order system please contact. Our company need to evaluate the software with our accounting department to analyze to their need. You can also write the email to my private email at ladowali@... . Thanks Lado
|
||||||||
|
|
||||||||
|
Re: uniPaaS 1.9d - All Control files suddenly left to 1 KB
Lado Wali
Thanks Heidi, yes you are right, the edp files are really small 1 kb files always but the source are sitting in the source folder. Our source folder got deleted with the Osiris virus last week. Our tech team had to restore the whole server from the backup. Regards, Lado
On Sat, Jan 21, 2017 at 5:34 AM, Heidi Schuppenhauer <heidis13@...> wrote:
|
||||||||
|
|
||||||||
|
Re: playstore magic xpa client
Diego Bale
HI’ Jordan Thanks for your answer. I’ve never used that. Is this for testing your app without compiling the APK ?
The DevProps.txt I found is located in C:\xpa25\RIAModules\Android
But is a generic one. Do I need to build one with the right parameters in order to run the app without compiling the apk ?? Where should i put that file ?
Thanks a lot!
|
||||||||
|
|
