Latest revision |
Your text |
Line 2: |
Line 2: |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | |- valign="top" | + | |- |
− | | '''Procedure | + | | '''procedure |
| | dbo.uspPrintError | | | dbo.uspPrintError |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information.
| |
| |} | | |} |
| | | |
− | === Source ===
| |
| <pre> | | <pre> |
| -- uspPrintError prints error information about the error that caused | | -- uspPrintError prints error information about the error that caused |
Line 30: |
Line 27: |
| END; | | END; |
| </pre> | | </pre> |
− |
| |
− | === Dependencies ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | | '''Child Type
| |
− | | '''Child Object
| |
− |
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Procedure
| |
− | | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
| |
− |
| |
− | |
| |
− | |
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Table
| |
− | | [[Production.WorkOrder_(table)|Production.WorkOrder]]
| |
− |
| |
− | | Trigger
| |
− | | iWorkOrder
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Table
| |
− | | [[Production.WorkOrder_(table)|Production.WorkOrder]]
| |
− |
| |
− | | Trigger
| |
− | | uWorkOrder
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
| |
− |
| |
− | | Trigger
| |
− | | iPurchaseOrderDetail
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
| |
− |
| |
− | | Trigger
| |
− | | uPurchaseOrderDetail
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
| |
− |
| |
− | | Trigger
| |
− | | uPurchaseOrderHeader
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Table
| |
− | | [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
| |
− |
| |
− | | Trigger
| |
− | | dVendor
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Table
| |
− | | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
| |
− |
| |
− | | Trigger
| |
− | | iduSalesOrderDetail
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Table
| |
− | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
| |
− |
| |
− | | Trigger
| |
− | | uSalesOrderHeader
| |
− | |- valign="top"
| |
− | | Execute
| |
− | | Table
| |
− | | [[Sales.Store_(table)|Sales.Store]]
| |
− |
| |
− | | Trigger
| |
− | | iStore
| |
− | |}
| |
− |
| |
| | | |
| == automatically generated == | | == automatically generated == |
Line 120: |
Line 34: |
| | '''procedure | | | '''procedure |
| | dbo.uspPrintError | | | dbo.uspPrintError |
− | |- valign="top" | + | |- |
| + | |
| | '''Description | | | '''Description |
| | Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information. | | | Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information. |
| |- | | |- |
| + | |
| |} | | |} |
| | | |
Line 146: |
Line 62: |
| END; | | END; |
| </pre> | | </pre> |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Reference Type
| |
− | | '''Object Type
| |
− | | '''Referencing Object
| |
− |
| |
− | | '''Child Type
| |
− | | '''Child Object
| |
− |
| |
− | |-
| |
− | | Execute
| |
− | | Procedure
| |
− | | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
| |
− |
| |
− | |
| |
− | |
| |
− | |-
| |
− | | Execute
| |
− | | Table
| |
− | | [[Production.WorkOrder_(table)|Production.WorkOrder]]
| |
− |
| |
− | | Trigger
| |
− | | iWorkOrder
| |
− | |-
| |
− | | Execute
| |
− | | Table
| |
− | | [[Production.WorkOrder_(table)|Production.WorkOrder]]
| |
− |
| |
− | | Trigger
| |
− | | uWorkOrder
| |
− | |-
| |
− | | Execute
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
| |
− |
| |
− | | Trigger
| |
− | | iPurchaseOrderDetail
| |
− | |-
| |
− | | Execute
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderDetail_(table)|Purchasing.PurchaseOrderDetail]]
| |
− |
| |
− | | Trigger
| |
− | | uPurchaseOrderDetail
| |
− | |-
| |
− | | Execute
| |
− | | Table
| |
− | | [[Purchasing.PurchaseOrderHeader_(table)|Purchasing.PurchaseOrderHeader]]
| |
− |
| |
− | | Trigger
| |
− | | uPurchaseOrderHeader
| |
− | |-
| |
− | | Execute
| |
− | | Table
| |
− | | [[Purchasing.Vendor_(table)|Purchasing.Vendor]]
| |
− |
| |
− | | Trigger
| |
− | | dVendor
| |
− | |-
| |
− | | Execute
| |
− | | Table
| |
− | | [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
| |
− |
| |
− | | Trigger
| |
− | | iduSalesOrderDetail
| |
− | |-
| |
− | | Execute
| |
− | | Table
| |
− | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
| |
− |
| |
− | | Trigger
| |
− | | uSalesOrderHeader
| |
− | |-
| |
− | | Execute
| |
− | | Table
| |
− | | [[Sales.Store_(table)|Sales.Store]]
| |
− |
| |
− | | Trigger
| |
− | | iStore
| |
− | |}
| |