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
65
66
67
68
69
70
71
72
|
{*******************************************************}
{ }
{ Add FastReport SQL Support Lbrary }
{ }
{ Copyright (c) 2001 by Stalker SoftWare }
{ }
{*******************************************************}
unit frFuncSQL;
interface
uses
SysUtils;
function frCreateStr(cStr :String) :String;
function frCreateNum(cNum :String ) :String;
function frCreateDate(cDate :String; cFFormatDate: String) :String;
{.$I FR.inc}
// StLib
implementation
uses
frFuncStr, frFuncDate;
{--------------------------------------------------------------------}
{ Return quoted string cStr creating SQL request }
{--------------------------------------------------------------------}
function frCreateStr(cStr :String) :String;
begin
if Trim(cStr) = '' then
Result := 'null'
else
Result := CHR(39)+cStr+CHR(39);
end; { frCreateStr }
{--------------------------------------------------------------------}
{ Return prepared string with number for creating SQL request. }
{ Possible comma in string is changed by point. }
{--------------------------------------------------------------------}
function frCreateNum(cNum :String) :String;
begin
if Trim(cNum) = '' then
Result := 'null'
else
Result := frReplaceStr(cNum,DecimalSeparator,'.');
end; { frCreateNum }
{--------------------------------------------------------------------}
{ Return prepared quoted string cDate }
{ with date for crqting SQL request. }
{ cFEmptyDate this empty date, returned by (for example) }
{ RxDateEdit.Text. Example ' . . ' }
{ cFFormatDate this format date specified by SQL server. }
{ Example 'yyyy/mm/dd' }
{--------------------------------------------------------------------}
function frCreateDate(cDate :String; cFFormatDate: String) :String;
begin
if not frValidDate(cDate) then
Result := 'null'
else
Result := CHR(39)+FormatDateTime( cFFormatDate, StrToDateTime(cDate) )+CHR(39);
end; { frCreateDate }
end.
|
