PC Review


Reply
Thread Tools Rate Thread

Re: PASS-THROUGH Query to Oracle

 
 
Duane Hookom
Guest
Posts: n/a
 
      21st Aug 2003
You can modify the SQL of the querydef.

Dim strSQL as String
strSQL = "SELECT * FROM Table1 WHERE Field_1 = '" & Me.txtDate & "'"
CurrentDb.QueryDefs("qsptYourQuery").SQL = strSQL


--
Duane Hookom
MS Access MVP


"Kent Prokopy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have created an Access2000 query that has it's properties set to be a
> pass-through query to and Oracle DB.
> Is there any way to pass this type of query a parameter.
>
> Example:
>
> SELECT *
> FROM Table1
> WHERE Field_1 = TRUNC(SYSDATE)
>
> I want to be able to replace the SYSDATE with a parameter value.
>
> Example: MyDate = #01/01/2003#
>
> SELECT *
> FROM Table1
> WHERE Field_1 = MyDate
>
> Many thanks
> Kent Prokopy
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle error occurred, but error message could not be retrieved from Oracle Gerard Lai Microsoft Dot NET Framework 5 19th Dec 2012 10:28 AM
does oracle 8i or oracle 9i supports windows xp home edition sunny Windows XP General 1 22nd Dec 2003 05:11 PM
How to connect oracle 8i when oracle 8i and oracle 9i installed in one system Prasad Microsoft ADO .NET 0 1st Dec 2003 11:23 AM
Insert query in Oracle database using microsoft ODBC for oracle =?Utf-8?B?UmVuYXRvIE0uIFYuIEIu?= Microsoft Access VBA Modules 1 17th Nov 2003 12:03 AM
Re: Passing Oracle structures to an oracle store proc Bob Beauchemin Microsoft ADO .NET 0 11th Jul 2003 07:47 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:01 AM.