Re: [Mingw-users] odbc gurus

[Jeremy B. <je...@de...>]

I did find this paragraph in MSDN.  It appears that you could always use 
SQL_PARAM_INPUT_OUTPUT and check the returned values after execute.

-- from msdn--
SQL_PARAM_INPUT_OUTPUT. The parameter marks an input/output parameter in a 
procedure. For example, the parameter in {call GetEmpDept(?)} is an 
input/output parameter that accepts an employee's name and returns the name 
of the employee's department.
When the statement is executed, the driver sends data for the parameter to 
the data source; the *ParameterValuePtr buffer must contain a valid input 
value, or the *StrLen_or_IndPtr buffer must contain SQL_NULL_DATA, 
SQL_DATA_AT_EXEC, or the result of the SQL_LEN_DATA_AT_EXEC macro. After the 
statement is executed, the driver returns data for the parameter to the 
application; if the data source does not return a value for an input/output 
parameter, the driver sets the *StrLen_or_IndPtr buffer to SQL_NULL_DATA.

----- Original Message ----- 
From: <hm...@gm...>
To: <min...@li...>
Sent: Wednesday, February 23, 2005 4:56 AM
Subject: [Mingw-users] odbc gurus


> Hi!
> Are there any odbc-gurus here? I know this may not be the best place for
> this (- am sorry for that), but there is no error in trial.
>
> is there anyway I can know whether the parameters of a stored procedure
> is an input, output or input_output after preparing the sql-statement
> but before executing the statement. If you have an example, I would
> appreciate it too.
>
> I have checked in the documentation, but could not find anything. Please 
> if
> anyone has done something in this direction (may be a workaround), do 
> kindly
> let me know.
> Thanks
> Harp
>
>
>
> -- 
> Lassen Sie Ihren Gedanken freien Lauf... z.B. per FreeSMS
> GMX bietet bis zu 100 FreeSMS/Monat: http://www.gmx.net/de/go/mail
>
>
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> MinGW-users mailing list
> Min...@li...
>
> You may change your MinGW Account Options or unsubscribe at:
> https://lists.sourceforge.net/lists/listinfo/mingw-users
>