Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help sqlQueryString
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Title:
Help sqlQueryString
Miscellaneous
Thread ID:
00677234
Message ID:
00677234
Views:
49
Hi
I have build a report with sql tables
Those tables are temporary table, i drop them after the print of the report
i try to to change my sqlquerystring with the name of the new table but crystal pop This message OBDC error:Microsoft OBDC SQL Server Driver SQL Server Zo0zo2t9 object name incorrect

The Zo0zo2t9 is my fisrt temporary table used to buid my report

Thisform.oCrystalReports = CREATEOBJECT('CrystalRuntime.Application')
Thisform.oReport = CREATEOBJECT('CrystalRuntime.Report')
Thisform.oReport = Thisform.oCrystalReports.OpenReport(PrmaSousRap(nr,1))

FOR nt = 1 TO LEN(PrmaSousRap(nr,2))
lnoTable = SUBSTR(PrmaSousRap(nr,2),nt,1)
LDatabase = Thisform.oReport.Database
lTable =lDatabase.Tables
lTable.Item(nt).Location= PrmaTable(lnoTable,1)
lTable.Item(nt).Name= PrmaTable(lnoTable,2)
NEXT

Thisform.oReport.SqlQueryString = ALLTRIM(PrmaSousRap(nr,4)) && On affect la query string

Any tips.
Reply
Map
View

Click here to load this message in the networking platform