Jil,
Try to move your instruction
gi_return = dw_1.of_SetTransObject(SQLCA)
into below this line
// set datawindow according to what user selected in the menu
dw_1.DataObject = gstr_diag.datawindow
gi_return = dw_1.of_SetTransObject(SQLCA)
// enable report & print preview services
gi_return = dw_1.of_SetReport(TRUE)
gi_return = dw_1.of_SetPrintPreview(TRUE)
gi_return = dw_1.of_SetUpdateable(False)
// enable sort feature
gi_return = dw_1.of_SetSort(TRUE)
gi_return = dw_1.inv_sort.of_SetColumnNameSource(2)
gi_return = dw_1.inv_sort.of_SetColumnHeader(TRUE)
gi_return = dw_1.inv_sort.of_SetUseDisplay(TRUE)
gi_return = dw_1.inv_sort.of_SetStyle(0)
gi_return = m_sheet.m_view.m_sort.Enable()
// retrieve datawindow
gl_rows = dw_1.retrieve(gstr_diag.sdate)
That should solve your problem
AST
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
