Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQLQuerySting doesn't change
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
SQLQuerySting doesn't change
Miscellaneous
Thread ID:
00834417
Message ID:
00834417
Views:
49
Hi everybody!

I’m working with Crystal Reports 9 and need to change programmatically the property SQLQueryString in a report, I’m using this code ...
thisform.oReporte.Database.SetDataSource( “MyDataBase” )
thisform.oReporte.Database.Tables( 1 ).SetLogOnInfo( "MyDSNDriver", "MyDataBase", "user", "password" )
thisform.oReporte.Database.Tables( 1 ).SetSessionInfo( "user", "password" )
thisform.oReporte.SQLQueryString = "Select * From MyTable"
The value is not updated, but there’s not any error message neither ... any ideas

Thanks in advance,
Pablo van Diest (Senior Developer)
APSystems
Buenos Aires, Argentina
Next
Reply
Map
View

Click here to load this message in the networking platform