by Vlad DRAGO » Sat, 03 Apr 1999 04:00:00
I want to create repetead queries using Ingres IIOpenAPI (SELECT,
INSERT, UPDATE, DELETE)
but providing to application my own Repeated Queri ID's.
I have already solved the other case when the application generates
itself the repeated query ID and you must
provide this ID as a query parameter each time you execute the repetead
query.
Any explanation or indication will be much helpful,
Thanks again and looking forward to hearing from you
Vlad
by Usha Rajseka » Tue, 06 Apr 1999 04:00:00
> I want to create repetead queries using Ingres IIOpenAPI (SELECT,
> INSERT, UPDATE, DELETE)
> but providing to application my own Repeated Queri ID's.
> I have already solved the other case when the application generates
> itself the repeated query ID and you must
> provide this ID as a query parameter each time you execute the repetead
> query.
> Any explanation or indication will be much helpful,
> Thanks again and looking forward to hearing from you
> Vlad
additional info on Repeated Query IDs. Good luck!! -Usha
1. Parameterized Queries using repeat parameter?
Can you reuse a parameter in a parameterized query?
For example my sql is as follows
select * from table where some_value > ? and some_value < ?
and the parameters I want is the same, do I have to create two parameters
and then set it twice or is there a way to only set it once?
The following is the code I currently have working
m_pCmd->Parameters->Append( m_pCmd->CreateParameter( "some_value1",
adNumber, adParamInput, sizeof(long) ) );
m_pCmd->Parameters->Append( m_pCmd->CreateParameter( "some_value2",
adNumber, adParamInput, sizeof(long) ) );
_variant_t vtData( 1L );
m_pCmd->Parameters->GetItem("some_value1")->Value = vtData;
m_pCmd->Parameters->GetItem("some_value2")->Value = vtData;
is there a way to set this only once?
3. Repeating and Non-Repeating
4. increasing the size of columns
5. Repeat Rows when query SQL 7.0 via Access97 client
6. Migrating from Access to SQL Server 7
7. Repeated access of Query Result sets....
9. Trying to do a repeat loop in sql query
10. Repeated database damage after using SQLMerge object and merge replication
11. Q on correlated subqueries ("repeating queries")
12. REPEAT: Error using Global Variable in function call
13. Calculated field repeats records in query