Back to SPR List Previous Next
Import Records can have a problem with MS SQL Server keys
Minor Closed - Fixed Found:XS.01.10 08 DEC 2008 Fixed:XS.01.11 12 DEC 2008

DETAILS
 If the chosen key fields are not first and in sequence then any variables between are
 read as NULL. This is
 because SQL Server ODBC driver does not support using SQLGetData to retrieve data in
 random column order and import records tries
 to read the key variables first.
EXAMPLE PROGRAM
WORKAROUND
Modify the select statement to include the keys first and in order.
Back to SPR List Previous Next