Recent content by lorein

Hi Dave I tried to use the nowait option but I don't know how to get the error when another transaction has the same record. I receive the error ORA-00054: resource busy and acquire with NOWAIT specified. I want to capture this error and then try again. How can I do that? This is in order to...

I have another question. If I lock a record with a select for update, but I didn't do a commit or rollback. Can other station select the same record? I want to be sura that once alock a record anyone can select, update or delete the record. thanks Lorein....

I have another question. When I lock the table this operation takes a lot of time or CPU? Or the operation to lock a table is a fast operation? Or when I cant find this type of information? Lorein....

I'll try this option thanks! Lorein....

Mufasa Let my explain a lite more... Is necesary lock the table because I have to update a diferent record in each station. The records that I update are uniques codes. That's why I lock the table , I select a record , I update a record and commit. If I didn't lock the table many stations can...

Hi I have a procedure that update a record in a table. This table is accessed for many work stations and these stations update this table several times. In average this table is updated 900,000 times a day. My oracle version is 9.02 In this table there are no deletes. The records that are in...

Hello I trying to parse an xml document. I'm using oracle 9i. This code for some nodes in the same document works. And for others don't l_parser2 := dbms_xmlparser.newParser; dbms_xmlparser.parseClob(l_parser2, l_clob); l_doc2 := dbms_xmlparser.getDocument(l_parser2)...

When a field is empty from the data base some times you don't know which value crystal read. In order to avoid this problem you should give a default value depending of the data type activating the option "Convert to NULL field value to default". This option is in File\Report Options . Lorein....

Hi I'm using crystal reprots 8.5 I make a report with 2 subreports in the same section, but these subreports are overlap. I try to resolve this issue inserting a new page after the report footer of the first subreport ,and add a new page after the report header of the second subreport, but it...

thanks Django, now its working! Lorein....

Hi IdoMillet I already try with: not isnull({AccountNumber}) ({AccountNumber})="" recordnumber({AccountNumber})>0 But I think when the stored procedure doesn't has any data crystal didn't know or something like that. In all testing that I did all these options worked when there was data...

Hi I have a problem again about this issue. I add in the report header section in the section expert (format->section)->report header->suppress->x+2 the next condition: count(Accounnumber)>0 and it works when the report has information because doesn't show the label "No data in the...

Thank you very much for your help IdoMillet, Ibass, Madawc Lorein....

Thanks for your response. But I don't know how to enable a section in a report when is no data? I tried using the count and recordcount functions and when the report has no data I receive a blank page. I don't know in wich part of the report I have to evaluate the number of records Some body...

Hi I have a VB 6 application using crystal reports 8.5 and the crystal OCX. My data base is oracle and i'm using stored procedures. I want to know if a report has data or not in order to have some text in the report instead a blank page. Does anybody know how do this?? I really...