I am doing an insert into a database via a call to a stored proceedure in SQL server.
I am running the following piece of code:
BBTID = fpmi.db.runUpdateQueryGetKey("exec dbo.usp_BBTCreateRecord '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s'" % (dt,dd,mm,yy,brand,tank,dest,cond))
It is doing the insert into the database and everything seems fine, but the value for BBTID is None after running this. I am expecting the record key for the insert that was done by the routine.
Am I am not sure if I am using the call incorrectly, or if the fact that it is a proceedure is messing things up?