Re: Problems with null value in SP on 7.3 NT (C1?)

Alexey Bespaliy wrote: > Hi Alexander, > > I tried it with 7.30.TC2 and couldn't reproduce your problem. > The procedure returns 0 for me... > > What exactly the version of IDS do you have? > > Regards, > Alexey Hi Alex ! When I was looked into systables it states 7.30C1. but now I'm understand that that 7.3 is not the real problem -- that procedure was created in the following matter : via " dbaccess - file.sql", file.sql was taken from dbexport generated file (those procedure was cut from it and exp file was loaded via dbimport without it). But first time I creates similar procedure (but with another name) in SQLEditor by hand in the same database that was used to load "file.sql" -- I got the problem. When hand-made procedure was recreated in SQLEditor It's start working. When dbaccessed procedure was recreated in SQLEditor It's start working. I can't get the same error when I performs "file.sql" via dbaccess in another database without that procedures before. That is a stable problem in 7.2x, 7.3 when procedures was created via dbexport/dbimport ( the problems occurs more often but not always) -- my solution is to cut procedures from dbexported scripts and recreate them in SQLEditor not dbaccess (looks like dbimport works throught dbaccess to process import scripts). I'm know that sometimes dbimport can't load dbexported file (it tells about syntax error while sqleditor load it fine) but I thouth that if it pass scripts it would be processed in right manner;) If I'll got that problem once again I'll told you :) Thanks for everyone who tries to help ! Sincerely, Alexander -- Alexander V.Didytch, Kyiv, Ukraine Data is like garbage. You better be sure what you're going to do with it before you collect it. --Mark Twain