ValidateFieldNames/TableNames
Hi
For many years I have used Report Builder with the
ppDictionary1.ValidateFieldNames and ppDictionary1.ValidateTablesNames both
set to False as I use a technique for running temporary tables in a
different folder from the main data, using temporary tables and field names.
This has worked well until 11.02 when we keep getting reports of an error
List index out of bounds (-1) - see call stack below.
If I add the fields to the dataDictionary the error does not occur.
Any advice?
Regards
Call Stack Information:
-----------------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class
|Procedure/Method |Line |
-----------------------------------------------------------------------------------------------------------
|Running Thread: ID=4624; Priority=0; Class=; [Main]
|
|---------------------------------------------------------------------------------------------------------|
|00AF6B4B|Alarm.exe |daMetaData.pas
|TdaMetaTableCollection|GetItemByRawTableName |1159[2] |
|00AF6B00|Alarm.exe |daMetaData.pas
|TdaMetaTableCollection|GetItemByRawTableName |1157[0] |
|00AF673A|Alarm.exe |daMetaData.pas |TdaMetaCache
|GetTableForRawTableName |935[2] |
|00AF6714|Alarm.exe |daMetaData.pas |TdaMetaCache
|GetTableForRawTableName |933[0] |
|00AF5B83|Alarm.exe |daMetaData.pas |TdaMetaData
|GetTableAlias |411[5] |
|00AF5B44|Alarm.exe |daMetaData.pas |TdaMetaData
|GetTableAlias |406[0] |
|00AF7149|Alarm.exe |daMetaDataManager.pas|TdaMetaDataManager
|GetTableAlias |196[7] |
|00AF70EC|Alarm.exe |daMetaDataManager.pas|TdaMetaDataManager
|GetTableAlias |189[0] |
|00B094B0|Alarm.exe |daSQL.pas |TdaSQL
|CreateTableAlias |3689[3] |
|00B09450|Alarm.exe |daSQL.pas |TdaSQL
|CreateTableAlias |3686[0] |
|00B06574|Alarm.exe |daSQL.pas |TdaSQL |AddTable
|1770[8] |
|00B0651C|Alarm.exe |daSQL.pas |TdaSQL |AddTable
|1762[0] |
|00B012AA|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GetSelectTables |853[12] |
|00B0F0A4|Alarm.exe |daSQL.pas |TdaSQL
|GetAvailableLinkTypes |8229[0] |
|00AFFF9F|Alarm.exe |daLinkBroker.pas |TdaLinkBroker
|GetLinkType |485[2] |
|00AFFD94|Alarm.exe |daLinkBroker.pas |TdaLinkBroker
|GetLinkCount |302[1] |
|00AFF99B|Alarm.exe |daLinkBroker.pas |TdaLinkBroker |Assign
|123[8] |
|00B0121C|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GetSelectTables |841[0] |
|00B01FD0|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GetSQLInfo |1240[15] |
|00B02114|Alarm.exe |daMagicSQL.pas |TdaMagicSQL |GetLinks
|1302[4] |
|00B01F5C|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GetSQLInfo |1225[0] |
|00B0086E|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GenerateMagicSQL |411[4] |
|00B09413|Alarm.exe |daSQL.pas |TdaSQL
|CreateMagicSQLText |3656[6] |
|00B093F0|Alarm.exe |daSQL.pas |TdaSQL
|CreateMagicSQLText |3650[0] |
|00B09384|Alarm.exe |daSQL.pas |TdaSQL
|GetMagicSQLText |3608[7] |
|00B09364|Alarm.exe |daSQL.pas |TdaSQL
|GetMagicSQLText |3601[0] |
|00E353C9|Alarm.exe |daAds.pas |TdaADSQueryDataView
|SQLChanged |1181[6] |
|00B17649|Alarm.exe |daQueryDataView.pas |TdaQueryDataView
|RefreshQuery |928[6] |
|00B17978|Alarm.exe |daQueryDataView.pas |TdaQueryDataView
|ReportBeforePrintEvent |1065[4] |
|00B145EA|Alarm.exe |daDataView.pas |TdaCustomDataView
|EventNotify |222[5] |
|00B145C0|Alarm.exe |daDataView.pas |TdaCustomDataView
|EventNotify |217[0] |
|00B16C9B|Alarm.exe |daQueryDataView.pas |TdaQueryDataView
|EventNotify |428[2] |
|0098C7BE|Alarm.exe |ppComm.pas |TppCommunicator
|SendEventNotify |800[14] |
|0098C768|Alarm.exe |ppComm.pas |TppCommunicator
|SendEventNotify |786[0] |
|00962479|Alarm.exe |ppProd.pas |TppProducer
|TriggerCodeModuleBeforePrint|2281[5] |
|00962460|Alarm.exe |ppProd.pas |TppProducer
|TriggerCodeModuleBeforePrint|2277[1] |
|00968388|Alarm.exe |ppClass.pas |TppCustomReport
|TriggerCodeModuleBeforePrint|4042[2] |
|008D3639|Alarm.exe |ppEngine.pas |TppEngine |Init
|2130[18] |
|008D13FE|Alarm.exe |ppEngine.pas |TppEngine |Generate
|545[8] |
|008D13E0|Alarm.exe |ppEngine.pas |TppEngine |Generate
|537[0] |
|008D1322|Alarm.exe |ppEngine.pas |TppEngine
|RequestPage |501[30] |
|0097D6B4|Alarm.exe |ppReport.pas |TppReport
|RequestPage |1977[25] |
|00958561|Alarm.exe |ppDevice.pas |TppPublisher
|DoOnPageRequest |1248[11] |
|00958520|Alarm.exe |ppDevice.pas |TppPublisher
|DoOnPageRequest |1237[0] |
|0095833B|Alarm.exe |ppDevice.pas |TppPublisher |Publish
|1058[16] |
|009582D8|Alarm.exe |ppDevice.pas |TppPublisher |Publish
|1042[0] |
|00961526|Alarm.exe |ppProd.pas |TppProducer
|PublishReport |1450[1] |
|009615D2|Alarm.exe |ppProd.pas |TppProducer
|PrintToDevices |1514[10] |
|00961580|Alarm.exe |ppProd.pas |TppProducer
|PrintToDevices |1504[0] |
|0097D59A|Alarm.exe |ppReport.pas |TppReport
|PrintToDevices |1937[16] |
|00962321|Alarm.exe |ppProd.pas |TppProducer
|PreviewFormActivateEvent |2165[8] |
|008B4844|Alarm.exe |ppForms.pas |TppForm
|ehTimer_Notify |598[6] |
|76465A27|USER32.dll | |
|DispatchMessageA | |
|76465A1D|USER32.dll | |
|DispatchMessageA | |
|008B48F7|Alarm.exe |ppForms.pas |TppForm
|ShowModal |674[10] |
|009616CC|Alarm.exe |ppProd.pas |TppProducer
|PrintToScreen |1625[23] |
|00961670|Alarm.exe |ppProd.pas |TppProducer
|PrintToScreen |1602[0] |
|00961428|Alarm.exe |ppProd.pas |TppProducer |Print
|1392[12] |
|009613D8|Alarm.exe |ppProd.pas |TppProducer |Print
|1380[0] |
|0097C762|Alarm.exe |ppReport.pas |TppReport |Print
|1055[5] |
|011AB0D5|Alarm.exe |ServStats.pas |TWinRMServStats
|PrintReport |686[18] |
|011AAFE0|Alarm.exe |ServStats.pas |TWinRMServStats
|PrintReport |668[0] |
|011A8CAE|Alarm.exe |ServStats.pas |TWinRMServStats
|btnPrintClick |258[46] |
For many years I have used Report Builder with the
ppDictionary1.ValidateFieldNames and ppDictionary1.ValidateTablesNames both
set to False as I use a technique for running temporary tables in a
different folder from the main data, using temporary tables and field names.
This has worked well until 11.02 when we keep getting reports of an error
List index out of bounds (-1) - see call stack below.
If I add the fields to the dataDictionary the error does not occur.
Any advice?
Regards
Call Stack Information:
-----------------------------------------------------------------------------------------------------------
|Address |Module |Unit |Class
|Procedure/Method |Line |
-----------------------------------------------------------------------------------------------------------
|Running Thread: ID=4624; Priority=0; Class=; [Main]
|
|---------------------------------------------------------------------------------------------------------|
|00AF6B4B|Alarm.exe |daMetaData.pas
|TdaMetaTableCollection|GetItemByRawTableName |1159[2] |
|00AF6B00|Alarm.exe |daMetaData.pas
|TdaMetaTableCollection|GetItemByRawTableName |1157[0] |
|00AF673A|Alarm.exe |daMetaData.pas |TdaMetaCache
|GetTableForRawTableName |935[2] |
|00AF6714|Alarm.exe |daMetaData.pas |TdaMetaCache
|GetTableForRawTableName |933[0] |
|00AF5B83|Alarm.exe |daMetaData.pas |TdaMetaData
|GetTableAlias |411[5] |
|00AF5B44|Alarm.exe |daMetaData.pas |TdaMetaData
|GetTableAlias |406[0] |
|00AF7149|Alarm.exe |daMetaDataManager.pas|TdaMetaDataManager
|GetTableAlias |196[7] |
|00AF70EC|Alarm.exe |daMetaDataManager.pas|TdaMetaDataManager
|GetTableAlias |189[0] |
|00B094B0|Alarm.exe |daSQL.pas |TdaSQL
|CreateTableAlias |3689[3] |
|00B09450|Alarm.exe |daSQL.pas |TdaSQL
|CreateTableAlias |3686[0] |
|00B06574|Alarm.exe |daSQL.pas |TdaSQL |AddTable
|1770[8] |
|00B0651C|Alarm.exe |daSQL.pas |TdaSQL |AddTable
|1762[0] |
|00B012AA|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GetSelectTables |853[12] |
|00B0F0A4|Alarm.exe |daSQL.pas |TdaSQL
|GetAvailableLinkTypes |8229[0] |
|00AFFF9F|Alarm.exe |daLinkBroker.pas |TdaLinkBroker
|GetLinkType |485[2] |
|00AFFD94|Alarm.exe |daLinkBroker.pas |TdaLinkBroker
|GetLinkCount |302[1] |
|00AFF99B|Alarm.exe |daLinkBroker.pas |TdaLinkBroker |Assign
|123[8] |
|00B0121C|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GetSelectTables |841[0] |
|00B01FD0|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GetSQLInfo |1240[15] |
|00B02114|Alarm.exe |daMagicSQL.pas |TdaMagicSQL |GetLinks
|1302[4] |
|00B01F5C|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GetSQLInfo |1225[0] |
|00B0086E|Alarm.exe |daMagicSQL.pas |TdaMagicSQL
|GenerateMagicSQL |411[4] |
|00B09413|Alarm.exe |daSQL.pas |TdaSQL
|CreateMagicSQLText |3656[6] |
|00B093F0|Alarm.exe |daSQL.pas |TdaSQL
|CreateMagicSQLText |3650[0] |
|00B09384|Alarm.exe |daSQL.pas |TdaSQL
|GetMagicSQLText |3608[7] |
|00B09364|Alarm.exe |daSQL.pas |TdaSQL
|GetMagicSQLText |3601[0] |
|00E353C9|Alarm.exe |daAds.pas |TdaADSQueryDataView
|SQLChanged |1181[6] |
|00B17649|Alarm.exe |daQueryDataView.pas |TdaQueryDataView
|RefreshQuery |928[6] |
|00B17978|Alarm.exe |daQueryDataView.pas |TdaQueryDataView
|ReportBeforePrintEvent |1065[4] |
|00B145EA|Alarm.exe |daDataView.pas |TdaCustomDataView
|EventNotify |222[5] |
|00B145C0|Alarm.exe |daDataView.pas |TdaCustomDataView
|EventNotify |217[0] |
|00B16C9B|Alarm.exe |daQueryDataView.pas |TdaQueryDataView
|EventNotify |428[2] |
|0098C7BE|Alarm.exe |ppComm.pas |TppCommunicator
|SendEventNotify |800[14] |
|0098C768|Alarm.exe |ppComm.pas |TppCommunicator
|SendEventNotify |786[0] |
|00962479|Alarm.exe |ppProd.pas |TppProducer
|TriggerCodeModuleBeforePrint|2281[5] |
|00962460|Alarm.exe |ppProd.pas |TppProducer
|TriggerCodeModuleBeforePrint|2277[1] |
|00968388|Alarm.exe |ppClass.pas |TppCustomReport
|TriggerCodeModuleBeforePrint|4042[2] |
|008D3639|Alarm.exe |ppEngine.pas |TppEngine |Init
|2130[18] |
|008D13FE|Alarm.exe |ppEngine.pas |TppEngine |Generate
|545[8] |
|008D13E0|Alarm.exe |ppEngine.pas |TppEngine |Generate
|537[0] |
|008D1322|Alarm.exe |ppEngine.pas |TppEngine
|RequestPage |501[30] |
|0097D6B4|Alarm.exe |ppReport.pas |TppReport
|RequestPage |1977[25] |
|00958561|Alarm.exe |ppDevice.pas |TppPublisher
|DoOnPageRequest |1248[11] |
|00958520|Alarm.exe |ppDevice.pas |TppPublisher
|DoOnPageRequest |1237[0] |
|0095833B|Alarm.exe |ppDevice.pas |TppPublisher |Publish
|1058[16] |
|009582D8|Alarm.exe |ppDevice.pas |TppPublisher |Publish
|1042[0] |
|00961526|Alarm.exe |ppProd.pas |TppProducer
|PublishReport |1450[1] |
|009615D2|Alarm.exe |ppProd.pas |TppProducer
|PrintToDevices |1514[10] |
|00961580|Alarm.exe |ppProd.pas |TppProducer
|PrintToDevices |1504[0] |
|0097D59A|Alarm.exe |ppReport.pas |TppReport
|PrintToDevices |1937[16] |
|00962321|Alarm.exe |ppProd.pas |TppProducer
|PreviewFormActivateEvent |2165[8] |
|008B4844|Alarm.exe |ppForms.pas |TppForm
|ehTimer_Notify |598[6] |
|76465A27|USER32.dll | |
|DispatchMessageA | |
|76465A1D|USER32.dll | |
|DispatchMessageA | |
|008B48F7|Alarm.exe |ppForms.pas |TppForm
|ShowModal |674[10] |
|009616CC|Alarm.exe |ppProd.pas |TppProducer
|PrintToScreen |1625[23] |
|00961670|Alarm.exe |ppProd.pas |TppProducer
|PrintToScreen |1602[0] |
|00961428|Alarm.exe |ppProd.pas |TppProducer |Print
|1392[12] |
|009613D8|Alarm.exe |ppProd.pas |TppProducer |Print
|1380[0] |
|0097C762|Alarm.exe |ppReport.pas |TppReport |Print
|1055[5] |
|011AB0D5|Alarm.exe |ServStats.pas |TWinRMServStats
|PrintReport |686[18] |
|011AAFE0|Alarm.exe |ServStats.pas |TWinRMServStats
|PrintReport |668[0] |
|011A8CAE|Alarm.exe |ServStats.pas |TWinRMServStats
|btnPrintClick |258[46] |
This discussion has been closed.
Comments
--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com