111 |
|
except on E: Exception do |
112 |
|
writeln(OutFile,'Error Handled: ',E.Message); |
113 |
|
end; |
114 |
+ |
Transaction.Rollback; |
115 |
+ |
Transaction.Start; |
116 |
+ |
try |
117 |
+ |
writeln(OutFile,'Case sensitive Param SQL Test'); |
118 |
+ |
Statement := Attachment.PrepareWithNamedParameters(Transaction,'Update Employee Set Hire_Date = :Hire_Date Where emp_no = :emp_no',3,false,true); |
119 |
+ |
Statement.SQLParams.ByName('Hire_Date').AsDate := EncodeDate(2016,11,5); |
120 |
+ |
Statement.SQLParams.ByName('emp_no').AsInteger := 1; |
121 |
+ |
Statement.SQLParams.ByName('EMP_NO').AsInteger := 1; |
122 |
+ |
except on E: Exception do |
123 |
+ |
writeln(OutFile,'Error Handled: ',E.Message); |
124 |
+ |
end; |
125 |
|
end; |
126 |
|
|
127 |
|
procedure TTest16.ServiceTests(CharSet: AnsiString; SQLDialect: integer); |