Wait, I was right the first time Thomas Kennedy 14.Apr.04 04:18 PM Lotus Notes LEI LEI - 6.0Windows 2000
You can map int columns to text fields, it just won't run:
04/14/2004 09:26:06 AM Activity started
04/14/2004 09:26:06 AM Error: Field type mismatch: 'SomeIntValue' Source Connector field is type Integer, Target Connector field is type Text, Connector 'Notes: Int Test (Connection)', Method -Update-
04/14/2004 09:26:06 AM Activity Ended With An Error: SQL Server: Int Test (Direct Transfer)
In a direct transfer getting around this is easy, just put a CAST in the Select statement. But what would I do in a replication activity, other than add a number field to my form and use the Notes connector's Data Transformation tab to cast the value into the legacy text field?
Return to top
. . . . Wait, I was right the first time (Thomas Kennedy 14.Apr.04) 
Print this page
