1. posterid:213707
  2. APG on DirecSQL [XPA2.5]

Re: APG on DirecSQL [XPA2.5]

Florian Groothuis
 

It only makes the correct return-virtuals, not the input-virtuals. Too bad...

 

 

 

Met vriendelijke groet - With kind regards,

Florian Groothuis
Analist/programmeur
+31 (0)6 21927914


meilink.eu
Meilink Beheer Borculo B.V. • Kamerlingh Onnesstraat 1
7271 AZ  Borculo • Nederland • +31 (0)545 253525
KvK 08009803 • Our general terms and conditions apply • Disclaimer


Van: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] Namens Tim Downie
Verzonden: dinsdag 23 mei 2017 11:32
Aan: main@magicu-l.groups.io
Onderwerp: Re: [magicu-l] APG on DirecSQL [XPA2.5]

 

The use is apg ...it makes all the correct virtual types to return the result in....the after you have done this go in and ad in :1 etc....this saves time chasing why it wont work.

Once you use sql task a bit, a lot of our sql tasks just have :1  in the sql pane  :1   is a large sql statement built in higher up tasks.

Example instead if a magic range to sum up a value on 5000 records....which means magic selects and reads 500 records adding them up as it goes.

In sql task :1   =   select sum(ordertotal) from orders where day = xx/xx/xx.

Sql does this for you- its instant and magic gets 1 value value back not 5000 record it then has to process

From: main@magicu-l.groups.io <main@magicu-l.groups.io> on behalf of Florian Groothuis <f.groothuis@...>
Sent: Tuesday, 23 May 2017 9:15:17 AM
To: main@magicu-l.groups.io
Subject: [magicu-l] APG on DirecSQL [XPA2.5]

 

Today I tried to use the APG-button in de DirectSQL-screen, but I can't see the additional value. Here's the statement I want to implement:

SELECT TOP(1) Waarde
FROM ST_StaffelsPCF
WHERE Vestiging= N':1'
AND Artikelnummer= N':2'
AND Kenmerk= N':3'
AND Argument= N':4'
AND Staffel>:5
ORDER BY Staffel

The program is called by 6 parameters, one of them being the output parameter. If I use the APG I get the following message.



If I remove all the parameters the APG works. But what's the use then?

Join main@magicu-l.groups.io to automatically receive all group messages.