Stack Overflow
Stack Overflow

Questions tagged [pass-through]

Pass-through is a method of database processing where one DBMS (or similar) connects to a different DBMS, and submits code to the second DBMS for processing, rather than retrieving most or all rows and filtering or processing on the first server.

Pass-through is a method of database processing where one DBMS (or similar) connects to a different DBMS, and submits code to the second DBMS for processing, rather than retrieving most or all rows and filtering or processing on the first server.

190 questions
0
votes
2 answers

SAS pass column name through variable

I need to pass a column name through a variable. %let dsn=a1234; data temp; set &a1234; if age>=20; run; Where 'a1234' is the column name (present in the file) that I want to use; and not the string a1234. The reason I want to do this is to…
jpsfer
  • 594
  • 3
  • 7
  • 18
0
votes
1 answer

SQL-server syntax error when combining queries (pass-through query)

I'm trying to combine 2 queries to a sql-server pass-through query (PTQ). Both queries, when coded separately in Access, work. When combining these Access codes to one query, it still works in Access. But when I format the field names to T-sql, and…
user1453540
  • 1
  • 1
0
votes
2 answers

Access 2010: Display contents of multiple records to unbound controls in datasheet

I'm using a dynamic pass-through query in Access 2010 to retrieve one or more records from a back-end database. After much trial and error, I plagiarized enough of the right code to retrieve the appropriate records and assign them to unbound…
DUHdley d'Urite
  • 187
  • 3
  • 15
-1
votes
1 answer

MS Access / SQL Server pass-through query

My query does run, but returns no results: SET NoCount ON SELECT Inventory.EffectiveDate, Inventory.Quantity, Inventory.SourceType, Inventory.PickingLocation, Inventory.SourceInventory, Locations.LocationId, …
Elen
  • 2,345
  • 3
  • 24
  • 47
-1
votes
2 answers

Access abends after DoCmd.OpenReport

A report is called from VBA to receive returned records from an Access pass-through query. After the DoCmd completes the report's parameters are set in the report's appropriate label containers setting their .Caption property as required. Access…
Tim
  • 71
  • 9
-1
votes
1 answer

How do I use QueryDef to get data from a pass-through query?

I have a SQL pass-through query that returns me a table based on a variable in a "FROM... WHERE='variable'" structure. I want to use that pass-through query on a VBA code and get the variable from a form. In resume: I'll enter the variable on a…
Caio Gomes
  • 681
  • 1
  • 11
  • 23
-1
votes
1 answer

SignalR 2 & Javascript Client to Server A to Server B

I have the following architecture setup. Client A (Javascript) => Server A (Has SignalR Server) and Client A (Javascript) => Server B (Also has SignalR Server) I want to know if i can make it like so.. Client A => Server A => Server B Where Client…
Jeffrey Holmes
  • 337
  • 3
  • 11
-1
votes
2 answers

ODBC Connection Dynamic From Clause

ODBC;DSN=Test;UID=;PWD=;SourceDB=\\server\folder\Test\prime.dbc;SourceType=DBC;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes; Then the functional static query that uses that connection. There are 5 tables in…
Kaw4Life
  • 209
  • 2
  • 17
-1
votes
1 answer

Pass multiple records from one table into a SQL statment

I am trying to take many values (which always change) from a table in access and put them inside a limit of a SQL statement. I have Dlookup() but as we know it is pulling only 1 value. How can I loop this to pull all the value? related code: Dim…
user2276367
  • 1
-2
votes
1 answer

Passing output from one command at end of another

Need to pass txt file name to another command. I have folder lets name it folder and have fileXX.txt (number at the end is changing). How can I create batch file that scans folder for tiles *.txt and passes it to another command, like print. So at…
BB20
  • 1
  • 1
1 2 3
…
12
13