Hi Mike, You can try to set the max connections for th DB to 1. In theory Magic is forced to use a single transaction then, since there can be only one per connection. You also should check the lock

Now I’ve looked at this problem again, I’m not sure I’ve analysed the cause of it accurately. I open a (physical) transaction in UP, do a few updates, run a Direct SQL task which calls

Hi All Using UP 1.5 Just throwing this one out in case someone has a better solution than the one I'm planning to implement: We have an application which integrates to our customer's back-end CRM

Thank you for the reply Todd! I had actually played around with your method and managed to get it working. I was just trying to avoid having to add this to all programs in the future when we make

What I have been doing lately is using the program/task/form number in the 'User State Identifier' (Should maintain unique values that way), then adding another number or letter to the end, when the

Derek, Try this: Set a virtual in the Main Prog with the current version of your app. v_Current_Version Create a table named UserFormReset UserID | ProgamName | UserVersion

Hi all, I was wondering if anyone has any experience with modifying the FormUserState.xml file for their application manually. We have a client that has said our two FormStateClear() function keys

Problem solved: 1. Rechange fields from collation Latin1_General_BIN2 to database default 2. Set SQL database information: ONLINE_ARRAY_FETCHING=N BUT: I have to convert all tables with fields

Hi Florian, About evaluating 'Q'MODE as an alpha in runtime (V9 + XPA): that in fact does always give us an ascii 'Q' character. Just now I checked an old V9 export (with added indentation, and some

Hi, @Luuk: In the XMLs an InitialMode @val-value 'E' stands for "Query," while an empty value (or ommitted?) with an @Exp-value equal to an expression ID stands for "By Exp.". @Henning: I do not think

Doy you have an expression as your initial task mode? below is from 3.3a help: M Modify Edit existing records and delete records. This is the default mode. When you are in Modify mode, you can

Hi Florian, I think it has to do with local/language-settings. Do you habe the same mgconstw.xxx in both systems? Henning

Dear András, It's not simple example, you can find it on the server like /home/XXXXXXX(magic folder)/web_services/MobileDevices/src/com/XXXXX. This java source will "represent the webservices". Best

Hi Florian, I do not know the reason why MSE changed 'Q'MODE to 'E'MODE in expressions. In any case all tasks also contain a task property 'InitialMode' which is also 'E' for query mode (perhaps also

Hi all, I'm working on a migration plan to get our application from UP to XPA. What I stumbled on was that UP (and XPA) exports expressions like "IF (A,'C'MODE,'Q'MODE)" as "IF (A,'C'MODE,'E'MODE)".

Hi Gábor! Could you tell me, where exactly the "MobileDevices webservice sample" you mentioned before is? I cannot find it in the Sample Projects magic xpa 3.3. Or is that your private sample? Thank

Hi Tomasz, I am not aware of such a thing in iBOLT. Maybe you refer to the "5250 Connector" from Orgarat, a german company with plenty of "Magic & AS/400" know-how ? Not sure if they are still around

Sir check the below link - done in

maybe change: ALTER PROCEDURE [dbo].[LockInfo] to: CREATE PROCEDURE [dbo].[LockInfo] It's nice, most people who work with MS-SQL will have the need for someting like this. A example of the output:

Hi Folks, I have uploaded a MSSQL Stored procedure LockInfo() to the file area (https://magicu-l.groups.io/g/main/files/LockInfo.zip ). This stored procedure lists actual data of the locked record