dpQuerySplit() 3.17 NGA Error

[shokkul]

Hello all,

When are using dpQuerySplit() the last value of the query part value and the next beginning of the query part value are splitted. We tested the issue on 3.16 and it doesn't behave this way. How can I overcome this? You can find the example output below.

Thanks

.
.
.
112: dyn_anytype 10 items
1: System1:SomeDp(Type: 100 Sys: 1 Dp: 273 El: 0 : 0..0)
2: -?-
3: "Element"
4: -?-
5: -?-
6: "New Value"
7: -?-
8: -?-
9: -?-
10: -?-

]
[dyn_dyn_anytype 112 items
1: dyn_anytype 10 items
1: System1: SomeDp(Type: 100 Sys: 1 Dp: 273 El: 0 : 0..0)
2: 2020.12.22 09:56:59.167000000
3: -?-
4: "Property 107"
5: "Old Value"
6: -?-
7: "User"
8: "HMI"
9: "Value"
10: "Reason"
.
.
.

[leoknipp]

In the header you have written that you are using WinCC OA 3.17. The posting contains the information that WinCC OA 3.16 is used.
Which version and patch level are you using?

Please keep in mind that NGA in WinCC OA 3.16 is only a beta version and must not be used in a productive environment.

Best Regards
Leopold Knipp
Senior Support Specialist

[shokkul]

Hello Leoknipp,

Actually We switched into 3.17 p007 and currently using NGA and this problem currently occurs the example is from current system. Previoulsy we were using 3.16 and dpQueryConnect worked without any error.

[leoknipp]

In your last post you have written that you are using dpQueryConnect() and not dpQuerySplit().
Which function are you using?
Can you post the code snippet where the function is called?

We suggest to do an upgrade to the newest patch P009 for WinCC OA 3.17.

Best Regards
Leopold Knipp
Senior Support Specialist

[shokkul]

I am sorry for my second post its dpQuerySplit(). You can find the code snipped down below.

Code: Select all

sQuery = "SELECT " + sSelect + " FROM '" +DP+ "' WHERE _DPT = \"" +DPT+ "\"" + sTimerange + sSorting;
iErr = dpQuerySplit(g_iQuerySplitReqId, iProgress, sQuery, ddaTab);

[shokkul]

I just finished testing dpQuerySplit() with 3.17 p009 but it is still not working correctly.

[shokkul]

bump for the possible solution.