bug with variables, link & stored procedures ?

[Ivan Smahin]

Hello Steven,

Thursday, March 27, 2008, 5:41:00 PM, you wrote:

> Hello Ivan,

> I replaced the binding of values with params, but the result (as far as I
> see) is exactly the same :

> in vServer_embedded.log :
> -------
> ...
> 16:20:51.651000 (4384): (708) I_SqlDatabase 'lpserver.vdb' SqlQuery 'call
> SP_ANSWER_QUESTION(1,6,710792656,8)'.
> 16:20:51.880000 (3004): (708) Database 'lpserver' has been successfully
> closed.
> ...
> 16:20:59.154000 (3004): (644) I_SqlDatabase 'lpserver.vdb' SqlQuery 'call
> SP_ANSWER_QUESTION(1,6,1389960124,8)'.
> 16:20:59.373000 (3004): (644) ERROR 0x70504: Record "10" does not exist in
> table "test_resultaten". 
> 16:20:59.391000 (4384): (644) Database 'lpserver' has been successfully
> closed.
> ...
> 16:21:15.425000 (4384): (680) I_SqlDatabase 'lpserver.vdb' SqlQuery 'call
> SP_ANSWER_QUESTION(0,6,1407737997,8)'.
> 16:21:15.728000 (4384): (680) ERROR 0x70504: Record "8" does not exist in
> table "test_resultaten". 
> 16:21:15.746000 (3004): (680) Database 'lpserver' has been successfully
> closed.
> ...
> -------
> In warnings log file :
> -------
> Print : VraagID
> Print : 710792656
> Print : SELECT Last_RecID( lpserver )
> Print : 1
> Print : SELECT Last_RecID( lpserver )
> Print : 1
> Print : VraagID
> Print : 1389960124
> Print : SELECT Last_RecID( lpserver )
> Print : 1
> Print : VraagID
> Print : 1407737997
> Print : SELECT Last_RecID( lpserver )
> Print : 1
> Print : SELECT Last_RecID( lpserver )
> Print : 1
> -----

> I have no idea where it gets those recID 10 & 8 from test_resultaten (which
> do not exist).

> The first time the SP is executed, it has correct values, subsequent times,
> it retains values
> from the first time. (as with the login SP example : even the select
> curtime() doesn't change)


Could you send me database for testing?

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com