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?