Good day,

I am trying to read number of columns in an sql table. The project should run on MTP1500 but i found out that debugging when using the panel is hard.

So at the moment I am using Wincc Unified PC runtime and Visual Studio code to debug the problem, but for the moment i am unable to find a solution.

I managed to make the connection and get the number of columns but I am unable to visualize this in any way on the screen.

In the attached screenshot is what i get in visual studio code.

I have a variable called row which is an object and I see that there is HMIInt64 property but i cant find a way to access the Lo or Hi part. I also tried the functions for working with Int64, but i was not able to get the the value in any way or form.

I would be grateful if someone can give me an advice what to do and how to make this work.

Best Regards,

DP

Hi!

Please share your database schema and SQL query and I'll try to help you. 

As for the HMIInt64 object, you can use parseInt() or just assign it to a tag to get it's value.

Edit: Apparently you could also use Object.values since the class constructor implements it. This function will return the object value as an array. Edit: only works if the result is HMIInt64.

Dimitar Peev

Good day,

I am trying to read number of columns in an sql table. The project should run on MTP1500 but i found out that debugging when using the panel is hard.

So at the moment I am using Wincc Unified PC runtime and Visual Studio code to debug the problem, but for the moment i am unable to find a solution.

I managed to make the connection and get the number of columns but I am unable to visualize this in any way on the screen.

In the attached screenshot is what i get in visual studio code.

I have a variable called row which is an object and I see that there is HMIInt64 property but i cant find a way to access the Lo or Hi part. I also tried the functions for working with Int64, but i was not able to get the the value in any way or form.

I would be grateful if someone can give me an advice what to do and how to make this work.

Best Regards,

DP

Here's an sql fiddle for the example: https://www.db-fiddle.com/f/6AUfmsJLnDD8Udcy63S8mC/4

Here's the query that I've used for the test: 

select storage.* from storage left join item_table item on item.id = storage.item_id where item.vin = 'TANURD29704'

Here's the code that I've used to run the query.

Here's the result in debug tool:

Hope the information was useful for you.

Edit: I've changed the query to further see the implementation details of the database result object for different data types.

Here's the query:

select 1 c1, 2.3 c2, 'string test' c3, false c4, null c5, array[10,20,30] c6, '2004-10-19 10:23:54'::timestamp c7;

Here's the screenhot for the result of the query in pgAdmin:

Here's the screenshot of the resulting object: