I am using the SetAction function to create an Update on a datawindow. When
the SetAction function is called it
executes a stored procedure insert_web_twstrade. In that stored procedure
there are some validations done on the data entered. If there is a
validation error we raise error and send it back .

The below output is from the debug file viewer in Jaguar Manager. It shows
that the proc is being run and
we are returning an error message --- Value Date is a Holiday.Shouldn't the
return value os SetAction be -1 not
1 ?????

Also I deliberately set the return value of SetAction to -1 and tested to
see if GetLastError would return the error
Value Date is a Holiday and it didn't.

It looks like both SetAction and GetLastError are not working properly.

I have upgraded to the latest EA Studio my PB is build 8004.........

Any insight to this problem would be a great help.....

Feb 25 16:03:38 2000: HTMLDW: Entering SetAction('Update')
Feb 25 16:03:38 2000: Entering DataStore Loop2
Feb 25 16:03:38 2000: Entering DataStore Loop3
Feb 25 16:03:38 2000: Entering DataStore Loop4
Feb 25 16:03:38 2000: Entering DataStore Loop5
Feb 25 16:03:38 2000: Entering DataStore Loop6
Feb 25 16:03:38 2000: Entering DataStore HTMLContextApplied0
Feb 25 16:03:38 2000: Entering DataStore execute dbo.insert_web_twstrade
ecute dbo.insert_web_twstrade

Feb 25 16:03:38 2000: Server Message: UNTEST - 35001/16/1/: Value Date is a
Holiday
Feb 25 16:03:38 2000: Server Message: UNTEST - 266/10/1/ZZZZZ: Transaction
count
after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous
count = 1, Current count = 0.

Feb 25 16:03:38 2000: Server Message: UNTEST - 266/10/1/ZZZZZ: Transaction
count
after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous
count = 1, Current count = 0.

Feb 25 16:03:39 2000: HTMLDW: Exiting SQLCode = 0
Feb 25 16:03:39 2000: HTMLDW: Exiting SQLErrText =
Feb 25 16:03:39 2000: HTMLDW: Exiting SQLNRows = 0
Feb 25 16:03:39 2000: HTMLDW: Exiting GetlastError =
Feb 25 16:03:39 2000: HTMLDW: Exiting SetAction() = 1
Feb 25 16:03:39 2000: HTMLDW: EnableCommit()
Feb 25 16:03:39 2000: HTMLDW: Entering of_get_expirydate



Thanks

Raymond Keating