Search results for query: *

I have migrated (using OMWB) some of the tables from an Access 97 application to Oracle 8i and am now trying to get it to run quicker. The application when completely in A97 took between 30 and 40 minutes to run, now with two of the larger tables in Oracle it is taking 160 to 200 minutes. This...

I am trying to insert the results of an Access DAO recordset into an Oracle table through OO4O. The code is detailed below, from which I keep getting the error SQL execution error, ORA-00984: column not allowed here I have checked for solutions on the net and all seem to point towards a...

I want to delete records for the run year/week from tables which have been migrated to Oracle from A97. What is the best way to do this? The current queries that worked while tables were in Access are now giving 'not an operable query' errors. An example of the query involved: DELETE...

Essentially what I need is to be able to delete records from an Oracle table using A97. I know that it must be something simple but I just don't seem to be getting anywhere. I need to run a delete query on a table and then an append query to append the records for the run week. Each week...

I'm setting up a number of A97 applications to allow users to view reports, most of them being set up in Landscape with some in Portrait. The problem I'm having is that when the users connect over Citrix and view reports, all reports are formatted as being Portrait so the Landscape ones no...