I am a newbie to Visual Basic and I am using Visual Basic 6.0 with SQL Server. I am trying to print a ntext datatype field in a report and it is not working. I am not using any third party report writers. We have developed some libraries to generate the reports.
Dim oReport as ReportClass
Dim rsReport As ADODB.Recordset
Set oReport = New ReportClass
'GDExecute is a function to execute the command
If Not GDExecute(cxOrderManagement, rsReport, "select * from invoicing inner join orders on orders.ordernumber = invoicing.ordernumber inner join customers on customers.customernumber = orders.customernumber where invoicing.invoicenumber = '" & cbo_Rep_Invoice.Text & "'", adUseClient, adOpenStatic, adLockReadOnly, adCmdText, 15) Then GoTo Rep_PrintInvoice_Err
'Sayat is a function in the reportclass, uses Me.Say statement to display/print
'Additional Information is a ntext datatype field (sql database)
oReport.SayAt T_Reps.Row_, 0.5, rsReport.Fields("AdditionalInformation"
This doesn't work, it prints nothing.
Please help.
Thanks,
DR
Dim oReport as ReportClass
Dim rsReport As ADODB.Recordset
Set oReport = New ReportClass
'GDExecute is a function to execute the command
If Not GDExecute(cxOrderManagement, rsReport, "select * from invoicing inner join orders on orders.ordernumber = invoicing.ordernumber inner join customers on customers.customernumber = orders.customernumber where invoicing.invoicenumber = '" & cbo_Rep_Invoice.Text & "'", adUseClient, adOpenStatic, adLockReadOnly, adCmdText, 15) Then GoTo Rep_PrintInvoice_Err
'Sayat is a function in the reportclass, uses Me.Say statement to display/print
'Additional Information is a ntext datatype field (sql database)
oReport.SayAt T_Reps.Row_, 0.5, rsReport.Fields("AdditionalInformation"
This doesn't work, it prints nothing.
Please help.
Thanks,
DR
