DataExchange command log -- SQL: SELECT [ID] AS CXID, [LastName], [FirstName] FROM [_CardExchange] ORDER BY [Location] -- SQL: SELECT * FROM [_CardExchange] WHERE [ID] = @PARAMETER0 @PARAMETER0 = 2409 -- SQL: SELECT * FROM [_CardExchange] WHERE [ID] = @PARAMETER0 @PARAMETER0 = 2065 -- SQL: SELECT * FROM [_CardExchange] WHERE [ID] = @PARAMETER0 @PARAMETER0 = 2426 -- SQL: INSERT INTO [_CardExchange] ([CompanyName], [EmploymentCategory], [FirstName], [LastName], [NewCardNo], [NewCardExpiry], [Location]) VALUES (@PARAMETER0, @PARAMETER1, @PARAMETER2, @PARAMETER3, @PARAMETER4, @PARAMETER5, @PARAMETER6) @PARAMETER0 = PC1Test1 @PARAMETER1 = Contractor @PARAMETER2 = PC1Test2 @PARAMETER3 = PC1Test2 @PARAMETER4 = 200000 @PARAMETER5 = 1/09/2014 12:00:00 AM @PARAMETER6 = Brisbane -- SQL: SELECT @@IDENTITY -- SQL: SELECT * FROM [_CardExchange] WHERE [ID] = @PARAMETER0 @PARAMETER0 = 2427 -- SQL: SELECT * FROM [_CardExchange] WHERE [ID] = @PARAMETER0 @PARAMETER0 = 2427 -- SQL: SELECT * FROM [_CardExchange] WHERE [ID] = @PARAMETER0 @PARAMETER0 = 2427 -- SQL: INSERT INTO [_CardExchange] ([EmploymentCategory], [FirstName], [LastName], [NewCardNo], [NewCardExpiry], [Location]) VALUES (@PARAMETER0, @PARAMETER1, @PARAMETER2, @PARAMETER3, @PARAMETER4, @PARAMETER5) @PARAMETER0 = Full Time @PARAMETER1 = PC1Test3 @PARAMETER2 = PC1Test3 @PARAMETER3 = 200000 @PARAMETER4 = 1/09/2014 12:00:00 AM @PARAMETER5 = Brisbane -- SQL: SELECT @@IDENTITY -- SQL: SELECT * FROM [_CardExchange] WHERE [ID] = @PARAMETER0 @PARAMETER0 = 2428 -- SQL: SELECT * FROM [_CardExchange] WHERE [ID] = @PARAMETER0 @PARAMETER0 = 2428