bug with variables, link & stored procedures ?

[Steven Ophalvens]

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)



-----Oorspronkelijk bericht-----
Van: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] Namens Ivan Smahin
Verzonden: donderdag 27 maart 2008 15:24
Aan: Valentina Developers
Onderwerp: Re[2]: bug with variables, link & stored procedures ?

Hello Steven,

Thursday, March 27, 2008, 3:53:12 PM, you wrote:

> Hello Ivan,

> I hope this helps you in solving this.


The only thing I see is attempt to use binding values in place of SP
params. Definitely it should work, but obviously there is some glitch.

Actually, binded-values usage brings no much sense in this case in
terms of performance.

SP-body is prepared and 'cached' once (including params). So there is no
overhead with
preprocessing params on each call. Moreover in this case it
brings some extra operations for preparing and packing/unpacking params.

I suggest to avoid SP-call + binding combination.



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

_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina

__________ NOD32 2277 (20070518) Informatie __________

Dit bericht is gecontroleerd door het NOD32 Antivirus Systeem.
http://www.nod32.nl