Hi All
I have a report using 5 temporary sql table when i try to change the table location and the table alias by programation it freeze on

-> ltable.Item(nt).Name = PrmaTable(nt,2)

Ex.:

Thisform.oReport = CREATEOBJECT('CrystalRuntime.Report')
Thisform.oReport = Thisform.oCrystalReports.OpenReport(PrmReport)

IF !EMPTY(PrmaTable)
IF !EMPTY(PrmaTable(1,1))
FOR nT = 1 TO ALEN(prmATable,1)
LDatabase = Thisform.oReport.Database
lTable =lDatabase.Tables
lTable.Item(nt).Location= PrmaTable(nt,1)
ltable.Item(nt).Name = PrmaTable(nt,2)
NEXT
ENDIF
ENDIF

Hi use this code with .dbf table and it's work fine

Any Tips

Ben