Can't add into DA tables

Data Abstract
41

Hi,
If put it into the same unit, that has an error. But if put it into inherit BPL’s form package, it has an error of undeclare identifier.
Lastly, I put it into main unit that is OK without error. Thanks!

42

Hi,

I cannot reproduce this. at least compiler can compile code w/o any issues:

Untitled
Untitled959×726 99.8 KB

43

Sorry, I’m typo. It should be “If put it into the same unit, that hasn’t an error”. :sweat_smile:

44

Hi,
I tried the other SP that also has the same error. That SP is return the dataset. But it also has “Unable to obtain metadata for custom SQL” error when add into Schema Modeler. I guess it must have the same error if “Select” has “parameter”.

SP content as below.

SELECT top (@RecordCount) Order_No, Cust_Code, SC_Heading2
FROM Tx_CustOrderHeader WITH (nolock)
order by CreateDateTime desc

45

Hi,

I can reproduce issue when RecordCount parameter isn’t specified.
When I specify it, everything works as expected.

Have you specified correct value of RecordCount parameter?

46

Hi,
RecordCount is a parameter that let user to choose how many records to select. Then it can improve the performance that need not to load 90K records to DAMemDataTable. Default RecordCount is 5K when running the application. User can choose 10K or All if needs.

47

Hi,

as I already said - it works as expected:
animation

48

Hi,
Your sp1 is created by manually or drop & drag from connection’s SP?

49

Hi,

Drag&drop

animation