General information
Title:
Help sqlQueryString
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only