Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: dospierredos
- Order by date
-
Change the sql string of a dataprovider with VBA
No, I am not calling the Refresh Method. I am just using this code: Sub sql_change() Dim bosql As DataProvider Dim bonewsql As String Dim bosqlresult As String Dim bodoc As Document Dim varname As String Dim i As Integer Dim j As Integer Set bodoc = busobj.ActiveDocument For i = 1 To...- dospierredos
- Post #3
- Forum: Business Objects solutions
-
Change the sql string of a dataprovider with VBA
I am trying to change using VBA the sql of a data provider (bodoc.DataProviders(i).sql),replacing some conditions with others. The query with those changes is bonewsql ,and when I assign it to the bodoc.sql, the data provider is automatically refreshed. I would like to change the sql without...- dospierredos
- Thread
- Replies: 2
- Forum: Business Objects solutions
