This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-------------------------------------------------------------------------------------------------- | |
-- To remove a normal Invoice from the ePay database, you need to delete from three tables: | |
-- Invoice, InvoiceEntry, and InvoicePayment. However, our users might not know the exact | |
-- InvoiceNumber(s) you need, so you might need to recover them based on the customer and | |
-- "Voucher Number" (which is BatchNumber in the database). | |
-------------------------------------------------------------------------------------------------- | |
DECLARE @InvoiceID uniqueidentifier, @InvoiceNumber nvarchar(30), @BatchNumber nvarchar(25), @Amount decimal (19,2), @CustomerNumber nvarchar(25), @CustomerName nvarchar(65); | |
DECLARE curInvoiceID CURSOR LOCAL FAST_FORWARD FOR |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[SysODataActionAttribute("CalcMaintenanceDuration", true)] | |
public int CalculateMaintenanceDuration() | |
{ | |
//do something | |
return 0; | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
System.Exception e; | |
InteropPermission interopPermission; | |
try | |
{ | |
interopPermission = new InteropPermission(InteropKind::ComInterop); | |
interopPermission.assert(); | |
// REST OF CODE THAT MIGHT GENERATE A CLR ERROR | |
} | |
catch (Exception::CLRError) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/// <summary> | |
/// Generic dimension updater. Call this with the DefaultDimension of any table, and update that table’s DefaultDimension with the returned value. | |
/// | |
/// Sample usage: | |
/// hcmEmployment.DefaultDimension = xczDimensionHandler::PutDimension(hcmEmployment.DefaultDimension, ‘Favorite_Color’, ’01’); | |
/// hcmEmployment.validTimeStateUpdateMode(ValidTimeStateUpdate::Correction); // This may or may not be appropriate for your circumstances | |
/// hcmEmployment.update(); | |
/// | |
/// Based on sample code courtesy Steeve Gilbert. | |
/// </summary> |