For some reason when executing stored procedure in Sybase from SilkTest (ODBC), and if that stored procedure executes more stored procedures, than stored procedures within executed stored procedure are not executed.
For example:
sql = DB_ExecuteSql (db, "exec sp_insert_record ‘George’, NULL, ‘Bush’")
DB_FinishSQL (sql)
(Where stored procedure sp_insert_record executes other stored procedure to get ID then
Inserts [id], ‘George’, NULL, ‘Bush’)
The result I’m getting, record without ID/ ID field = 0.
I know for sure that second stored procedure wasn’t executed, I tested locking the table where it was suppose to get the ID.