Hi folks
This error has just seemed to pop up. I copied the offending DBMS action
out to a test file in case it was an error somewhere else in the
original taf but it replicates.
TAF File: /idocs/test.taf
Position: call_spGetUniqueFilename
Class: DBMS
Error Number: 0
Description: [Microsoft][ODBC SQL Server Driver]Invalid character value
for cast specification
TAF File: /idocs/test.taf
Position: call_spGetUniqueFilename
Class: Internal
Error Number: -101
Description: General error during data source operation.
I have a Direct DBMS action which calls the following
{call spGetUniqueFileName(
<@BIND NAME=uniqueName BINDTYPE=OUT DATATYPE=INTEGER SCOPE=LOCAL>
)}
The SQL SP it calls is the following
/****** Object: Stored Procedure dbo.spGetUniqueFileName Script
Date: 30/07/2002 14:48:10 ******/
CREATE Procedure spGetUniqueFileName
@UniqueName int OUTPUT
AS
begin tran -- transaction used to ensure only one process at a time does
this
select @UniqueName = (fldFileName+1) from tblFileNameGen
update tblFileNameGen set fldFileName = @UniqueName
commit tran
return (@UniqueName)
GO
The field its reading and updating is a NON NULL field INT(4) with a
value currently of 389.
The thing it works fine on the dev server and this is the test server
that is causing the issue.
Any ideas
Thanks
Niall
********************************************************************
This message is intended only for the use of the person(s) ("the intended
recipient(s)") to whom it is addressed. It may contain information which is
privileged and confidential within the meaning of applicable law. If you
are not the intended recipient, please contact the sender as soon as
possible. The views expressed in this communication may not necessarily
be the views held by LGCSB (Local Government Computer Services Board).
Any attachments have been checked by a virus scanner and appear to be
clean.
Please ensure that you also scan all messages, as LGCSB does not accept
any liability for contamination or damage to your systems.
********************************************************************
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
