Read And write data from sql server in factory talk view se v12

[Ganeshjangam]

How to fetch data from Microsoft sql server into ftv?

I wanted to create form and store all the data into sql database...

Also i need to search by perticular columns data and fetch entire row and modify that

So please need help

Thanks in advance...

 

[parky]

perhaps have a look at this post.

http://www.plctalk.net/qanda/showthread.php?t=128370

There is a lot of information in the above thread, you will need to use VBA within FTV, although putting data in tables is easy using datalogs no programming, to fetch & change data would require VBA & a knowledge of System query language.