4/19/2019 9:48 AM | |
Joined: 9/4/2018 Last visit: 3/11/2024 Posts: 58 Rating: (0) |
Pls any body help ! ! On my PDL, I've created "DB Grid Control" in ActiveX Control. Inserted this DB Grid as "Control3" on my PDF. I'm using following code. [Code Start] ' ------------------- Connection.Open 'Connection is pre-defind & working OK. Dim DBGrid Set DBGrid = ScreenItems("Control3") Dim rs_Grid Set rs_Grid = CreateObject("ADODB.Recordset") Dim m_StrTmp 'As String m_StrTmp = "Select * FROM Billet_Mast Where (CHARGE_NO = 'A01") order by Billet_No " rs_Grid.open m_StrTmp,Connection, 1, 3 If rs_Grid.eof And rs_Grid.bof Then Exit Sub End If Set DBGrid.DataSource = rs_Grid DBGrid.Refresh '-------------------- Connection.Close [Code End] The same code works well with VB6 application, unfortunately, doesn't with VBS in WinCC 7.4. Pls. note that I've already referred previous all threads but didn't get the confirmed solution. Kindly help. ------------------------------------------------------------------------------------------ |
Last edited by: NitG at: 4/20/2019 5:54:46 AMLast edited by: NitG at: 4/20/2019 5:56:16 AMLast edited by: Jen_Moderator at: 4/20/2019 12:30:08 PMNew subject after splitting |
|
4/21/2019 10:30 PM | |
Joined: 9/19/2009 Last visit: 4/19/2024 Posts: 458 Rating: (81) |
Hi Take a look to this topic, maybe can help you. Regards |
If my answer help you, use the Thanks or Rate Button, It is free of charge :-) |
|
Follow us on