Error creating Stored procedure

forum.sourcecode (2000-2005) & forum.td.sourcecode (2005-2010)
Amit

Error creating Stored procedure

Post by Amit » 22 Aug 2006, 13:51

 Posted by:  Amit 


"SYSADM","INL30701",$long,30704,"P","Y","Y","Y","N",
PROCEDURE INSERT_FIRST_UNIT STATIC
PARAMETERS
Number: nPiece_Id
Number: nQuantity
LOCAL VARIABLES
Sql Handle: hSql
Actions
Call SqlConnect( hSql )
Call SqlPrepareAndExecute( hSql, 'UPDATE doc_workpieces SET qu_completed =
@NULLVALUE(qu_completed,0) + :nQuantity WHERE piece_id = :nPiece_Id')
Call SqlDisconnect( hSql )

what does the Top Line means in the above script?

--
Regards
Amit Goel

Jim McNamara

Re: Error creating Stored procedure

Post by Jim McNamara » 22 Aug 2006, 15:33

 Posted by:  Jim McNamara 

Please post your question to only one forum - even if you think you posted
to the wrong one.

Return to “td.sourcecode”

Who is online

Users browsing this forum: [Ccbot] and 0 guests