MS data block problem?

  • Thread starter Thread starter jw56578
  • Start date Start date
J

jw56578

the situation is:
I'm using the sqlhelper.executenonquery
send two paramters, vehicleID(output) and statusid
stored procedure code:
if vehicleID is null then insert into table with statusID and return
vehicle id
if vehicleID is not null then update where vehicleID = vehicleID set
statusID = status id

problem: when i call procedure and send a value for vehicleID, I notice
in query profiler that the value being sent turns into a new identifier
value as if a new vehicle had been added.

whats going on?
 
Back
Top