Search results for query: *

No, it did not. I did have commit for each transaction. Could it be the driver it is using that caused it?

Oracle 10g. I used RDO and got the message as mentioned. When using ADO, I got different error message: ORA-06550. Thanks for your help.

Hi, all. When running a report off a procedure in Oracle. I have received this error: "ORA-01456: may not perform inert/delete/update operation inside a READ ONLY transaction" A bit confused about this error. The procedure was compiled successfully, but failed when called from Crystal Any...

Not sure why Access times out when trying to export tables to Oracle. Does anyone know how to stop from timing out.

In table1, I want to use one field LEFT OUTER JOINED (+) with table2 and in table1, I use another field to LEFT OUTER JOIN (+) to table2 and one last field in table1 LEFT OUTER JOIN (+) to table3. I received an error saying "it only allows 1 most outer join". It worked in SQL SERVER. Thanks...

Just wondering if it is possible to have multiple joins on the same table in Oracle. If not, what is the possible workaround? Thanks in advance for any assitance.

Hi, I wonder if there is a way to stop the time out. I have packages scheduled, but they seem to time out after trying to establish a connection for a long time. Thanks for any help in advance.

Hi, I have been trying to figure this out, nut no success. I have a report created in 8 with an Oracle stored procedure and ran fine with no problem but when ran in 10 it faield with error saying "failed to open rowset". Has anybody experienced this? Any feedback/assistance would be...

Awesome! Thank you very much. This definitely comes very handy, especially for report runtime performance.

Hello, I am wondering if anybody experienced this. I am using CR 10 and I have reports created in version 8 with modification of SQL in "Show SQL". And now in 10, the reports fail. And I can't even modify the SQL any longer. Hope someone can help. Thanks in advance.

OS: Windows 2000 and Version Info 7.5. How do I analyze the event log? Thanks.

Hope someone can help. I tried to install Info, but it stopped at where it said "Shutting down Seagate Info components" without doing anything. Has anyone experienced this before? Thanks in advance for any asistance.

Awesome! It worked! Thank both so much for your insights. I will definitely change it.

Hello, I have a textbox for user to fill in. User might fill in an apostrophe. Is there a good way to translate it so when it is inserted in a table, it wouldn't generate an error? Thanks in advance for any expert insight.

You both are awesome. Thank you very much. This is exactly what I need.

Hello, I have the following data set that is already grouped by sale_item. pid sale_item sale_deptno 1 book 101 2 book 101 3 book 102 4 book 103 5 book 101 6 book 101 7 book 102 1 cd 101 2 cd 103 3...

Hello, I have the following data set that is already grouped by sale_item. pid sale_item sale_deptno 1 book 101 2 book 101 3 book 102 4 book 103 5 book 101 6 book 101 7 book 102 1 cd 101 2 cd 103 3 cd 102 4 cd 101 1 basket 104 2 basket 100 3 basket 101 Here is what I want to...

Hello, Is there other alternative to sum a variable with a new separate group. This variable is a running total in a three-formula approach. I tried using sum(), but of course it gave an error. I am using 7. Thanks for any help in advance.

Hello, I have a server control with postback that causes the background disappear (background color turned back to white and some text on the page misalign like off center) with the use of SmartNavigation = "true" in the page directive. why does this happen? Thanks for any help with this issue...

Thanks, Rob, this is exactly what I need. I did not realize that's the SmartNavigation issue. Thanks again for pointing to the right direction.