- This topic has 2 replies, 2 voices, and was last updated 4 months ago by
.
-
Posts
-
Good Day,
I can successfully connect to my SQL database and retrieve the latest data from a DB. I just have some general questions about the functionality and capabilities of this driver:
1. I have to assign each column in my SQL DB to an input channel. If I query correctly, then I will always read the latest variable from the table into my channel. Is there any way that I can read the whole table from SQL? Say I want to query ” SELECT TOP (10) “… Is it not possible to display the top 10 entries?
2. I have a primary key in my DB called “Date_Time_String” and it is nchar(50). The format is entered yyyy-mm-dd hh:mm:ss. This format seems to be too long for my input channel to display. My input channel only displays yyy-mm-d and then the string ends. It seems like I can only read (8) characters from the source. (The input channel type is configured as “REAL”). Is there any workaround for this?
Regards,
Hello,
1. The DB Import driver reads only 1st row. You may write a stored procedure to convert to 10 entries into 1 row.
2. Right, max. string length of input channel is 8 chars. In SQL request you should convert it to Unix time (integer seconds) and then use in Rapid SCADA. The details we could discuss on the forum.
- You must be logged in to reply to this topic.