UNCTarheels
Programmer
I am using CR 8.5 in Mas 90/200. I needed to display a jpg/gif that was associated with an inventory item. If I created a standalone report, the report displayed properly, with the graphical image. However, when accessing the report through MAS, the graphical image would not display. In investigating this, I discovered that a linked subreport was required. In preview mode in CR, the graphical image displayed properly. I then saved the report and tried to preview the report in MAS. It caused a database error.
The error information is:
Messagebox:
crystal print error: error detected by database driver
The SQL Trace is: (partial trace, at the end where the problem occurred)
windx" -id=T0 - 578-55c EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 00901598
SQLHANDLE * 0x02F86CD4 ( 0x00902a18)
windx" -id=T0 - 578-55c ENTER SQLExecDirect
HSTMT 00902A18
UCHAR * 0x02EE60D0 [ -3] "SELECT Inventory_Image."ItemNumber", Inventory_Image."Picture" FROM "Inventory Image" Inventory_Image WHERE Inventory_Image."ItemNumber" = 'DR36S'\ 0"
SDWORD -3
windx" -id=T0 - 578-55c EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 00902A18
UCHAR * 0x02EE60D0 [ -3] "SELECT Inventory_Image."ItemNumber", Inventory_Image."Picture" FROM "Inventory Image" Inventory_Image WHERE Inventory_Image."ItemNumber" = 'DR36S'\ 0"
SDWORD -3
DIAG [S000] [Best Canada][PVX ODBC Driver][FILEIO]Table is not accesible (12)
windx" -id=T0 - 578-55c ENTER SQLErrorW
HENV 00000000
HDBC 00901598
HSTMT 00902A18
WCHAR * 0x0012BC74 (NYI)
SDWORD * 0x0012BDB0
WCHAR * 0x0012B874
SWORD 242
SWORD * 0x0012BDAC
What did I do wrong? s-)
The error information is:
Messagebox:
crystal print error: error detected by database driver
The SQL Trace is: (partial trace, at the end where the problem occurred)
windx" -id=T0 - 578-55c EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 3 <SQL_HANDLE_STMT>
SQLHANDLE 00901598
SQLHANDLE * 0x02F86CD4 ( 0x00902a18)
windx" -id=T0 - 578-55c ENTER SQLExecDirect
HSTMT 00902A18
UCHAR * 0x02EE60D0 [ -3] "SELECT Inventory_Image."ItemNumber", Inventory_Image."Picture" FROM "Inventory Image" Inventory_Image WHERE Inventory_Image."ItemNumber" = 'DR36S'\ 0"
SDWORD -3
windx" -id=T0 - 578-55c EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 00902A18
UCHAR * 0x02EE60D0 [ -3] "SELECT Inventory_Image."ItemNumber", Inventory_Image."Picture" FROM "Inventory Image" Inventory_Image WHERE Inventory_Image."ItemNumber" = 'DR36S'\ 0"
SDWORD -3
DIAG [S000] [Best Canada][PVX ODBC Driver][FILEIO]Table is not accesible (12)
windx" -id=T0 - 578-55c ENTER SQLErrorW
HENV 00000000
HDBC 00901598
HSTMT 00902A18
WCHAR * 0x0012BC74 (NYI)
SDWORD * 0x0012BDB0
WCHAR * 0x0012B874
SWORD 242
SWORD * 0x0012BDAC
What did I do wrong? s-)