blob: 5f08cd8d486960b3acc379231420c58001e54056 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
|
{$mode objfpc}
{$h+}
program testsdf;
uses DB,sdfdata,sysutils;
Procedure Dotest;
Var
I,Count : Integer;
begin
With TSdfDataSet.Create(Nil) do
try
Delimiter := #9;
FileName := 'fpc.ssy';
FirstLineAsSchema := False;
Schema.Add('First Name');
Schema.Add('Last Name');
Schema.Add('Email');
Open;
Count:=0;
Try
While Not EOF do
begin
Inc(Count);
Writeln('Record : ',Count);
For I:=0 to FieldCount-1 do
Writeln(Fields[i].FieldName,' : ',Fields[i].AsString);
Writeln('-------------------------------') ;
Next;
end;
Finally
Close;
end;
finally
free;
end;
end;
Procedure DoTest2;
begin
// if file does not exists, then create it with schema at first line
With TSdfDataSet.Create(Nil) do
try
Delimiter := #9;
FileName := 'fpc2.ssy';
FileMustExist := False;
FirstLineAsSchema := True;
Schema.Add('First Name');
Schema.Add('Last Name');
Schema.Add('Email');
Open;
AppendRecord(['FName', 'LName', 'name@freepascal.org']);
Close;
finally
Free;
end;
end;
begin
DoTest;
DoTest2;
end.
|
