Hey all,
has anyone figure out how to use the database connectivity toolset to perform a parameterized query with outputs (SQL)? From the other threads that i have read it would seem that this issue is not resolved. The error i get is:
Error -2147467259 occurred at Cmd Execute.vi->getjobID.vi
Possible reason(s):
Exception occured in Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 3.51 Driver][mysqld-5.0.50sp1a-enterprise-gpl-log]OUT or INOUT argument 3 for routine eln.lv_caperJob_create is not a variable or NEW pseudo-variable in BEFORE trigger in Rec Create - Command.vi->Cmd Execute.vi->getjobID.vi
However, In Toad for mysql the following call works:
set @outJobID=-999;
set @outMsg="";
call lv_caperJob_create('TestJune30_2', '207', @outJobID, @outMsg);
select @outJobID, @outMsg
Attached is the LV code i am using. Thanks!
