1 |
|
unit Test4; |
2 |
+ |
{$IFDEF MSWINDOWS} |
3 |
+ |
{$DEFINE WINDOWS} |
4 |
+ |
{$ENDIF} |
5 |
|
|
6 |
< |
{$mode objfpc}{$H+} |
6 |
> |
{$IFDEF FPC} |
7 |
> |
{$mode delphi} |
8 |
|
{$codepage utf8} |
9 |
+ |
{$ENDIF} |
10 |
|
|
11 |
|
{Test 4: Update, Insert and Delete Queries} |
12 |
|
|
49 |
|
private |
50 |
|
procedure DoQuery(Attachment: IAttachment); |
51 |
|
public |
52 |
< |
function TestTitle: string; override; |
53 |
< |
procedure RunTest(CharSet: string; SQLDialect: integer); override; |
52 |
> |
function TestTitle: AnsiString; override; |
53 |
> |
procedure RunTest(CharSet: AnsiString; SQLDialect: integer); override; |
54 |
|
end; |
55 |
|
|
56 |
|
|
116 |
|
ByName('EMP_NO').AsInteger := 151; |
117 |
|
ByName('FIRST_NAME').AsString := 'Major'; |
118 |
|
ByName('PHONE_EXT').AsString := ''; |
119 |
< |
ByName('HIRE_DATE').AsDateTime := EncodeDate(2015,4,1);; |
119 |
> |
ByName('HIRE_DATE').AsString := '2015-4-1'; |
120 |
|
ByName('DEPT_NO').AsString := '600'; |
121 |
|
ByName('JOB_CODE').AsString := 'Eng'; |
122 |
|
ByName('JOB_GRADE').AsInteger := 4; |
123 |
|
ByName('JOB_COUNTRY').AsString := 'England'; |
124 |
< |
ByName('SALARY').AsFloat := 40000.59; |
124 |
> |
ByName('SALARY').AsString := '40000.59'; |
125 |
|
end; |
126 |
|
Statement.Execute; |
127 |
|
WriteAffectedRows(Statement); |
196 |
|
ReportResults(Statement); |
197 |
|
end; |
198 |
|
|
199 |
< |
function TTest4.TestTitle: string; |
199 |
> |
function TTest4.TestTitle: AnsiString; |
200 |
|
begin |
201 |
|
Result := 'Test 4: Update, Insert and Delete Queries'; |
202 |
|
end; |
203 |
|
|
204 |
< |
procedure TTest4.RunTest(CharSet: string; SQLDialect: integer); |
204 |
> |
procedure TTest4.RunTest(CharSet: AnsiString; SQLDialect: integer); |
205 |
|
var Attachment: IAttachment; |
206 |
|
DPB: IDPB; |
207 |
|
begin |