We are using pass thru queries and have been searching thru the code and queries trying to find out why our application creates 2 connections (instances) to the Oracle DB.
All of the DSN strings are exactly the same and work fine in all of the pass though queries.
Any other suggestions?
Thanks
mintz87
Last Activity: May 26 '10, 08:09 PM
Joined: Mar 28 '08
Location:
-
mintz87 started a topic access app is creating 2 instance connections to the DB and we do not know whyin Accessaccess app is creating 2 instance connections to the DB and we do not know why
i have an access application, using vba to use pass thru queries, Oracle DBA has created a global temp table that will create automatically when connected to the users instance.
Issue:
the access application is creating 2 instance connections to the DB and we do not know why. this is an issue because the 1st instance inserts all of the data into the GTT then when selecting (querying) the data the application creates a 2nd instance... -
PL/SQL writing a SQL Query to execute into a table
i'm really rusty in the PL/SQL (spent last 5 yrs in SQL Server)
I'm wanting to have a PL/SQL procedure build SQL queries when called.
here is what i have so far:
declare
a_sel varchar2(255) := 'select * from VISIT_VIEW where';
begin
dbms_output.put _line ('select * from VISIT_VIEW where ');
for row_c in
(select ss_criteria_col umn_name, ss_criteria_dat a_detail... -
Access Report Formating Issue
i have attached doc that helps explains want i am trying to do. i am trying to format a report to look like a format i did in excel by using a pivot table.
thanks... -
No collections, no rent, just take the rent piece out of the equation. I just need code that will create a table that will break out the months by using the beg_date through end_date. That’s all I need.
m3ntZ...Leave a comment:
-
I'm not sure where "sum" is coming from, but i'm not trying to sum anything.
i am taking the beg_date column, the end_date column and breaking the range out per month into a new table.
i know that i am going to use the DateDiff to calculate the number of months and put that into a loop to add the months to the beg_date to get the date range broke out. i'm just not sure how to put that all together and get the syntax...Leave a comment:
-
There is nothing to select as far as dates. my table is the following: Lease_Tb - ID (Primary_key), Beg_date, End_date, Store_Num, Rent
there will be several 100's of lines in this table haveing different date ranges (the date range is from Beg_date thru End_Date. i have to have code generic enough to break this Date Range out on a per month to show the $$$ (Rent) that we are paying on a monthly basis. The final view will look like: ...Leave a comment:
-
All i am trying to do is to break out that date range per line and input that into another table. I just need the code to do that in Access.
thanks
m3ntZ...Leave a comment:
-
Access-SQL-Break out a date Range?
i have a table that has a beg_date & end_date (3/1/1985 & 3/1/1990)
how do i, in access, break out this date range into another table by month. since this date range is a 60 month range it would insert 60 lines of data into the new table. (3/1/1985, 4/1/1985, 5/1/1985, etc). there will be mulitple dates to break out with various ranges.
thanks
mintz
No activity results to display
Leave a comment: