From: Olaf K. <ola...@sa...> - 2008-12-08 11:13:51
|
Hello, Please, can you help me, how can I realise it? The code is an example and is understood to work. How is the architecture of the vba-code? Thank you. Olaf Olaf Kluge wrote: > Hello, > Hi, > I have a problem with the firebird odbc driver. I use a connection with > adodb in microsoft access: (vba) This one is only a test with > test-parameters! > > When I use only a input-parameter, the procedure-call works fine. But the > return-parameter doesn't work, the procedure does not startet. > ADO generates the following statement for ODBC driver in your case - { call TTT(?,?) }. Next Firebird ODBC driver generates statement - select * from TTT(?). Therefore you can not use output parameters but you can use query result set. > If I switch the input/output-parameter (output first), I get an error > message: Laufzeitfehler... [ODBC Firebird Driver]not yet implemented > It is by design. Regards, Alexander -- Alexander Potapchenko http://www.red-soft.biz Senior developer ---------------------------------------------------------------------------- -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ _______________________________________________ Firebird-odbc-devel mailing list Fir...@li... https://lists.sourceforge.net/lists/listinfo/firebird-odbc-devel Internal Virus Database is out of date. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.9.13/1828 - Release Date: 04.12.2008 08:05 |