Search results for query: *

Hi, I am trying to migrate existing Crystal Reports from Native Informix ODBC drivers to Wire protocol drivers. Is there a way we can do this conversion in bulk for all of the reports as there are about 200 reports for which we are seeking conversion. Also can I write a script to do this...

Hi, I am trying to migrate existing Crystal Reports from Native Informix ODBC drivers to Wire protocol drivers. Is there a way we can do this conversion in bulk for all of the reports as there are about 200 reports for which we are seeking conversion. Thanks for the help.

Thanks for the help. It worked!

PLS-00049: bad bind variable 'OLD.a' Thanks

Sorry I mistyped the name it is unique and called tbl_update_trg . It still gives compilation error. The trigger should move the row being updated on to the audit table and should update the values in the current table. Thanks for the help.

Hi, I am trying to write a before update trigger , which should before updating the current table should take all the old values and insert it into an audit table. I wrote this but its giving compilation error please let me know where I am going wrong. create or replace trigger tbl_update...

Thanks to all of you for the help. It works great now!

Hi, That didn't work. It didnt give me any output when i tried that . Is there another way , please let me know. I tried this select sum(count_total) from ( select count(*) count_total from a union select count(*) count_total from b) ofcourse it only works if the values from each quesry...

Hi, I wanted to know , how to add values of two select count(*)'s in one query for ex. Query 1)select count(*) from a quesry 2) select count(*) from b Restlt : Select Sum of the values of both query 1 and query 2 Thanks

Did anyone come up with the answer for the above question?

Hi, I am trying to build a master/detail type of grid but I want a master grid and a detail form. i.e all the columns that are displayed on the master grid should be transferred to a detail form and should populate the editable textboxes on that form on the click of a button , so that...

Hi, Yeah , the server is Unix and the client is windows. Regards roche

This is exactly what I was looking for. Thanks so much!

Hi Mufasa, You are off base, let me explain clearly what I need, X FLOAT ; x NOW HAS VALUE 90.99 . I need 90 and 99 to be printed as 9099 instead of 90.99 Thanks for the help.

Hi, I declared a datatype of float , once i get the value in the variable , I have to extract the precision and scale from the float value. Kindly advise , I want to store the decimal value without the decimal point . Thanks again!

Thanks! for the help.

Hello, I am using the UTL_FILE utility to write to a file on the server. How do I get to the file from SQLPLUS .I mean how can i view the file from SQLPLUS .I tried GET but it says unable to open. Kindly Advise. Thanks

Hello, I was wondering where does Crystal Enterprise store all the user information. I know it does in the APS which is in my case the msde , but when I explore and look inside the table in the msde , I dont see the user's I created . Is the data stored in some encrypted format. Where...

I am having few input fields in my asp page and a submit button. To enter the data in the input fields I have to use a barcode scanner and then I have to subit the data to the sql server data base. How do I do this . How can I implement this as I am new to bar code scanning.

Can I call Cognos reports from an extrenal application , when doing web reporting. Thanks