Once again a big waste of my time!
Figured I'd use an existing method to pump data, one that works well to pump FB>MSSQL and ended up having to debug Loader..
Using:
Code: Select all
Loader.TableName := LTableName;
Loader.LoadFromDataSet(MyQuery);
Code: Select all
Statement 1226:
-------------------------------------------------------------------------------
INSERT INTO SERVERS(ID,DOMAINID,SERVER,ISDC,WASONLINE,OSTYPE,OSCOMMENT,OSFLAGS,EXCLUDEFROMFETCH,INFETCHDATA) VALUES (?,?,?,?,?,?,?,?,?,?)
param0 = bigint, "2"
param1 = bigint, "1"
param2 = varchar(252), "VMFI" << 'VMFileServer'
param3 = boolean, "<false>"
param4 = boolean, "<true>"
param5 = integer, "0"
param6 = varchar(320), "Hell" << 'Hello'
param7 = integer, "<NULL>"
param8 = boolean, "<true>"
param9 = boolean, "<false>"
Statement 1227:
-------------------------------------------------------------------------------
INSERT INTO SERVERS(ID,DOMAINID,SERVER,ISDC,WASONLINE,OSTYPE,OSCOMMENT,OSFLAGS,EXCLUDEFROMFETCH,INFETCHDATA) VALUES (?,?,?,?,?,?,?,?,?,?)
param0 = bigint, "3"
param1 = bigint, "1"
param2 = varchar(252), "VMFI" << 'VMFileServer2'
param3 = boolean, "<false>"
param4 = boolean, "<true>"
param5 = integer, "0"
param6 = varchar(320), "Test"
param7 = integer, "<NULL>"
param8 = boolean, "<true>"
param9 = boolean, "<false>"
Code: Select all
object Loader: TUniLoader
Connection = TestCon
Transaction = TestTransaction
SpecificOptions.Strings = (
'SQL Server.KeepIdentity=True'
'SQL Server.KeepNulls=True'
'InterBase.AutoCommit=False')
end