Recent content by vijip2001

It works.I am not what extra characters i had. I deleted the field and recreated it and it works. Thanks for all the help. Viji

I created a formula column in the Seagate crystal reports version 8.0.1.0. The column in the recordset rstQtPrd_ttx.PCS_CHARGED is a number column. The formula i used is : if ( isnull({rstQtPrd_ttx.PCS_CHARGED}) or trim(cstr({rstQtPrd_ttx.PCS_CHARGED})) = "" ) then 0 else...

Tried it. It sill returns only TRUE. Does not return 0.

I tried: if (isnull({rstQtPrd_ttx.PCS_CHARGED}) or trim(cstr({rstQtPrd_ttx.PCS_CHARGED})) = "") then {rstQtPrd_ttx.PCS_CHARGED} = 0 else {rstQtPrd_ttx.PCS_CHARGED} = {rstQtPrd_ttx.PCS_CHARGED} This returns a TRUE. How do i make it return 0 if the value is null? Thanks for the help. Viji

All, I am trying to write a formula in crystal report 8.0.1. I want to handle a number column that is null. Can someone please help? Here is the formula: if isnull({rstQtPrd_ttx.PCS_CHARGED}) = true or trim({rstQtPrd_ttx.PCS_CHARGED}) = "" then {rstQtPrd_ttx.PCS_CHARGED}=0 else...

It worked. I had an exta "AND" and a extra "(" in the query. Thanks for all the help. Viji

All, I am using vb6 that executes query against RDB. How do i check for null values in a query? I oracle i use "select nvl(column,0) from dual;" Can someone help me? Thanks, Viji

All, I am using VB6.0. I am geting 'function sequence error' in Do loop, when i do a recordset.movenext Can you please tell me where i am wrong? Thanks, Subha strSqlProdSeq = "SELECT DISTINCT SEQ_NUMBER" & _ " FROM QT_PRODUCTION Where " & _...

All, I am using VB 6.0. I am trying to join 5 tables in a query and pass the columns to crystal report through a recorset. Here is the query. The first left join works fine. When i add the second left join, throws error saying 'expecting a predicate'. Can someone please help? Is there...

Hello all, Just got a chance to get back to the printer problem. The checkbox in the printer dialog box is populated to dynamic string, which gets all the printers mapped to the server. So the check box expands and goes beyond the screen. The form where my check box is placed does not...

How do i do that? Then how will the users scroll the list of printers? Thanks, Viji

Hello all, I have a VB 6.0 application, which picks up the list of system printers, when user chooses the print button. The list of printers populates a check box in a form and user picks the printer which they want to print. Since this application is hosted in a citrix metaframe...

Added the reference 'Microsoft ActiveX Data Objects 2.5 library' and still gives the same old error. Thanks, Viji

Yes. I knew ADO is not same as DAO. But i am not getting any option for ADO libraries in the reference options. It lists onle DAO 3.6 as an option. Is there any way to add that reference? Yes, the code does work with Access 2003(with DAO recordset). I will try to use the syntax options that...

Am i suppose to add any specific reference?? Since the application has lots of places where i need to do it, is there any way i can globally define a collection reference? When i try to replace 'rs.last_ticket_number' by collection reference ('rs!last_ticket_number') in one...