IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / BTW. . . . .(OT)
Post #179,996
by acagle
10/19/04 1:37:25 PM
Reply
New BTW. . . . .(OT)
Is there a way to programmatically change the SQL of an Access stored query? I.e., say I make a query called qrySomeSQL that says:

Select table1.var1, table2.var2 From table1 WHERE table1.var1=12345;


I want to be able to substitute anything I want for '12345' when calling it from a procedure. I tried making a recordset within the procedure, but the SQL string I use it in doesn't recognize it (i.e., "Select rstTest.var1. . .")
Post #180,001
by acagle
10/19/04 2:02:30 PM
Reply
New Re: BTW. . . . .(OT)
Ah. Use QueryDef.

Over the past few years, this would have solved numerous problems.
     Fun! Exciting! - (acagle) - (14) - Oct. 15, 2004, 05:24:21 PM EDT
         My usual sources for free fonts - (FuManChu) - (1) - Oct. 15, 2004, 05:40:14 PM EDT
             Mostly all suck - (deSitter) - Oct. 15, 2004, 09:56:22 PM EDT
         Arial Narrow (LIFE FUNCTIONS TERMINATED) -NT - (deSitter) - (1) - Oct. 15, 2004, 09:55:18 PM EDT
             Gill Sans (titles) -NT - (deSitter) - Oct. 15, 2004, 09:55:57 PM EDT
         Re: Fun! Exciting! - (pwhysall) - Oct. 15, 2004, 11:38:58 PM EDT
         microgramma extra- bold extended? - (ChrisR) - Oct. 15, 2004, 11:57:43 PM EDT
         Ah the computers - sorry - (deSitter) - (5) - Oct. 16, 2004, 08:52:31 AM EDT
             Ahaaaaaa. . . . - (acagle) - (4) - Oct. 18, 2004, 02:38:12 PM EDT
                 Logic memory center - (deSitter) - (3) - Oct. 18, 2004, 04:35:30 PM EDT
                     Re: Logic memory center - (acagle) - (2) - Oct. 18, 2004, 05:58:04 PM EDT
                         I like! - (deSitter) - (1) - Oct. 18, 2004, 08:06:08 PM EDT
                             Re: I like! - (acagle) - Oct. 21, 2004, 02:33:47 PM EDT
         BTW. . . . .(OT) - (acagle) - (1) - Oct. 19, 2004, 01:37:25 PM EDT
             Re: BTW. . . . .(OT) - (acagle) - Oct. 19, 2004, 02:02:30 PM EDT

It would have been much more tolerable if they used wires and an action figure.
70 ms