Hello,
I have a series of pass-through queries that flush (TRUNCATE) and fill (INSERT INTO) Global Temporary Tables in SAP HANA. When I run them individually/manually, they execute as intended and populate the tables accordingly. However, when I automate their execution with VBA, the TRUNCATE (clear table) pass-throughs work but only the first INSERT INTO query appears to execute as intended. The other insert statements do not (e.g. table structure intact but no data).
Is it possible that the VBA 'DoCmd.OpenQuery...' sequence is initiating all pass-throughs at once causing each successive pass-through query in the sequence to be interrupted? If so, is there a VBA solution that will pause each successive query from executing until the preceding one has completed?
Thanks for any input and insight.
I have a series of pass-through queries that flush (TRUNCATE) and fill (INSERT INTO) Global Temporary Tables in SAP HANA. When I run them individually/manually, they execute as intended and populate the tables accordingly. However, when I automate their execution with VBA, the TRUNCATE (clear table) pass-throughs work but only the first INSERT INTO query appears to execute as intended. The other insert statements do not (e.g. table structure intact but no data).
Is it possible that the VBA 'DoCmd.OpenQuery...' sequence is initiating all pass-throughs at once causing each successive pass-through query in the sequence to be interrupted? If so, is there a VBA solution that will pause each successive query from executing until the preceding one has completed?
Thanks for any input and insight.