Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Help sqlQueryString
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Crystal Reports
Titre:
Help sqlQueryString
Divers
Thread ID:
00677234
Message ID:
00677234
Vues:
48
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.
Répondre
Fil
Voir

Click here to load this message in the networking platform