We use in some cases memory tables. Write the values in the mem table in the calling program And read the values of the mem table in the other program (s) which needs the parameters. It works just

if its a batch it will loop all records the sql statement finds -end = no before - works just like having a main table

Lado, see replies interspersed: At 04:36 PM 5/18/2017, you wrote: No. With Init expressions on the Columns selected within the LinkCreate/End Link operations, it is not necessary to do anything in

Hi Steve, Ok I got this to work. Just one question, is it a good idea to initialize variables to zero in the record prefix. It looks working without it. The APG creates output form but I deleted it

How it will loop the record? Should I use batch task No Before but there will be no main table but direct sql. Thx

Thts not going to work - Sql results needs to go into virtuals then init the link create with the virtuals or update var in record suffix From: main@magicu-l.groups.io <main@magicu-l.groups.io> on

Lado, Unfortunately, you cannot reference the Link Create operation's Realcolumns in the SQL Command window's Output Arguments dialog. You can onlyreference Virtual variables therein, and then Init

Hi Steve, Can you please see below and correct me if I am wrong. Its not adding record anyway in the memory table. Thx Lado

Alan, That still works, but is of course veryyyyy dangerous... Specially with a lot of different developers...!

Wow, that’s smart indeed…! Let call it from now on, the ‘Maquerade Technique’…. J Thanks! I will try to push this method… Ramon

Hi Ramon, I agreed that you should not leave at as is. That's called "technical debt" and will bite you in the tail sooner or later. There is another way to deal with the given situation: Copy the

Hi Steve, Ok, if that will work, it will solve my purpose. Let me try. Thanks a lot. Regards, Lado

Lado, The result of a Direct SQL task will NOT be written to a physical table IF you select a memory-based database for the Result Database. It would be nice if MSE gave us access to the memory

Hi Group, Is there any way we can load magic memory table with direct sql data without writing it first to physical table and then write to memory table ? Thanks Lado

Ramon, I don't know if this works in XPA, but up to uniPaaS 1.9 you could declare the "parameter" as a virtual and the called program would still receive a value into it if one is passed. No need

Hello Florian, Adding or disabling the checker warning might be okay for you and me, but the majority of Magicians I encounter freak out and don’t allow to do it like this. At the same

I don't have such a tool. You can, however, disable the checker warning. I prefer to leave it enabled though.

Adding is not the problem, all calls still work. What about deleting one... I would do nothing and adjust it when I encounter one. Met vriendelijke groet - With kind regards, Florian

Hello everybody, Nothing more annoying than have to add a parameter to a program which is being called 750 times…… Did somebody ever came out with a tool to auto skip not used

Hi Craig Finally got to testing v3.2 by posting a file though the requester - still has the bug - if your file contains a % you need up with some sort of control char when it gets to magic breaking