Are Vorgid and the field in Assignment table, OrdId both defined as BigInt?
Also, if LevelCheck is not equal to 1 Vorgid is not initialized and will contain null. Thanks, Ed Mendez From: [email protected] [mailto:[email protected]] Sent: Tuesday, October 20, 2015 12:00 PM To: [email protected] Subject: [firebird-support] Re: invalid request BLR at offset 667 bad parameter number I've tracked down the problem to the variable Vorgid inside the insert into statement. This is a variable that I have declared at the beginning of the procedure and I am using a select statement to set it's value. So the question is what is the correct way to use this variable with the Insert statement.
