[odb-users] String Query

[Tarik BENZ]

Is it possible to call a stored procedure with ODB?

> From: tenchu.tarik at hotmail.fr
> To: odb-users at codesynthesis.com
> Subject: RE: [odb-users] String Query
> Date: Wed, 12 Jun 2013 16:15:35 +0200
> 
> 1. I have a period type (1 = day, 2 = week, 3 = month)
> 2. I have a period number ( 1, 2 , 3 ...)
> -> If my period type is 2 and my period number is 3, I will have a period of 3 weeks (2 * 3)
> 
> 3. I have a reference date (January 1st 2013)
> 
> What I want to do is :
>  The user will select a period ( ex : beginning = Mars 5th 2013, end =  April 13th 2013).
> I want to know if with the period type, period number and the reference date, we will be in this selected period.
> 
> Tarik
> 
> > Date: Wed, 12 Jun 2013 16:07:54 +0200
> > From: boris at codesynthesis.com
> > To: tenchu.tarik at hotmail.fr
> > CC: odb-users at codesynthesis.com
> > Subject: Re: [odb-users] String Query
> > 
> > Hi Tarik,
> > 
> > Tarik BENZ <tenchu.tarik at hotmail.fr> writes:
> > 
> > > I thing the best way to do what I want is to create a SQL Procedure.
> > 
> > Again, without knowing *what* you are trying to achieve it is hard
> > for me to say whether it is the best way. But my guess would probably
> > be that it is not.
> > 
> > 
> > > Is it possible to call a procedure with ODB?
> > 
> > Yes, you can use native views (Section 9.5 in the manual) to call stored
> > procedures. Something along these lines (SQL Server example):
> > 
> > // Assume my_stored_proc accepts two parameters (string and number) and
> > // its result set contains two columns (string and number).
> > //
> > #pragma db view query("EXEC my_stored_proc (?)")
> > struct my_stored_proc
> > {
> >   std::string str;
> >   unsigned long num;
> > };
> > 
> > typedef odb::query<my_stored_proc> query;
> > 
> > db.query<my_stored_proc> (query::_val ("abc") + "," + query::_val (123));
> > 
> > Boris
>