unable to make SQL request for remote system in distributed arhitecture

[vedadramovic]

Hello,
We are using distributed WinccOA system architecture that has multiple system along with its system names.
I am not able to make select that should get info from DP that are on other system either by dbQuery() or by WinccOA wizard that helps create SQL select.
SQL Select does not report any error but it returns 0 rows.

Is there something we should change in our distributed architecture?

Best regards,
Vedad Ramovic

[leoknipp]

Hello,

if you want to query data for a distributed system you have to use the REMOTE-keyword in your SQL-statement.
When calling the dpQuery-function you have to use the command getLastError() to check if an error occured.

For details please have a look at the WinCC OA online help.

Best Regards
Leopold Knipp
Senior Support Specialist

[vedadramovic]

Leopold,
thank you for fast and effective reply.
Besr regards,
Vedad