parameter query

[Cagliostro]

Hi,
How can I create a parameter in a query?
In SQL Server is possible to write
declare @xxx int
set @xxx=10
select SomeThing from SomeWhere
where SomeOrOtherThing = @xxx John Fill

ivfmd@mail.md

 

[tlbroadbent]

In query designer you just need to type a prompt enclosed in brackets in the criteria field of the column SomeOrOtherThing.

For example: [Enter the value of SomeOrOtherThing]

Upon execution of the query, an input box with the prompt will be displayed. The user can fill in the input box, hit enter and the query will execute using the criteria entered. Terry

http://members.home.net/tlbroadbent/index.htm

 

[Cagliostro]

No,
I need to call a query through ODBClike folowing:

include<sql.h>
#include<string>
using namespace std;
int main()
{
string strSql(&quot;declare @xxx int\nset @xxx = &quot;
int x = 10;
str+=string(x);
str+=&quot;\nselect SomeThing from SomeWhere
where SomeOrOtherThing = @xxx&quot;;
....
SQLPrepare(...strSql.c_str()....);
....
}
There I can't use Access DialogBoxes. It is a C++ program what use an ODBC interface. John Fill

ivfmd@mail.md

 

[tlbroadbent]

I'm not familiar with C++ but know that you can pass a parameter to a parameterized query in an Access database. Here are some resources.

http://support.microsoft.com/support/kb/articles/q200/1/90.asp

http://support.microsoft.com/support/kb/articles/Q181/7/34.ASP

http://support.microsoft.com/support/kb/articles/Q111/8/16.asp

http://support.microsoft.com/support/kb/articles/Q137/8/14.asp

Terry

http://members.home.net/tlbroadbent/index.htm

 

[Cagliostro]

I do not want an ActiveX or an ODBC sample in C++, Java or other languages. For me it is already familiar. I want a parametrized query like I wrote is good for SQL Server if it is possible. If is impossible, I want know what is impossible. I know what to do if is impossible. What I want is the easiest way. John Fill

ivfmd@mail.md

 

[tlbroadbent]

Queries like you wrote in SQL Server are not always possible in Access. SQL queries can be step-by-step procedures while Access queries cannot be procedures.

I only recommended the articles above because they show ODBC and ADO use of Access &quot;parameterized queries.&quot; I thought you could extend those examples into your C++ code.

It appears that I may be totally misunderstanding what you are attempting to do. I certainly apologize if I've wasted your time. Terry

http://members.home.net/tlbroadbent/index.htm