53 |
|
ResultSet: IResultSet; |
54 |
|
Statement: IStatement; |
55 |
|
TPB: ITPB; |
56 |
+ |
us: UnicodeString; |
57 |
|
begin |
58 |
|
writeln(OutFile,'Employee Count = ',Attachment.OpenCursorAtStart('Select count(*) from EMPLOYEE')[0].AsInteger); |
59 |
|
|
102 |
|
Attachment.StartTransaction([isc_tpb_read,isc_tpb_nowait,isc_tpb_concurrency],taCommit), |
103 |
|
'Select count(*) As Counter from EMPLOYEE Where EMP_NO < ?',3,[8])[0].AsInteger); |
104 |
|
|
105 |
+ |
writeln(OutFile,'"Johnson" Employee Count = ',Attachment.OpenCursorAtStart( |
106 |
+ |
Attachment.StartTransaction([isc_tpb_read,isc_tpb_nowait,isc_tpb_concurrency],taCommit), |
107 |
+ |
'Select count(*) As Counter from EMPLOYEE Where LAST_NAME = ?',3,['Johnson'])[0].AsInteger); |
108 |
+ |
|
109 |
+ |
us := UTF8Decode('Yanowski'); {Test a UnicodeString as a parameter} |
110 |
+ |
|
111 |
+ |
writeln(OutFile,'"Yanowski" Employee Count = ',Attachment.OpenCursorAtStart( |
112 |
+ |
Attachment.StartTransaction([isc_tpb_read,isc_tpb_nowait,isc_tpb_concurrency],taCommit), |
113 |
+ |
'Select count(*) As Counter from EMPLOYEE Where LAST_NAME = ?',3,[us])[0].AsInteger); |
114 |
+ |
|
115 |
|
end; |
116 |
|
|
117 |
|
function TTest3.TestTitle: AnsiString; |