I am sure I read somewhere that there is an easy way to pass named parameters from a calling function to a called function without explicitly naming and specifying each parameter.
This is more than just reusing the position; I'm interested in the case where the name of the passed parameters is the same in some cases, but not in others.
...
I currently have multiple queries that query data from a few tables linked through ODBC, and some temporary tables that are edited through the user interface. I have complex criteria in my queries such as:
SELECT * from ThingsData
WHERE (Thing In(SELECT Thing from ListOfThings) AND getThingFlag() = True);
In this case Thing is a field...
I am using Access 2007 with a pass-through query. The data values that I am retrieving are from a bit column (0, 1) but when the pass-through query runs the data that is returned is either 0 or -1. I am calling a stored procedure on my SQL database for this pass-through query, this stored procedure works and returns the positive bit numb...
Hi,
We got a Citrix Environment with some databases, a frontend netwerk with local machines and a backend network on a shared AD-Domain.
The frontend-servers cannot access the database-servers in the backend.
I would like to build a webservice in the backend to access some data on the database-servers.
On the frontend, I would like to...
Hello,
Basically started with Squid and iptables today (google is your friend). This stuff is going to be the death of me.
I have Squid3 setup on Ubuntu 9.04 server as Transparent Proxy. It works sweetly when i use the proxy-box as my default gateway etc. The iptable rules for this setup was part of the tutorial. :P
I can unfortunatel...
I have an Access 2003 application that I would like to create reports for using stored procedures via pass-through queries. Everything works fine with one exception. When I specify the stored procedure to use for the pass-through query I have to choose a DSN to provide the database connection info. I need to be able to change the connect...
I need to pass a table from Access to SQL-server and execute a stored-procedure.
I'm using pass-through queries in Access to do this.
My pass-through query:
DECLARE @MyVar TABLE { .....<variables> }
INSERT INTO @MyVar SELECT *
FROM [MyTable]
EXEC sproc_test @Myvar
My stored-procedure:
ALTER PROCEDURE [dbo].[sproc_test]
@M...