Search results for query: *

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...

Same error message "compile error: method or data mamber not found" Thanks, Viji

I am not sure which references you want me to compare. 'last_ticket_number' is a database column. The trans_seq number is generated in the application and assigned to the 'last_ticket_number' column. I have tried DAO.recordset. It does not work either. Another thing, when i debug the code...

Sorry..Let me see if i can explain more..Let me know if i am not clear.. I have an application that is in microsoft access 2000. The program has been working fine. Now since the database servers are changing,the tnsnames are changing.So i copied those program on to my computer, which has...

Never mind..Got the link..Thanks for all your help. Viji

Gurus, My computer has an application running on Access 2003(coded in VBA). My client's computer has Access 2000. When i take the same application and run on my client's computer, i initially got missing reference ADO 2.5/3.5. So i added the Microsoft DAO 3.6 library and fixed it. Now...