Related Topics • INFO: ISO Auto Holding of Received APDU until Shipped APDU is received from Lender • INFO: Changing Note Types for ISO • INFO: Expire Dates and ISO ILL • INFO: Forwarding Requests via ISO ILL • HOWTO: Going Live with Lending or Borrowing Only • See more

Other Support Options • Contact Atlas Systems Phone Numbers, Support Options, Online Help, and more. • Listserv Pose a question to other users.

Page Tools Print this page E-mail this page

Feedback How helpful was this article? 5 Best 4 3 2 1Worst 0 N/A Suggestions:

SUMMARY

There is a field - ISOPaymentMethod - that was added with the ISO Version 6.2.1.0 update. If you are not using ISO ILL and update to version 6.3.2.0 of the Client, you may find this field missing (the update scripts for both releases have since been updated so that any current updates will not give an error). To add this field after the fact, connect to your SQL Query Analyzer as the system administrator and run the script below.

EXAMPLE

USE ILLData
GO

IF NOT((select min(table_schema) from Information_schema.columns
where Table_Name = 'LenderAddresses' and Column_Name = 'ISOPaymentMethod') IS NOT NULL)
BEGIN
IF (Select min(Value) from Customization where CustKey = 'SSSLenderAddressesALL') = 'Yes'
BEGIN
EXEC ('alter table LenderAddressesALL add ISOPaymentMethod [varchar] (6)')
END
ELSE
BEGIN
EXEC ('alter table LenderAddresses add ISOPaymentMethod [varchar] (6)')
END
END
GO