Datasource override with multiple statements

N Meffle

January 27, 2026 10:57

Hi guys,

when logging the queries of the DIN layout, the OpenOrders part gets executed in multiple parts:

-- 2026-01-27 10:48:03.5750
-- Query OpenOrderQuantities
/* ***** General Information ***** Name: OpenO  [...]
-- 2026-01-27 10:48:03.6310
-- Query OpenOrderQuantities
/*Create Temp Table before inserting values, a  [...]
-- 2026-01-27 10:48:03.6340
-- Query OpenOrderQuantities
INSERT INTO "#SWA_LD_OPENORDERITEMTRANS" SELECT "T1"."PK"  [...]
-- 2026-01-27 10:48:03.6580
-- Query OpenOrderQuantities
SELECT "T0".* , "T1"."ItemCode" , [...]
-- 2026-01-27 10:48:03.6820
-- Query OpenOrderQuantities
DROP TABLE "#SWA_LD_PartialPositions1"
-- 2026-01-27 10:48:03.6820
-- Query OpenOrderQuantities
DROP TABLE "#SWA_LD_OPENORDERITEMTRANS"

However, when i try to use the @@Overwrite, i need to fit all these statements into a single query, right? I've not been able to do this successfully, as whenever i execute the layout the entire code gets put into a single line and only the first CREATE statement gets executed, the rest is ignored. (Yes, i did play around with removing/adding comment blocks.) Or is there a way to achieve this step-by-step execution with multiple @@Overwrite queries?

Use case is: I want to be able to see the OpenOrderQuantities on a draft delivery so i need to extend the first query to also include lines from DRF1 etc.

Anyone got helpful input on this one? Cheers!

0

• 

  Lothar Hasenkämper

  January 27, 2026 11:09

  Hi,

  I have no clue if it possible to do it in that way.
  Depending on the amount of needed Data would be LD.QueryData("")  a solution, or adding a complete new query and an extra Databand for draft open qty.
  regards Lothar

  0

Please sign in to leave a comment.