33 |
|
|
34 |
|
unit IBCustomDataSet; |
35 |
|
|
36 |
– |
{$IF FPC_FULLVERSION >= 20700 } |
37 |
– |
{$codepage UTF8} |
38 |
– |
{$DEFINE HAS_ANSISTRING_CODEPAGE} |
39 |
– |
{$DEFINE NEW_TBOOKMARK} |
40 |
– |
{$ENDIF} |
41 |
– |
|
36 |
|
{$R-} |
37 |
|
|
38 |
+ |
{$IFDEF FPC} |
39 |
|
{$Mode Delphi} |
40 |
+ |
{$codepage UTF8} |
41 |
+ |
{$ENDIF} |
42 |
|
|
43 |
|
{$IFDEF DELPHI} |
44 |
|
{$DEFINE TDBDFIELD_IS_BCD} |
52 |
|
{$ELSE} |
53 |
|
unix, |
54 |
|
{$ENDIF} |
55 |
< |
SysUtils, Classes, IBDatabase, IBExternals, IB, IBHeader, IBSQL, Db, |
56 |
< |
IBUtils, IBBlob, IBSQLParser; |
55 |
> |
SysUtils, Classes, IBDatabase, IBExternals, IB, IBSQL, Db, |
56 |
> |
IBUtils, IBBlob, IBSQLParser, IBDatabaseInfo; |
57 |
|
|
58 |
|
const |
59 |
|
BufferCacheSize = 1000; { Allocate cache in this many record chunks} |
74 |
|
procedure SetDataSet(ADataSet: TIBCustomDataSet); virtual; abstract; |
75 |
|
procedure Apply(UpdateKind: TUpdateKind; buff: PChar); virtual; abstract; |
76 |
|
function GetSQL(UpdateKind: TUpdateKind): TStrings; virtual; abstract; |
77 |
< |
procedure InternalSetParams(Query: TIBSQL; buff: PChar); |
77 |
> |
procedure InternalSetParams(Params: ISQLParams; buff: PChar); overload; |
78 |
> |
procedure InternalSetParams(Query: TIBSQL; buff: PChar); overload; |
79 |
> |
procedure UpdateRecordFromQuery(QryResults: IResults; Buffer: PChar); |
80 |
|
property DataSet: TIBCustomDataSet read GetDataSet write SetDataSet; |
81 |
|
public |
82 |
|
constructor Create(AOwner: TComponent); override; |
87 |
|
|
88 |
|
TBlobDataArray = array[0..0] of TIBBlobStream; |
89 |
|
PBlobDataArray = ^TBlobDataArray; |
90 |
+ |
TIBArrayField = class; |
91 |
|
|
92 |
< |
{ TIBCustomDataSet } |
93 |
< |
TFieldData = record |
94 |
< |
fdDataType: Short; |
95 |
< |
fdDataScale: Short; |
96 |
< |
fdNullable: Boolean; |
97 |
< |
fdIsNull: Boolean; |
98 |
< |
fdDataSize: Short; |
99 |
< |
fdDataLength: Short; |
100 |
< |
fdDataOfs: Integer; |
101 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
102 |
< |
fdCodePage: TSystemCodePage; |
103 |
< |
{$ENDIF} |
92 |
> |
{ TIBArray } |
93 |
> |
|
94 |
> |
{Wrapper class to support array cache in TIBCustomDataset and event handling} |
95 |
> |
|
96 |
> |
TIBArray = class |
97 |
> |
private |
98 |
> |
FArray: IArray; |
99 |
> |
FRecNo: integer; |
100 |
> |
FField: TIBArrayField; |
101 |
> |
procedure EventHandler(Sender: IArray; Reason: TArrayEventReason); |
102 |
> |
public |
103 |
> |
constructor Create(aField: TIBArrayField; anArray: IArray); |
104 |
> |
destructor Destroy; override; |
105 |
> |
property ArrayIntf: IArray read FArray; |
106 |
|
end; |
107 |
< |
PFieldData = ^TFieldData; |
107 |
> |
|
108 |
> |
TArrayDataArray = array [0..0] of TIBArray; |
109 |
> |
PArrayDataArray = ^TArrayDataArray; |
110 |
> |
|
111 |
> |
{ TIBCustomDataSet } |
112 |
|
|
113 |
|
TCachedUpdateStatus = ( |
114 |
|
cusUnmodified, cusModified, cusInserted, |
119 |
|
end; |
120 |
|
PIBDBKey = ^TIBDBKey; |
121 |
|
|
122 |
+ |
PFieldData = ^TFieldData; |
123 |
+ |
TFieldData = record |
124 |
+ |
fdIsNull: Boolean; |
125 |
+ |
fdDataLength: Short; |
126 |
+ |
end; |
127 |
+ |
|
128 |
+ |
PColumnData = ^TColumnData; |
129 |
+ |
TColumnData = record |
130 |
+ |
fdDataType: Short; |
131 |
+ |
fdDataScale: Short; |
132 |
+ |
fdNullable: Boolean; |
133 |
+ |
fdDataSize: Short; |
134 |
+ |
fdDataOfs: Integer; |
135 |
+ |
fdCodePage: TSystemCodePage; |
136 |
+ |
end; |
137 |
+ |
|
138 |
+ |
PFieldColumns = ^TFieldColumns; |
139 |
+ |
TFieldColumns = array[1..1] of TColumnData; |
140 |
+ |
|
141 |
|
TRecordData = record |
142 |
|
rdBookmarkFlag: TBookmarkFlag; |
143 |
|
rdFieldCount: Short; |
150 |
|
end; |
151 |
|
PRecordData = ^TRecordData; |
152 |
|
|
153 |
+ |
{ TIBArrayField } |
154 |
+ |
|
155 |
+ |
TIBArrayField = class(TField) |
156 |
+ |
private |
157 |
+ |
FArrayBounds: TArrayBounds; |
158 |
+ |
FArrayDimensions: integer; |
159 |
+ |
FRelationName: string; |
160 |
+ |
FCacheOffset: word; |
161 |
+ |
function GetArrayID: TISC_QUAD; |
162 |
+ |
function GetArrayIntf: IArray; |
163 |
+ |
procedure SetArrayIntf(AValue: IArray); |
164 |
+ |
protected |
165 |
+ |
class procedure CheckTypeSize(AValue: Longint); override; |
166 |
+ |
function GetAsString: string; override; |
167 |
+ |
function GetDataSize: Integer; override; |
168 |
+ |
procedure Bind(Binding: Boolean); override; |
169 |
+ |
public |
170 |
+ |
constructor Create(AOwner: TComponent); override; |
171 |
+ |
function CreateArray: IArray; |
172 |
+ |
property ArrayID: TISC_QUAD read GetArrayID; |
173 |
+ |
property ArrayIntf: IArray read GetArrayIntf write SetArrayIntf; |
174 |
+ |
property ArrayDimensions: integer read FArrayDimensions write FArrayDimensions; |
175 |
+ |
property ArrayBounds: TArrayBounds read FArrayBounds write FArrayBounds; |
176 |
+ |
end; |
177 |
+ |
|
178 |
|
{ TIBStringField allows us to have strings longer than 8196 } |
179 |
|
|
180 |
|
TIBStringField = class(TStringField) |
181 |
|
private |
182 |
|
FCharacterSetName: RawByteString; |
183 |
|
FCharacterSetSize: integer; |
184 |
+ |
FAutoFieldSize: boolean; |
185 |
+ |
FCodePage: TSystemCodePage; |
186 |
+ |
FDataSize: integer; |
187 |
|
protected |
188 |
< |
function GetDefaultWidth: Longint; override; |
188 |
> |
procedure Bind(Binding: Boolean); override; |
189 |
> |
function GetDataSize: Integer; override; |
190 |
|
public |
191 |
|
constructor Create(aOwner: TComponent); override; |
192 |
|
class procedure CheckTypeSize(Value: Integer); override; |
196 |
|
procedure SetAsString(const Value: string); override; |
197 |
|
property CharacterSetName: RawByteString read FCharacterSetName write FCharacterSetName; |
198 |
|
property CharacterSetSize: integer read FCharacterSetSize write FCharacterSetSize; |
199 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
200 |
< |
private |
201 |
< |
FCodePage: TSystemCodePage; |
148 |
< |
public |
149 |
< |
property CodePage: TSystemCodePage read FCodePage write FCodePage; |
150 |
< |
{$ENDIF} |
199 |
> |
property CodePage: TSystemCodePage read FCodePage write FCodePage; |
200 |
> |
published |
201 |
> |
property AutoFieldSize: boolean read FAutoFieldSize write FAutoFieldSize default true; |
202 |
|
end; |
203 |
|
|
204 |
|
{ TIBBCDField } |
209 |
|
Note: y > 4 will default to Floats |
210 |
|
} |
211 |
|
TIBBCDField = class(TBCDField) |
212 |
+ |
private |
213 |
+ |
FIdentityColumn: boolean; |
214 |
|
protected |
215 |
+ |
procedure Bind(Binding: Boolean); override; |
216 |
|
class procedure CheckTypeSize(Value: Integer); override; |
217 |
|
function GetAsCurrency: Currency; override; |
218 |
|
function GetAsString: string; override; |
220 |
|
function GetDataSize: Integer; override; |
221 |
|
public |
222 |
|
constructor Create(AOwner: TComponent); override; |
223 |
+ |
property IdentityColumn: boolean read FIdentityColumn; |
224 |
|
published |
225 |
|
property Size default 8; |
226 |
|
end; |
227 |
|
|
228 |
+ |
{The following integer field types extend the built in versions to enable IBX appplications |
229 |
+ |
to check for an Identity column} |
230 |
+ |
|
231 |
+ |
{ TIBSmallintField } |
232 |
+ |
|
233 |
+ |
TIBSmallintField = class(TSmallintField) |
234 |
+ |
private |
235 |
+ |
FIdentityColumn: boolean; |
236 |
+ |
protected |
237 |
+ |
procedure Bind(Binding: Boolean); override; |
238 |
+ |
public |
239 |
+ |
property IdentityColumn: boolean read FIdentityColumn; |
240 |
+ |
end; |
241 |
+ |
|
242 |
+ |
{ TIBIntegerField } |
243 |
+ |
|
244 |
+ |
TIBIntegerField = class(TIntegerField) |
245 |
+ |
private |
246 |
+ |
FIdentityColumn: boolean; |
247 |
+ |
protected |
248 |
+ |
procedure Bind(Binding: Boolean); override; |
249 |
+ |
public |
250 |
+ |
property IdentityColumn: boolean read FIdentityColumn; |
251 |
+ |
end; |
252 |
+ |
|
253 |
+ |
{ TIBLargeIntField } |
254 |
+ |
|
255 |
+ |
TIBLargeIntField = class(TLargeIntField) |
256 |
+ |
private |
257 |
+ |
FIdentityColumn: boolean; |
258 |
+ |
protected |
259 |
+ |
procedure Bind(Binding: Boolean); override; |
260 |
+ |
public |
261 |
+ |
property IdentityColumn: boolean read FIdentityColumn; |
262 |
+ |
end; |
263 |
+ |
|
264 |
|
{TIBMemoField} |
265 |
|
{Allows us to show truncated text in DBGrids and anything else that uses |
266 |
|
DisplayText} |
272 |
|
FDisplayTextAsClassName: boolean; |
273 |
|
function GetTruncatedText: string; |
274 |
|
protected |
275 |
+ |
procedure Bind(Binding: Boolean); override; |
276 |
|
function GetAsString: string; override; |
277 |
|
function GetDefaultWidth: Longint; override; |
278 |
|
procedure GetText(var AText: string; ADisplayText: Boolean); override; |
284 |
|
published |
285 |
|
property DisplayTextAsClassName: boolean read FDisplayTextAsClassName |
286 |
|
write FDisplayTextAsClassName; |
195 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
287 |
|
private |
288 |
|
FCodePage: TSystemCodePage; |
289 |
|
FFCodePage: TSystemCodePage; |
290 |
|
public |
291 |
|
property CodePage: TSystemCodePage read FFCodePage write FFCodePage; |
201 |
– |
{$ENDIF} |
292 |
|
end; |
293 |
|
|
294 |
|
TIBDataLink = class(TDetailDataLink) |
346 |
|
TIBAutoCommit = (acDisabled, acCommitRetaining); |
347 |
|
|
348 |
|
{ TIBCustomDataSet } |
349 |
+ |
|
350 |
|
TIBUpdateAction = (uaFail, uaAbort, uaSkip, uaRetry, uaApply, uaApplied); |
351 |
|
|
352 |
|
TIBUpdateErrorEvent = procedure(DataSet: TDataSet; E: EDatabaseError; |
363 |
|
|
364 |
|
TIBCustomDataSet = class(TDataset) |
365 |
|
private |
366 |
+ |
FAllowAutoActivateTransaction: Boolean; |
367 |
+ |
FArrayFieldCount: integer; |
368 |
+ |
FArrayCacheOffset: integer; |
369 |
|
FAutoCommit: TIBAutoCommit; |
370 |
|
FGenerateParamNames: Boolean; |
371 |
|
FGeneratorField: TIBGenerator; |
372 |
|
FNeedsRefresh: Boolean; |
373 |
|
FForcedRefresh: Boolean; |
374 |
|
FDidActivate: Boolean; |
281 |
– |
FIBLoaded: Boolean; |
375 |
|
FBase: TIBBase; |
376 |
|
FBlobCacheOffset: Integer; |
377 |
|
FBlobStreamList: TList; |
378 |
+ |
FArrayList: TList; |
379 |
|
FBufferChunks: Integer; |
380 |
|
FBufferCache, |
381 |
|
FOldBufferCache: PChar; |
401 |
|
FQRefresh, |
402 |
|
FQSelect, |
403 |
|
FQModify: TIBSQL; |
404 |
+ |
FDatabaseInfo: TIBDatabaseInfo; |
405 |
|
FRecordBufferSize: Integer; |
406 |
|
FRecordCount: Integer; |
407 |
|
FRecordSize: Integer; |
430 |
|
FCloseAction: TTransactionAction; |
431 |
|
FInTransactionEnd: boolean; |
432 |
|
FIBLinks: TList; |
433 |
< |
function GetSelectStmtHandle: TISC_STMT_HANDLE; |
433 |
> |
FFieldColumns: PFieldColumns; |
434 |
> |
procedure ColumnDataToBuffer(QryResults: IResults; ColumnIndex, |
435 |
> |
FieldIndex: integer; Buffer: PChar); |
436 |
> |
procedure InitModelBuffer(Qry: TIBSQL; Buffer: PChar); |
437 |
> |
function GetSelectStmtIntf: IStatement; |
438 |
|
procedure SetUpdateMode(const Value: TUpdateMode); |
439 |
|
procedure SetUpdateObject(Value: TIBDataSetUpdateObject); |
440 |
|
|
446 |
|
function CanRefresh: Boolean; |
447 |
|
procedure CheckEditState; |
448 |
|
procedure ClearBlobCache; |
449 |
+ |
procedure ClearArrayCache; |
450 |
|
procedure ClearIBLinks; |
451 |
|
procedure CopyRecordBuffer(Source, Dest: Pointer); |
452 |
|
procedure DoBeforeDatabaseDisconnect(Sender: TObject); |
458 |
|
procedure FetchCurrentRecordToBuffer(Qry: TIBSQL; RecordNumber: Integer; |
459 |
|
Buffer: PChar); |
460 |
|
function GetDatabase: TIBDatabase; |
361 |
– |
function GetDBHandle: PISC_DB_HANDLE; |
461 |
|
function GetDeleteSQL: TStrings; |
462 |
|
function GetInsertSQL: TStrings; |
463 |
< |
function GetSQLParams: TIBXSQLDA; |
463 |
> |
function GetSQLParams: ISQLParams; |
464 |
|
function GetRefreshSQL: TStrings; |
465 |
|
function GetSelectSQL: TStrings; |
466 |
< |
function GetStatementType: TIBSQLTypes; |
466 |
> |
function GetStatementType: TIBSQLStatementTypes; |
467 |
|
function GetModifySQL: TStrings; |
468 |
|
function GetTransaction: TIBTransaction; |
370 |
– |
function GetTRHandle: PISC_TR_HANDLE; |
469 |
|
function GetParser: TSelectSQLParser; |
470 |
|
procedure InternalDeleteRecord(Qry: TIBSQL; Buff: Pointer); virtual; |
471 |
|
function InternalLocate(const KeyFields: string; const KeyValues: Variant; |
480 |
|
procedure SetDatabase(Value: TIBDatabase); |
481 |
|
procedure SetDeleteSQL(Value: TStrings); |
482 |
|
procedure SetInsertSQL(Value: TStrings); |
483 |
< |
procedure SetInternalSQLParams(Qry: TIBSQL; Buffer: Pointer); |
483 |
> |
procedure SetInternalSQLParams(Params: ISQLParams; Buffer: Pointer); |
484 |
|
procedure SetRefreshSQL(Value: TStrings); |
485 |
|
procedure SetSelectSQL(Value: TStrings); |
486 |
|
procedure SetModifySQL(Value: TStrings); |
487 |
|
procedure SetTransaction(Value: TIBTransaction); |
488 |
|
procedure SetUpdateRecordTypes(Value: TIBUpdateRecordTypes); |
489 |
|
procedure SetUniDirectional(Value: Boolean); |
490 |
+ |
procedure UpdateRecordFromQuery(QryResults: IResults; Buffer: PChar); |
491 |
|
procedure RefreshParams; |
492 |
|
function AdjustPosition(FCache: PChar; Offset: DWORD; |
493 |
|
Origin: Integer): DWORD; |
521 |
|
procedure SQLChanging(Sender: TObject); virtual; |
522 |
|
procedure SQLChanged(Sender: TObject); virtual; |
523 |
|
|
524 |
< |
(* { IProviderSupport } |
524 |
> |
{ IProviderSupport } |
525 |
|
procedure PSEndTransaction(Commit: Boolean); override; |
526 |
|
function PSExecuteStatement(const ASQL: string; AParams: TParams; |
527 |
|
ResultSet: Pointer = nil): Integer; override; |
534 |
|
procedure PSStartTransaction; override; |
535 |
|
procedure PSReset; override; |
536 |
|
function PSUpdateRecord(UpdateKind: TUpdateKind; Delta: TDataSet): Boolean; override; |
537 |
< |
*) |
537 |
> |
|
538 |
|
{ TDataSet support } |
539 |
|
procedure InternalInsert; override; |
540 |
|
procedure InitRecord(Buffer: PChar); override; |
598 |
|
protected |
599 |
|
{Likely to be made public by descendant classes} |
600 |
|
property AutoCommit: TIBAutoCommit read FAutoCommit write FAutoCommit default acDisabled; |
601 |
< |
property SQLParams: TIBXSQLDA read GetSQLParams; |
602 |
< |
property Params: TIBXSQLDA read GetSQLParams; |
601 |
> |
property SQLParams: ISQLParams read GetSQLParams; |
602 |
> |
property Params: ISQLParams read GetSQLParams; |
603 |
|
property InternalPrepared: Boolean read FInternalPrepared; |
604 |
|
property QDelete: TIBSQL read FQDelete; |
605 |
|
property QInsert: TIBSQL read FQInsert; |
606 |
|
property QRefresh: TIBSQL read FQRefresh; |
607 |
|
property QSelect: TIBSQL read FQSelect; |
608 |
|
property QModify: TIBSQL read FQModify; |
609 |
< |
property StatementType: TIBSQLTypes read GetStatementType; |
610 |
< |
property SelectStmtHandle: TISC_STMT_HANDLE read GetSelectStmtHandle; |
609 |
> |
property StatementType: TIBSQLStatementTypes read GetStatementType; |
610 |
> |
property SelectStmtHandle: IStatement read GetSelectStmtIntf; |
611 |
|
|
612 |
|
{Likely to be made published by descendant classes} |
613 |
|
property BufferChunks: Integer read FBufferChunks write SetBufferChunks; |
658 |
|
function BookmarkValid(Bookmark: TBookmark): Boolean; override; |
659 |
|
function CompareBookmarks(Bookmark1, Bookmark2: TBookmark): Integer; override; |
660 |
|
function CreateBlobStream(Field: TField; Mode: TBlobStreamMode): TStream; override; |
661 |
+ |
function GetArray(Field: TIBArrayField): IArray; |
662 |
+ |
procedure SetArrayIntf(AnArray: IArray; Field: TIBArrayField); |
663 |
|
function GetCurrentRecord(Buffer: PChar): Boolean; override; |
664 |
|
function GetFieldData(Field : TField; Buffer : Pointer) : Boolean; overload; override; |
665 |
|
function GetFieldData(FieldNo: Integer; Buffer: Pointer): Boolean; overload; (*override;*) |
673 |
|
function UpdateStatus: TUpdateStatus; override; |
674 |
|
function IsSequenced: Boolean; override; |
675 |
|
procedure Post; override; |
676 |
< |
function ParamByName(ParamName: String): TIBXSQLVAR; |
677 |
< |
property DBHandle: PISC_DB_HANDLE read GetDBHandle; |
577 |
< |
property TRHandle: PISC_TR_HANDLE read GetTRHandle; |
676 |
> |
function ParamByName(ParamName: String): ISQLParam; |
677 |
> |
property ArrayFieldCount: integer read FArrayFieldCount; |
678 |
|
property UpdateObject: TIBDataSetUpdateObject read FUpdateObject write SetUpdateObject; |
679 |
|
property UpdatesPending: Boolean read FUpdatesPending; |
680 |
|
property UpdateRecordTypes: TIBUpdateRecordTypes read FUpdateRecordTypes |
683 |
|
read FDataSetCloseAction write FDataSetCloseAction; |
684 |
|
|
685 |
|
published |
686 |
+ |
property AllowAutoActivateTransaction: Boolean read FAllowAutoActivateTransaction |
687 |
+ |
write FAllowAutoActivateTransaction; |
688 |
|
property Database: TIBDatabase read GetDatabase write SetDatabase; |
689 |
|
property Transaction: TIBTransaction read GetTransaction |
690 |
|
write SetTransaction; |
825 |
|
function Write(const Buffer; Count: Longint): Longint; override; |
826 |
|
end; |
827 |
|
|
828 |
+ |
{Extended Field Def for character set info} |
829 |
+ |
|
830 |
+ |
{ TIBFieldDef } |
831 |
+ |
|
832 |
+ |
TIBFieldDef = class(TFieldDef) |
833 |
+ |
private |
834 |
+ |
FArrayBounds: TArrayBounds; |
835 |
+ |
FArrayDimensions: integer; |
836 |
+ |
FCharacterSetName: RawByteString; |
837 |
+ |
FCharacterSetSize: integer; |
838 |
+ |
FCodePage: TSystemCodePage; |
839 |
+ |
FIdentityColumn: boolean; |
840 |
+ |
FRelationName: string; |
841 |
+ |
FDataSize: integer; |
842 |
+ |
published |
843 |
+ |
property CharacterSetName: RawByteString read FCharacterSetName write FCharacterSetName; |
844 |
+ |
property CharacterSetSize: integer read FCharacterSetSize write FCharacterSetSize; |
845 |
+ |
property CodePage: TSystemCodePage read FCodePage write FCodePage; |
846 |
+ |
property DataSize: integer read FDataSize write FDataSize; |
847 |
+ |
property RelationName: string read FRelationName write FRelationName; |
848 |
+ |
property ArrayDimensions: integer read FArrayDimensions write FArrayDimensions; |
849 |
+ |
property ArrayBounds: TArrayBounds read FArrayBounds write FArrayBounds; |
850 |
+ |
property IdentityColumn: boolean read FIdentityColumn write FIdentityColumn default false; |
851 |
+ |
end; |
852 |
+ |
|
853 |
|
const |
854 |
|
DefaultFieldClasses: array[TFieldType] of TFieldClass = ( |
855 |
|
nil, { ftUnknown } |
856 |
|
TIBStringField, { ftString } |
857 |
< |
TSmallintField, { ftSmallint } |
858 |
< |
TIntegerField, { ftInteger } |
857 |
> |
TIBSmallintField, { ftSmallint } |
858 |
> |
TIBIntegerField, { ftInteger } |
859 |
|
TWordField, { ftWord } |
860 |
|
TBooleanField, { ftBoolean } |
861 |
|
TFloatField, { ftFloat } |
877 |
|
nil, { ftCursor } |
878 |
|
TStringField, { ftFixedChar } |
879 |
|
nil, { ftWideString } |
880 |
< |
TLargeIntField, { ftLargeInt } |
880 |
> |
TIBLargeIntField, { ftLargeInt } |
881 |
|
nil, { ftADT } |
882 |
< |
nil, { ftArray } |
882 |
> |
TIBArrayField, { ftArray } |
883 |
|
nil, { ftReference } |
884 |
|
nil, { ftDataSet } |
885 |
|
TBlobField, { ftOraBlob } |
908 |
|
|
909 |
|
implementation |
910 |
|
|
911 |
< |
uses IBIntf, Variants, FmtBCD, LazUTF8, IBCodePage; |
911 |
> |
uses Variants, FmtBCD, LazUTF8, FBMessages, IBQuery; |
912 |
|
|
913 |
|
const FILE_BEGIN = 0; |
914 |
|
FILE_CURRENT = 1; |
921 |
|
FieldName : String; |
922 |
|
COMPUTED_BLR : Boolean; |
923 |
|
DEFAULT_VALUE : boolean; |
924 |
+ |
IDENTITY_COLUMN : boolean; |
925 |
|
NextField : TFieldNode; |
926 |
|
end; |
927 |
|
|
932 |
|
NextRelation : TRelationNode; |
933 |
|
end; |
934 |
|
|
807 |
– |
{Extended Field Def for character set info} |
808 |
– |
|
809 |
– |
{ TIBFieldDef } |
810 |
– |
|
811 |
– |
TIBFieldDef = class(TFieldDef) |
812 |
– |
private |
813 |
– |
FCharacterSetName: RawByteString; |
814 |
– |
FCharacterSetSize: integer; |
815 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
816 |
– |
FCodePage: TSystemCodePage; |
817 |
– |
{$ENDIF} |
818 |
– |
published |
819 |
– |
property CharacterSetName: RawByteString read FCharacterSetName write FCharacterSetName; |
820 |
– |
property CharacterSetSize: integer read FCharacterSetSize write FCharacterSetSize; |
821 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
822 |
– |
property CodePage: TSystemCodePage read FCodePage write FCodePage; |
823 |
– |
{$ENDIF} |
824 |
– |
end; |
825 |
– |
|
935 |
|
|
936 |
|
{ Copied from LCLProc in order to avoid LCL dependency |
937 |
|
|
974 |
|
Result := str; |
975 |
|
end; |
976 |
|
|
977 |
+ |
{ TIBLargeIntField } |
978 |
+ |
|
979 |
+ |
procedure TIBLargeIntField.Bind(Binding: Boolean); |
980 |
+ |
begin |
981 |
+ |
inherited Bind(Binding); |
982 |
+ |
if Binding and (FieldDef <> nil) then |
983 |
+ |
FIdentityColumn := (FieldDef as TIBFieldDef).IdentityColumn; |
984 |
+ |
end; |
985 |
+ |
|
986 |
+ |
{ TIBIntegerField } |
987 |
+ |
|
988 |
+ |
procedure TIBIntegerField.Bind(Binding: Boolean); |
989 |
+ |
begin |
990 |
+ |
inherited Bind(Binding); |
991 |
+ |
if Binding and (FieldDef <> nil) then |
992 |
+ |
FIdentityColumn := (FieldDef as TIBFieldDef).IdentityColumn; |
993 |
+ |
end; |
994 |
+ |
|
995 |
+ |
{ TIBSmallintField } |
996 |
+ |
|
997 |
+ |
procedure TIBSmallintField.Bind(Binding: Boolean); |
998 |
+ |
begin |
999 |
+ |
inherited Bind(Binding); |
1000 |
+ |
if Binding and (FieldDef <> nil) then |
1001 |
+ |
FIdentityColumn := (FieldDef as TIBFieldDef).IdentityColumn; |
1002 |
+ |
end; |
1003 |
+ |
|
1004 |
+ |
{ TIBArray } |
1005 |
+ |
|
1006 |
+ |
procedure TIBArray.EventHandler(Sender: IArray; Reason: TArrayEventReason); |
1007 |
+ |
begin |
1008 |
+ |
case Reason of |
1009 |
+ |
arChanging: |
1010 |
+ |
if FRecNo <> FField.Dataset.RecNo then |
1011 |
+ |
IBError(ibxeNotCurrentArray,[nil]); |
1012 |
+ |
|
1013 |
+ |
arChanged: |
1014 |
+ |
FField.DataChanged; |
1015 |
+ |
end; |
1016 |
+ |
end; |
1017 |
+ |
|
1018 |
+ |
constructor TIBArray.Create(aField: TIBArrayField; anArray: IArray); |
1019 |
+ |
begin |
1020 |
+ |
inherited Create; |
1021 |
+ |
FField := aField; |
1022 |
+ |
FArray := anArray; |
1023 |
+ |
FRecNo := FField.Dataset.RecNo; |
1024 |
+ |
FArray.AddEventHandler(EventHandler); |
1025 |
+ |
end; |
1026 |
+ |
|
1027 |
+ |
destructor TIBArray.Destroy; |
1028 |
+ |
begin |
1029 |
+ |
FArray.RemoveEventHandler(EventHandler); |
1030 |
+ |
inherited Destroy; |
1031 |
+ |
end; |
1032 |
+ |
|
1033 |
+ |
{ TIBArrayField } |
1034 |
+ |
|
1035 |
+ |
function TIBArrayField.GetArrayIntf: IArray; |
1036 |
+ |
begin |
1037 |
+ |
Result := TIBCustomDataSet(DataSet).GetArray(self); |
1038 |
+ |
end; |
1039 |
+ |
|
1040 |
+ |
function TIBArrayField.GetArrayID: TISC_QUAD; |
1041 |
+ |
begin |
1042 |
+ |
GetData(@Result); |
1043 |
+ |
end; |
1044 |
+ |
|
1045 |
+ |
procedure TIBArrayField.SetArrayIntf(AValue: IArray); |
1046 |
+ |
begin |
1047 |
+ |
TIBCustomDataSet(DataSet).SetArrayIntf(AValue,self); |
1048 |
+ |
DataChanged; |
1049 |
+ |
end; |
1050 |
+ |
|
1051 |
+ |
class procedure TIBArrayField.CheckTypeSize(AValue: Longint); |
1052 |
+ |
begin |
1053 |
+ |
//Ignore |
1054 |
+ |
end; |
1055 |
+ |
|
1056 |
+ |
function TIBArrayField.GetAsString: string; |
1057 |
+ |
begin |
1058 |
+ |
Result := '(Array)'; |
1059 |
+ |
end; |
1060 |
+ |
|
1061 |
+ |
function TIBArrayField.GetDataSize: Integer; |
1062 |
+ |
begin |
1063 |
+ |
Result := sizeof(TISC_QUAD); |
1064 |
+ |
end; |
1065 |
+ |
|
1066 |
+ |
procedure TIBArrayField.Bind(Binding: Boolean); |
1067 |
+ |
begin |
1068 |
+ |
inherited Bind(Binding); |
1069 |
+ |
if Binding then |
1070 |
+ |
begin |
1071 |
+ |
FCacheOffset := TIBCustomDataSet(DataSet).ArrayFieldCount; |
1072 |
+ |
Inc(TIBCustomDataSet(DataSet).FArrayFieldCount); |
1073 |
+ |
if FieldDef <> nil then |
1074 |
+ |
begin |
1075 |
+ |
FRelationName := TIBFieldDef(FieldDef).FRelationName; |
1076 |
+ |
FArrayDimensions := TIBFieldDef(FieldDef).ArrayDimensions; |
1077 |
+ |
FArrayBounds := TIBFieldDef(FieldDef).ArrayBounds; |
1078 |
+ |
end; |
1079 |
+ |
end; |
1080 |
+ |
end; |
1081 |
+ |
|
1082 |
+ |
constructor TIBArrayField.Create(AOwner: TComponent); |
1083 |
+ |
begin |
1084 |
+ |
inherited Create(AOwner); |
1085 |
+ |
SetDataType(ftArray); |
1086 |
+ |
end; |
1087 |
+ |
|
1088 |
+ |
function TIBArrayField.CreateArray: IArray; |
1089 |
+ |
begin |
1090 |
+ |
with DataSet as TIBCustomDataSet do |
1091 |
+ |
Result := Database.Attachment.CreateArray(Transaction.TransactionIntf,FRelationName,FieldName); |
1092 |
+ |
end; |
1093 |
+ |
|
1094 |
|
{ TIBMemoField } |
1095 |
|
|
1096 |
|
function TIBMemoField.GetTruncatedText: string; |
1110 |
|
{2: case 2 ignored. This should be handled by TIBWideMemo} |
1111 |
|
|
1112 |
|
3, {Assume UNICODE_FSS is really UTF8} |
1113 |
< |
4: {Include GB18030 - assuming UTF8 routine work for this codeset} |
1113 |
> |
4: {Include GB18030 - assuming UTF8 routines work for this codeset} |
1114 |
|
if DisplayWidth = 0 then |
1115 |
|
Result := ValidUTF8String(TextToSingleLine(Result)) |
1116 |
|
else |
1120 |
|
end |
1121 |
|
end; |
1122 |
|
|
1123 |
+ |
procedure TIBMemoField.Bind(Binding: Boolean); |
1124 |
+ |
var IBFieldDef: TIBFieldDef; |
1125 |
+ |
begin |
1126 |
+ |
inherited Bind(Binding); |
1127 |
+ |
if Binding and (FieldDef <> nil) then |
1128 |
+ |
begin |
1129 |
+ |
IBFieldDef := FieldDef as TIBFieldDef; |
1130 |
+ |
CharacterSetSize := IBFieldDef.CharacterSetSize; |
1131 |
+ |
CharacterSetName := IBFieldDef.CharacterSetName; |
1132 |
+ |
CodePage := IBFieldDef.CodePage; |
1133 |
+ |
end; |
1134 |
+ |
end; |
1135 |
+ |
|
1136 |
|
function TIBMemoField.GetAsString: string; |
1137 |
|
var s: RawByteString; |
1138 |
|
begin |
1139 |
|
s := inherited GetAsString; |
901 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
1140 |
|
SetCodePage(s,CodePage,false); |
1141 |
|
if (CodePage <> CP_NONE) and (CodePage <> CP_UTF8) then |
1142 |
|
SetCodePage(s,CP_UTF8,true); {LCL only accepts UTF8} |
905 |
– |
{$ENDIF} |
1143 |
|
Result := s; |
1144 |
|
end; |
1145 |
|
|
1168 |
|
var s: RawByteString; |
1169 |
|
begin |
1170 |
|
s := AValue; |
1171 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
935 |
< |
if StringCodePage(Value) <> CodePage then |
1171 |
> |
if StringCodePage(s) <> CodePage then |
1172 |
|
SetCodePage(s,CodePage,CodePage<>CP_NONE); |
937 |
– |
{$ENDIF} |
1173 |
|
inherited SetAsString(s); |
1174 |
|
end; |
1175 |
|
|
1177 |
|
begin |
1178 |
|
inherited Create(AOwner); |
1179 |
|
BlobType := ftMemo; |
945 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
1180 |
|
FCodePage := CP_NONE; |
947 |
– |
{$ENDIF} |
1181 |
|
end; |
1182 |
|
|
1183 |
|
{ TIBControlLink } |
1211 |
|
|
1212 |
|
{ TIBStringField} |
1213 |
|
|
1214 |
< |
function TIBStringField.GetDefaultWidth: Longint; |
1214 |
> |
procedure TIBStringField.Bind(Binding: Boolean); |
1215 |
> |
var IBFieldDef: TIBFieldDef; |
1216 |
|
begin |
1217 |
< |
Result := Size div CharacterSetSize; |
1217 |
> |
inherited Bind(Binding); |
1218 |
> |
if Binding and (FieldDef <> nil) then |
1219 |
> |
begin |
1220 |
> |
IBFieldDef := FieldDef as TIBFieldDef; |
1221 |
> |
CharacterSetSize := IBFieldDef.CharacterSetSize; |
1222 |
> |
CharacterSetName := IBFieldDef.CharacterSetName; |
1223 |
> |
FDataSize := IBFieldDef.DataSize + 1; |
1224 |
> |
if AutoFieldSize then |
1225 |
> |
Size := IBFieldDef.Size; |
1226 |
> |
CodePage := IBFieldDef.CodePage; |
1227 |
> |
end; |
1228 |
> |
end; |
1229 |
> |
|
1230 |
> |
function TIBStringField.GetDataSize: Integer; |
1231 |
> |
begin |
1232 |
> |
Result := FDataSize; |
1233 |
|
end; |
1234 |
|
|
1235 |
|
constructor TIBStringField.Create(aOwner: TComponent); |
1236 |
|
begin |
1237 |
|
inherited Create(aOwner); |
1238 |
|
FCharacterSetSize := 1; |
990 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
1239 |
|
FCodePage := CP_NONE; |
1240 |
< |
{$ENDIF} |
1240 |
> |
FAutoFieldSize := true; |
1241 |
|
end; |
1242 |
|
|
1243 |
|
class procedure TIBStringField.CheckTypeSize(Value: Integer); |
1261 |
|
var |
1262 |
|
Buffer: PChar; |
1263 |
|
s: RawByteString; |
1016 |
– |
// i: integer; |
1264 |
|
begin |
1265 |
|
Buffer := nil; |
1266 |
< |
IBAlloc(Buffer, 0, Size + 1); |
1266 |
> |
IBAlloc(Buffer, 0, DataSize); |
1267 |
|
try |
1268 |
|
Result := GetData(Buffer); |
1269 |
|
if Result then |
1270 |
|
begin |
1271 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
1025 |
< |
s := string(Buffer); |
1271 |
> |
s := strpas(Buffer); |
1272 |
|
SetCodePage(s,CodePage,false); |
1273 |
|
if (CodePage <> CP_NONE) and (CodePage <> CP_UTF8) then |
1274 |
|
SetCodePage(s,CP_UTF8,true); {LCL only accepts UTF8} |
1275 |
|
Value := s; |
1276 |
< |
(* write(FieldName,': ', StringCodePage(Value),', ',Value,' '); |
1031 |
< |
for i := 1 to Length(Value) do |
1032 |
< |
write(Format('%x ',[byte(Value[i])])); |
1033 |
< |
writeln;*) |
1034 |
< |
{$ELSE} |
1035 |
< |
Value := string(Buffer); |
1036 |
< |
{$ENDIF} |
1276 |
> |
// writeln(FieldName,': ', StringCodePage(Value),', ',Value); |
1277 |
|
if Transliterate and (Value <> '') then |
1278 |
|
DataSet.Translate(PChar(Value), PChar(Value), False); |
1279 |
|
end |
1288 |
|
s: RawByteString; |
1289 |
|
begin |
1290 |
|
Buffer := nil; |
1291 |
< |
IBAlloc(Buffer, 0, Size + 1); |
1291 |
> |
IBAlloc(Buffer, 0, DataSize); |
1292 |
|
try |
1293 |
|
s := Value; |
1054 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
1294 |
|
if StringCodePage(s) <> CodePage then |
1295 |
|
SetCodePage(s,CodePage,CodePage<>CP_NONE); |
1296 |
< |
{$ENDIF} |
1058 |
< |
StrLCopy(Buffer, PChar(s), Size); |
1296 |
> |
StrLCopy(Buffer, PChar(s), DataSize-1); |
1297 |
|
if Transliterate then |
1298 |
|
DataSet.Translate(Buffer, Buffer, True); |
1299 |
|
SetData(Buffer); |
1312 |
|
Size := 8; |
1313 |
|
end; |
1314 |
|
|
1315 |
+ |
procedure TIBBCDField.Bind(Binding: Boolean); |
1316 |
+ |
begin |
1317 |
+ |
inherited Bind(Binding); |
1318 |
+ |
if Binding and (FieldDef <> nil) then |
1319 |
+ |
FIdentityColumn := (FieldDef as TIBFieldDef).IdentityColumn; |
1320 |
+ |
end; |
1321 |
+ |
|
1322 |
|
class procedure TIBBCDField.CheckTypeSize(Value: Integer); |
1323 |
|
begin |
1324 |
|
{ No need to check as the base type is currency, not BCD } |
1403 |
|
constructor TIBCustomDataSet.Create(AOwner: TComponent); |
1404 |
|
begin |
1405 |
|
inherited Create(AOwner); |
1161 |
– |
FIBLoaded := False; |
1162 |
– |
CheckIBLoaded; |
1163 |
– |
FIBLoaded := True; |
1406 |
|
FBase := TIBBase.Create(Self); |
1407 |
+ |
FDatabaseInfo := TIBDatabaseInfo.Create(self); |
1408 |
|
FIBLinks := TList.Create; |
1409 |
|
FCurrentRecord := -1; |
1410 |
|
FDeletedRecords := 0; |
1411 |
|
FUniDirectional := False; |
1412 |
|
FBufferChunks := BufferCacheSize; |
1413 |
|
FBlobStreamList := TList.Create; |
1414 |
+ |
FArrayList := TList.Create; |
1415 |
|
FGeneratorField := TIBGenerator.Create(self); |
1416 |
|
FDataLink := TIBDataLink.Create(Self); |
1417 |
|
FQDelete := TIBSQL.Create(Self); |
1455 |
|
destructor TIBCustomDataSet.Destroy; |
1456 |
|
begin |
1457 |
|
if Active then Active := false; |
1458 |
< |
if FIBLoaded then |
1459 |
< |
begin |
1460 |
< |
if assigned(FGeneratorField) then FGeneratorField.Free; |
1461 |
< |
FDataLink.Free; |
1462 |
< |
FBase.Free; |
1463 |
< |
ClearBlobCache; |
1464 |
< |
ClearIBLinks; |
1465 |
< |
FIBLinks.Free; |
1466 |
< |
FBlobStreamList.Free; |
1467 |
< |
FreeMem(FBufferCache); |
1468 |
< |
FBufferCache := nil; |
1469 |
< |
FreeMem(FOldBufferCache); |
1470 |
< |
FOldBufferCache := nil; |
1471 |
< |
FCacheSize := 0; |
1472 |
< |
FOldCacheSize := 0; |
1229 |
< |
FMappedFieldPosition := nil; |
1230 |
< |
end; |
1458 |
> |
if assigned(FGeneratorField) then FGeneratorField.Free; |
1459 |
> |
FDataLink.Free; |
1460 |
> |
FBase.Free; |
1461 |
> |
ClearBlobCache; |
1462 |
> |
ClearIBLinks; |
1463 |
> |
FIBLinks.Free; |
1464 |
> |
FBlobStreamList.Free; |
1465 |
> |
FArrayList.Free; |
1466 |
> |
FreeMem(FBufferCache); |
1467 |
> |
FBufferCache := nil; |
1468 |
> |
FreeMem(FOldBufferCache); |
1469 |
> |
FOldBufferCache := nil; |
1470 |
> |
FCacheSize := 0; |
1471 |
> |
FOldCacheSize := 0; |
1472 |
> |
FMappedFieldPosition := nil; |
1473 |
|
if assigned(FBaseSQLSelect) then FBaseSQLSelect.Free; |
1474 |
|
if assigned(FParser) then FParser.Free; |
1475 |
|
inherited Destroy; |
1494 |
|
Inc(FCurrentRecord); |
1495 |
|
if (FCurrentRecord = FRecordCount) then |
1496 |
|
begin |
1497 |
< |
if (not FQSelect.EOF) and (FQSelect.Next <> nil) then |
1497 |
> |
if (not FQSelect.EOF) and FQSelect.Next then |
1498 |
|
begin |
1499 |
|
FetchCurrentRecordToBuffer(FQSelect, FCurrentRecord, Buffer); |
1500 |
|
Inc(FRecordCount); |
1513 |
|
|
1514 |
|
procedure TIBCustomDataSet.ApplyUpdates; |
1515 |
|
var |
1274 |
– |
{$IFDEF NEW_TBOOKMARK } |
1516 |
|
CurBookmark: TBookmark; |
1276 |
– |
{$ELSE} |
1277 |
– |
CurBookmark: string; |
1278 |
– |
{$ENDIF} |
1517 |
|
Buffer: PRecordData; |
1518 |
|
CurUpdateTypes: TIBUpdateRecordTypes; |
1519 |
|
UpdateAction: TIBUpdateAction; |
1744 |
|
function TIBCustomDataSet.ActivateTransaction: Boolean; |
1745 |
|
begin |
1746 |
|
Result := False; |
1747 |
< |
if not Assigned(Transaction) then |
1510 |
< |
IBError(ibxeTransactionNotAssigned, [nil]); |
1511 |
< |
if not Transaction.Active then |
1747 |
> |
if AllowAutoActivateTransaction or (csDesigning in ComponentState) then |
1748 |
|
begin |
1749 |
< |
Result := True; |
1750 |
< |
Transaction.StartTransaction; |
1751 |
< |
FDidActivate := True; |
1749 |
> |
if not Assigned(Transaction) then |
1750 |
> |
IBError(ibxeTransactionNotAssigned, [nil]); |
1751 |
> |
if not Transaction.Active then |
1752 |
> |
begin |
1753 |
> |
Result := True; |
1754 |
> |
Transaction.StartTransaction; |
1755 |
> |
FDidActivate := True; |
1756 |
> |
end; |
1757 |
|
end; |
1758 |
|
end; |
1759 |
|
|
1878 |
|
FBlobStreamList.Pack; |
1879 |
|
end; |
1880 |
|
|
1881 |
+ |
procedure TIBCustomDataSet.ClearArrayCache; |
1882 |
+ |
var |
1883 |
+ |
i: Integer; |
1884 |
+ |
begin |
1885 |
+ |
for i := 0 to FArrayList.Count - 1 do |
1886 |
+ |
begin |
1887 |
+ |
TIBArray(FArrayList[i]).Free; |
1888 |
+ |
FArrayList[i] := nil; |
1889 |
+ |
end; |
1890 |
+ |
FArrayList.Pack; |
1891 |
+ |
end; |
1892 |
+ |
|
1893 |
|
procedure TIBCustomDataSet.CopyRecordBuffer(Source, Dest: Pointer); |
1894 |
|
begin |
1895 |
|
Move(Source^, Dest^, FRecordBufferSize); |
1899 |
|
begin |
1900 |
|
if Active then |
1901 |
|
Active := False; |
1902 |
< |
FInternalPrepared := False; |
1902 |
> |
InternalUnPrepare; |
1903 |
|
if Assigned(FBeforeDatabaseDisconnect) then |
1904 |
|
FBeforeDatabaseDisconnect(Sender); |
1905 |
|
end; |
1937 |
|
FQModify.FreeHandle; |
1938 |
|
if FQRefresh <> nil then |
1939 |
|
FQRefresh.FreeHandle; |
1940 |
+ |
InternalUnPrepare; |
1941 |
|
if Assigned(FBeforeTransactionEnd) then |
1942 |
|
FBeforeTransactionEnd(Sender); |
1943 |
|
end; |
1954 |
|
FTransactionFree(Sender); |
1955 |
|
end; |
1956 |
|
|
1957 |
< |
{ Read the record from FQSelect.Current into the record buffer |
1958 |
< |
Then write the buffer to in memory cache } |
1959 |
< |
procedure TIBCustomDataSet.FetchCurrentRecordToBuffer(Qry: TIBSQL; |
1960 |
< |
RecordNumber: Integer; Buffer: PChar); |
1961 |
< |
var |
1708 |
< |
p: PRecordData; |
1709 |
< |
pbd: PBlobDataArray; |
1710 |
< |
i, j: Integer; |
1711 |
< |
LocalData: Pointer; |
1712 |
< |
LocalDate, LocalDouble: Double; |
1713 |
< |
LocalInt: Integer; |
1714 |
< |
LocalBool: wordBool; |
1715 |
< |
LocalInt64: Int64; |
1716 |
< |
LocalCurrency: Currency; |
1717 |
< |
FieldsLoaded: Integer; |
1957 |
> |
procedure TIBCustomDataSet.InitModelBuffer(Qry: TIBSQL; Buffer: PChar); |
1958 |
> |
var i, j: Integer; |
1959 |
> |
FieldsLoaded: integer; |
1960 |
> |
p: PRecordData; |
1961 |
> |
colMetadata: IColumnMetaData; |
1962 |
|
begin |
1963 |
|
p := PRecordData(Buffer); |
1720 |
– |
{ Make sure blob cache is empty } |
1721 |
– |
pbd := PBlobDataArray(Buffer + FBlobCacheOffset); |
1722 |
– |
if RecordNumber > -1 then |
1723 |
– |
for i := 0 to BlobFieldCount - 1 do |
1724 |
– |
pbd^[i] := nil; |
1964 |
|
{ Get record information } |
1965 |
|
p^.rdBookmarkFlag := bfCurrent; |
1966 |
< |
p^.rdFieldCount := Qry.Current.Count; |
1967 |
< |
p^.rdRecordNumber := RecordNumber; |
1966 |
> |
p^.rdFieldCount := Qry.FieldCount; |
1967 |
> |
p^.rdRecordNumber := -1; |
1968 |
|
p^.rdUpdateStatus := usUnmodified; |
1969 |
|
p^.rdCachedUpdateStatus := cusUnmodified; |
1970 |
|
p^.rdSavedOffset := $FFFFFFFF; |
1971 |
|
|
1972 |
|
{ Load up the fields } |
1973 |
< |
FieldsLoaded := FQSelect.Current.Count; |
1973 |
> |
FieldsLoaded := FQSelect.MetaData.Count; |
1974 |
|
j := 1; |
1975 |
< |
for i := 0 to Qry.Current.Count - 1 do |
1975 |
> |
for i := 0 to Qry.MetaData.Count - 1 do |
1976 |
|
begin |
1977 |
|
if (Qry = FQSelect) then |
1978 |
|
j := i + 1 |
1979 |
< |
else begin |
1979 |
> |
else |
1980 |
> |
begin |
1981 |
|
if FieldsLoaded = 0 then |
1982 |
|
break; |
1983 |
< |
j := FQSelect.FieldIndex[Qry.Current[i].Name] + 1; |
1983 |
> |
j := FQSelect.FieldIndex[Qry[i].Name] + 1; |
1984 |
|
if j < 1 then |
1985 |
|
continue |
1986 |
|
else |
1987 |
|
Dec(FieldsLoaded); |
1988 |
|
end; |
1989 |
< |
with FQSelect.Current[j - 1].Data^ do |
1990 |
< |
if aliasname = 'IBX_INTERNAL_DBKEY' then {do not localize} |
1989 |
> |
if j > 0 then |
1990 |
> |
begin |
1991 |
> |
colMetadata := Qry.MetaData[i]; |
1992 |
> |
with p^.rdFields[j], FFieldColumns^[j] do |
1993 |
|
begin |
1994 |
< |
if sqllen <= 8 then |
1995 |
< |
p^.rdDBKey := PIBDBKEY(Qry.Current[i].AsPointer)^; |
1996 |
< |
continue; |
1994 |
> |
fdDataType := colMetadata.GetSQLType; |
1995 |
> |
if fdDataType = SQL_BLOB then |
1996 |
> |
fdDataScale := 0 |
1997 |
> |
else |
1998 |
> |
fdDataScale := colMetadata.getScale; |
1999 |
> |
fdNullable := colMetadata.getIsNullable; |
2000 |
> |
fdIsNull := true; |
2001 |
> |
fdDataSize := colMetadata.GetSize; |
2002 |
> |
fdDataLength := 0; |
2003 |
> |
fdCodePage := CP_NONE; |
2004 |
> |
|
2005 |
> |
case fdDataType of |
2006 |
> |
SQL_TIMESTAMP, |
2007 |
> |
SQL_TYPE_DATE, |
2008 |
> |
SQL_TYPE_TIME: |
2009 |
> |
fdDataSize := SizeOf(TDateTime); |
2010 |
> |
SQL_SHORT, SQL_LONG: |
2011 |
> |
begin |
2012 |
> |
if (fdDataScale = 0) then |
2013 |
> |
fdDataSize := SizeOf(Integer) |
2014 |
> |
else |
2015 |
> |
if (fdDataScale >= (-4)) then |
2016 |
> |
fdDataSize := SizeOf(Currency) |
2017 |
> |
else |
2018 |
> |
fdDataSize := SizeOf(Double); |
2019 |
> |
end; |
2020 |
> |
SQL_INT64: |
2021 |
> |
begin |
2022 |
> |
if (fdDataScale = 0) then |
2023 |
> |
fdDataSize := SizeOf(Int64) |
2024 |
> |
else |
2025 |
> |
if (fdDataScale >= (-4)) then |
2026 |
> |
fdDataSize := SizeOf(Currency) |
2027 |
> |
else |
2028 |
> |
fdDataSize := SizeOf(Double); |
2029 |
> |
end; |
2030 |
> |
SQL_DOUBLE, SQL_FLOAT, SQL_D_FLOAT: |
2031 |
> |
fdDataSize := SizeOf(Double); |
2032 |
> |
SQL_BOOLEAN: |
2033 |
> |
fdDataSize := SizeOf(wordBool); |
2034 |
> |
SQL_VARYING, |
2035 |
> |
SQL_TEXT, |
2036 |
> |
SQL_BLOB: |
2037 |
> |
fdCodePage := Qry.Metadata[i].getCodePage; |
2038 |
> |
end; |
2039 |
> |
fdDataOfs := FRecordSize; |
2040 |
> |
Inc(FRecordSize, fdDataSize); |
2041 |
|
end; |
2042 |
< |
if j > 0 then with p^ do |
2042 |
> |
end; |
2043 |
> |
end; |
2044 |
> |
end; |
2045 |
> |
|
2046 |
> |
{Update Buffer Fields from Query Results} |
2047 |
> |
|
2048 |
> |
procedure TIBCustomDataSet.UpdateRecordFromQuery(QryResults: IResults; |
2049 |
> |
Buffer: PChar); |
2050 |
> |
var i, j: integer; |
2051 |
> |
begin |
2052 |
> |
for i := 0 to QryResults.Count - 1 do |
2053 |
> |
begin |
2054 |
> |
j := GetFieldPosition(QryResults[i].GetAliasName); |
2055 |
> |
if j > 0 then |
2056 |
> |
ColumnDataToBuffer(QryResults,i,j,Buffer); |
2057 |
> |
end; |
2058 |
> |
end; |
2059 |
> |
|
2060 |
> |
|
2061 |
> |
{Move column data returned from query to row buffer} |
2062 |
> |
|
2063 |
> |
procedure TIBCustomDataSet.ColumnDataToBuffer(QryResults: IResults; |
2064 |
> |
ColumnIndex, FieldIndex: integer; Buffer: PChar); |
2065 |
> |
var |
2066 |
> |
LocalData: PByte; |
2067 |
> |
LocalDate, LocalDouble: Double; |
2068 |
> |
LocalInt: Integer; |
2069 |
> |
LocalBool: wordBool; |
2070 |
> |
LocalInt64: Int64; |
2071 |
> |
LocalCurrency: Currency; |
2072 |
> |
p: PRecordData; |
2073 |
> |
ColData: ISQLData; |
2074 |
> |
begin |
2075 |
> |
p := PRecordData(Buffer); |
2076 |
> |
LocalData := nil; |
2077 |
> |
with p^.rdFields[FieldIndex], FFieldColumns^[FieldIndex] do |
2078 |
> |
begin |
2079 |
> |
QryResults.GetData(ColumnIndex,fdIsNull,fdDataLength,LocalData); |
2080 |
> |
if not fdIsNull then |
2081 |
|
begin |
2082 |
< |
rdFields[j].fdDataType := |
2083 |
< |
Qry.Current[i].Data^.sqltype and (not 1); |
1760 |
< |
rdFields[j].fdDataScale := |
1761 |
< |
Qry.Current[i].Data^.sqlscale; |
1762 |
< |
rdFields[j].fdNullable := |
1763 |
< |
(Qry.Current[i].Data^.sqltype and 1 = 1); |
1764 |
< |
rdFields[j].fdIsNull := |
1765 |
< |
(rdFields[j].fdNullable and (Qry.Current[i].Data^.sqlind^ = -1)); |
1766 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
1767 |
< |
rdFields[j].fdCodePage := 0; |
1768 |
< |
{$ENDIF} |
1769 |
< |
LocalData := Qry.Current[i].Data^.sqldata; |
1770 |
< |
case rdFields[j].fdDataType of |
2082 |
> |
ColData := QryResults[ColumnIndex]; |
2083 |
> |
case fdDataType of {Get Formatted data for column types that need formatting} |
2084 |
|
SQL_TIMESTAMP: |
2085 |
|
begin |
2086 |
< |
rdFields[j].fdDataSize := SizeOf(TDateTime); |
2087 |
< |
if RecordNumber >= 0 then |
1775 |
< |
LocalDate := TimeStampToMSecs(DateTimeToTimeStamp(Qry.Current[i].AsDateTime)); |
1776 |
< |
LocalData := PChar(@LocalDate); |
2086 |
> |
LocalDate := TimeStampToMSecs(DateTimeToTimeStamp(ColData.AsDateTime)); |
2087 |
> |
LocalData := PByte(@LocalDate); |
2088 |
|
end; |
2089 |
|
SQL_TYPE_DATE: |
2090 |
|
begin |
2091 |
< |
rdFields[j].fdDataSize := SizeOf(TDateTime); |
2092 |
< |
if RecordNumber >= 0 then |
1782 |
< |
LocalInt := DateTimeToTimeStamp(Qry.Current[i].AsDateTime).Date; |
1783 |
< |
LocalData := PChar(@LocalInt); |
2091 |
> |
LocalInt := DateTimeToTimeStamp(ColData.AsDateTime).Date; |
2092 |
> |
LocalData := PByte(@LocalInt); |
2093 |
|
end; |
2094 |
|
SQL_TYPE_TIME: |
2095 |
|
begin |
2096 |
< |
rdFields[j].fdDataSize := SizeOf(TDateTime); |
2097 |
< |
if RecordNumber >= 0 then |
1789 |
< |
LocalInt := DateTimeToTimeStamp(Qry.Current[i].AsDateTime).Time; |
1790 |
< |
LocalData := PChar(@LocalInt); |
2096 |
> |
LocalInt := DateTimeToTimeStamp(ColData.AsDateTime).Time; |
2097 |
> |
LocalData := PByte(@LocalInt); |
2098 |
|
end; |
2099 |
|
SQL_SHORT, SQL_LONG: |
2100 |
|
begin |
2101 |
< |
if (rdFields[j].fdDataScale = 0) then |
2101 |
> |
if (fdDataScale = 0) then |
2102 |
|
begin |
2103 |
< |
rdFields[j].fdDataSize := SizeOf(Integer); |
2104 |
< |
if RecordNumber >= 0 then |
1798 |
< |
LocalInt := Qry.Current[i].AsLong; |
1799 |
< |
LocalData := PChar(@LocalInt); |
2103 |
> |
LocalInt := ColData.AsLong; |
2104 |
> |
LocalData := PByte(@LocalInt); |
2105 |
|
end |
2106 |
< |
else if (rdFields[j].fdDataScale >= (-4)) then |
2107 |
< |
begin |
2108 |
< |
rdFields[j].fdDataSize := SizeOf(Currency); |
2109 |
< |
if RecordNumber >= 0 then |
2110 |
< |
LocalCurrency := Qry.Current[i].AsCurrency; |
2111 |
< |
LocalData := PChar(@LocalCurrency); |
2112 |
< |
end |
2113 |
< |
else begin |
2114 |
< |
rdFields[j].fdDataSize := SizeOf(Double); |
2115 |
< |
if RecordNumber >= 0 then |
2116 |
< |
LocalDouble := Qry.Current[i].AsDouble; |
1812 |
< |
LocalData := PChar(@LocalDouble); |
1813 |
< |
end; |
2106 |
> |
else |
2107 |
> |
if (fdDataScale >= (-4)) then |
2108 |
> |
begin |
2109 |
> |
LocalCurrency := ColData.AsCurrency; |
2110 |
> |
LocalData := PByte(@LocalCurrency); |
2111 |
> |
end |
2112 |
> |
else |
2113 |
> |
begin |
2114 |
> |
LocalDouble := ColData.AsDouble; |
2115 |
> |
LocalData := PByte(@LocalDouble); |
2116 |
> |
end; |
2117 |
|
end; |
2118 |
|
SQL_INT64: |
2119 |
|
begin |
2120 |
< |
if (rdFields[j].fdDataScale = 0) then |
2120 |
> |
if (fdDataScale = 0) then |
2121 |
|
begin |
2122 |
< |
rdFields[j].fdDataSize := SizeOf(Int64); |
2123 |
< |
if RecordNumber >= 0 then |
1821 |
< |
LocalInt64 := Qry.Current[i].AsInt64; |
1822 |
< |
LocalData := PChar(@LocalInt64); |
2122 |
> |
LocalInt64 := ColData.AsInt64; |
2123 |
> |
LocalData := PByte(@LocalInt64); |
2124 |
|
end |
2125 |
< |
else if (rdFields[j].fdDataScale >= (-4)) then |
2126 |
< |
begin |
1826 |
< |
rdFields[j].fdDataSize := SizeOf(Currency); |
1827 |
< |
if RecordNumber >= 0 then |
1828 |
< |
LocalCurrency := Qry.Current[i].AsCurrency; |
1829 |
< |
LocalData := PChar(@LocalCurrency); |
1830 |
< |
end |
1831 |
< |
else begin |
1832 |
< |
rdFields[j].fdDataSize := SizeOf(Double); |
1833 |
< |
if RecordNumber >= 0 then |
1834 |
< |
LocalDouble := Qry.Current[i].AsDouble; |
1835 |
< |
LocalData := PChar(@LocalDouble); |
1836 |
< |
end |
1837 |
< |
end; |
1838 |
< |
SQL_DOUBLE, SQL_FLOAT, SQL_D_FLOAT: |
1839 |
< |
begin |
1840 |
< |
rdFields[j].fdDataSize := SizeOf(Double); |
1841 |
< |
if RecordNumber >= 0 then |
1842 |
< |
LocalDouble := Qry.Current[i].AsDouble; |
1843 |
< |
LocalData := PChar(@LocalDouble); |
1844 |
< |
end; |
1845 |
< |
SQL_VARYING: |
1846 |
< |
begin |
1847 |
< |
rdFields[j].fdDataSize := Qry.Current[i].Data^.sqllen; |
1848 |
< |
rdFields[j].fdDataLength := isc_vax_integer(Qry.Current[i].Data^.sqldata, 2); |
1849 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
1850 |
< |
TFirebirdCharacterSets.CharSetID2CodePage(Qry.Current[i].Data^.sqlsubtype and $FF, |
1851 |
< |
rdFields[j].fdCodePage); |
1852 |
< |
{$ENDIF} |
1853 |
< |
if RecordNumber >= 0 then |
2125 |
> |
else |
2126 |
> |
if (fdDataScale >= (-4)) then |
2127 |
|
begin |
2128 |
< |
if (rdFields[j].fdDataLength = 0) then |
2129 |
< |
LocalData := nil |
2128 |
> |
LocalCurrency := ColData.AsCurrency; |
2129 |
> |
LocalData := PByte(@LocalCurrency); |
2130 |
> |
end |
2131 |
|
else |
2132 |
< |
Inc(LocalData,2); |
2133 |
< |
end; |
2132 |
> |
begin |
2133 |
> |
LocalDouble := ColData.AsDouble; |
2134 |
> |
LocalData := PByte(@LocalDouble); |
2135 |
> |
end |
2136 |
|
end; |
2137 |
< |
SQL_BOOLEAN: |
2137 |
> |
SQL_DOUBLE, SQL_FLOAT, SQL_D_FLOAT: |
2138 |
|
begin |
2139 |
< |
LocalBool:= false; |
2140 |
< |
rdFields[j].fdDataSize := SizeOf(wordBool); |
1865 |
< |
if RecordNumber >= 0 then |
1866 |
< |
LocalBool := Qry.Current[i].AsBoolean; |
1867 |
< |
LocalData := PChar(@LocalBool); |
2139 |
> |
LocalDouble := ColData.AsDouble; |
2140 |
> |
LocalData := PByte(@LocalDouble); |
2141 |
|
end; |
2142 |
< |
SQL_TEXT: |
1870 |
< |
begin |
1871 |
< |
rdFields[j].fdDataSize := Qry.Current[i].Data^.sqllen; |
1872 |
< |
rdFields[j].fdDataLength := rdFields[j].fdDataSize; |
1873 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
1874 |
< |
TFirebirdCharacterSets.CharSetID2CodePage(Qry.Current[i].Data^.sqlsubtype and $FF, |
1875 |
< |
rdFields[j].fdCodePage); |
1876 |
< |
{$ENDIF} |
1877 |
< |
end; |
1878 |
< |
else { SQL_BLOB, SQL_ARRAY, SQL_QUAD } |
2142 |
> |
SQL_BOOLEAN: |
2143 |
|
begin |
2144 |
< |
rdFields[j].fdDataSize := Qry.Current[i].Data^.sqllen; |
2144 |
> |
LocalBool := ColData.AsBoolean; |
2145 |
> |
LocalData := PByte(@LocalBool); |
2146 |
|
end; |
2147 |
|
end; |
2148 |
< |
if RecordNumber < 0 then |
2148 |
> |
|
2149 |
> |
if fdDataType = SQL_VARYING then |
2150 |
> |
Move(LocalData^, Buffer[fdDataOfs], fdDataLength) |
2151 |
> |
else |
2152 |
> |
Move(LocalData^, Buffer[fdDataOfs], fdDataSize) |
2153 |
> |
end |
2154 |
> |
else {Null column} |
2155 |
> |
if fdDataType = SQL_VARYING then |
2156 |
> |
FillChar(Buffer[fdDataOfs],fdDataLength,0) |
2157 |
> |
else |
2158 |
> |
FillChar(Buffer[fdDataOfs],fdDataSize,0); |
2159 |
> |
end; |
2160 |
> |
end; |
2161 |
> |
|
2162 |
> |
{ Read the record from FQSelect.Current into the record buffer |
2163 |
> |
Then write the buffer to in memory cache } |
2164 |
> |
procedure TIBCustomDataSet.FetchCurrentRecordToBuffer(Qry: TIBSQL; |
2165 |
> |
RecordNumber: Integer; Buffer: PChar); |
2166 |
> |
var |
2167 |
> |
pbd: PBlobDataArray; |
2168 |
> |
pda: PArrayDataArray; |
2169 |
> |
i, j: Integer; |
2170 |
> |
FieldsLoaded: Integer; |
2171 |
> |
p: PRecordData; |
2172 |
> |
begin |
2173 |
> |
if RecordNumber = -1 then |
2174 |
> |
begin |
2175 |
> |
InitModelBuffer(Qry,Buffer); |
2176 |
> |
Exit; |
2177 |
> |
end; |
2178 |
> |
p := PRecordData(Buffer); |
2179 |
> |
{ Make sure blob cache is empty } |
2180 |
> |
pbd := PBlobDataArray(Buffer + FBlobCacheOffset); |
2181 |
> |
pda := PArrayDataArray(Buffer + FArrayCacheOffset); |
2182 |
> |
for i := 0 to BlobFieldCount - 1 do |
2183 |
> |
pbd^[i] := nil; |
2184 |
> |
for i := 0 to ArrayFieldCount - 1 do |
2185 |
> |
pda^[i] := nil; |
2186 |
> |
|
2187 |
> |
{ Get record information } |
2188 |
> |
p^.rdBookmarkFlag := bfCurrent; |
2189 |
> |
p^.rdFieldCount := Qry.FieldCount; |
2190 |
> |
p^.rdRecordNumber := RecordNumber; |
2191 |
> |
p^.rdUpdateStatus := usUnmodified; |
2192 |
> |
p^.rdCachedUpdateStatus := cusUnmodified; |
2193 |
> |
p^.rdSavedOffset := $FFFFFFFF; |
2194 |
> |
|
2195 |
> |
{ Load up the fields } |
2196 |
> |
FieldsLoaded := FQSelect.MetaData.Count; |
2197 |
> |
j := 1; |
2198 |
> |
for i := 0 to Qry.FieldCount - 1 do |
2199 |
> |
begin |
2200 |
> |
if (Qry = FQSelect) then |
2201 |
> |
j := i + 1 |
2202 |
> |
else |
2203 |
> |
begin |
2204 |
> |
if FieldsLoaded = 0 then |
2205 |
> |
break; |
2206 |
> |
j := FQSelect.FieldIndex[Qry[i].Name] + 1; |
2207 |
> |
if j < 1 then |
2208 |
> |
continue |
2209 |
> |
else |
2210 |
> |
Dec(FieldsLoaded); |
2211 |
> |
end; |
2212 |
> |
with FQSelect.MetaData[j - 1] do |
2213 |
> |
if GetAliasname = 'IBX_INTERNAL_DBKEY' then {do not localize} |
2214 |
|
begin |
2215 |
< |
rdFields[j].fdIsNull := True; |
2216 |
< |
rdFields[j].fdDataOfs := FRecordSize; |
2217 |
< |
Inc(FRecordSize, rdFields[j].fdDataSize); |
1888 |
< |
end |
1889 |
< |
else begin |
1890 |
< |
if rdFields[j].fdDataType = SQL_VARYING then |
1891 |
< |
begin |
1892 |
< |
if LocalData <> nil then |
1893 |
< |
Move(LocalData^, Buffer[rdFields[j].fdDataOfs], rdFields[j].fdDataLength) |
1894 |
< |
end |
1895 |
< |
else |
1896 |
< |
Move(LocalData^, Buffer[rdFields[j].fdDataOfs], rdFields[j].fdDataSize) |
2215 |
> |
if (GetSize <= 8) then |
2216 |
> |
p^.rdDBKey := PIBDBKEY(Qry[i].AsPointer)^; |
2217 |
> |
continue; |
2218 |
|
end; |
2219 |
< |
end; |
2219 |
> |
if j > 0 then |
2220 |
> |
ColumnDataToBuffer(Qry.Current,i,j,Buffer); |
2221 |
|
end; |
2222 |
< |
WriteRecordCache(RecordNumber, PChar(p)); |
2222 |
> |
WriteRecordCache(RecordNumber, Buffer); |
2223 |
|
end; |
2224 |
|
|
2225 |
|
function TIBCustomDataSet.GetActiveBuf: PChar; |
2264 |
|
result := FBase.Database; |
2265 |
|
end; |
2266 |
|
|
1945 |
– |
function TIBCustomDataSet.GetDBHandle: PISC_DB_HANDLE; |
1946 |
– |
begin |
1947 |
– |
result := FBase.DBHandle; |
1948 |
– |
end; |
1949 |
– |
|
2267 |
|
function TIBCustomDataSet.GetDeleteSQL: TStrings; |
2268 |
|
begin |
2269 |
|
result := FQDelete.SQL; |
2274 |
|
result := FQInsert.SQL; |
2275 |
|
end; |
2276 |
|
|
2277 |
< |
function TIBCustomDataSet.GetSQLParams: TIBXSQLDA; |
2277 |
> |
function TIBCustomDataSet.GetSQLParams: ISQLParams; |
2278 |
|
begin |
2279 |
|
if not FInternalPrepared then |
2280 |
|
InternalPrepare; |
2291 |
|
result := FQSelect.SQL; |
2292 |
|
end; |
2293 |
|
|
2294 |
< |
function TIBCustomDataSet.GetStatementType: TIBSQLTypes; |
2294 |
> |
function TIBCustomDataSet.GetStatementType: TIBSQLStatementTypes; |
2295 |
|
begin |
2296 |
< |
result := FQSelect.SQLType; |
2296 |
> |
result := FQSelect.SQLStatementType; |
2297 |
|
end; |
2298 |
|
|
2299 |
|
function TIBCustomDataSet.GetModifySQL: TStrings; |
2306 |
|
result := FBase.Transaction; |
2307 |
|
end; |
2308 |
|
|
1992 |
– |
function TIBCustomDataSet.GetTRHandle: PISC_TR_HANDLE; |
1993 |
– |
begin |
1994 |
– |
result := FBase.TRHandle; |
1995 |
– |
end; |
1996 |
– |
|
2309 |
|
procedure TIBCustomDataSet.InternalDeleteRecord(Qry: TIBSQL; Buff: Pointer); |
2310 |
|
begin |
2311 |
|
if (Assigned(FUpdateObject) and (FUpdateObject.GetSQL(ukDelete).Text <> '')) then |
2312 |
|
FUpdateObject.Apply(ukDelete,Buff) |
2313 |
|
else |
2314 |
|
begin |
2315 |
< |
SetInternalSQLParams(FQDelete, Buff); |
2315 |
> |
SetInternalSQLParams(FQDelete.Params, Buff); |
2316 |
|
FQDelete.ExecQuery; |
2317 |
|
end; |
2318 |
|
with PRecordData(Buff)^ do |
2327 |
|
const KeyValues: Variant; Options: TLocateOptions): Boolean; |
2328 |
|
var |
2329 |
|
keyFieldList: TList; |
2018 |
– |
{$IFDEF NEW_TBOOKMARK } |
2330 |
|
CurBookmark: TBookmark; |
2020 |
– |
{$ELSE} |
2021 |
– |
CurBookmark: string; |
2022 |
– |
{$ENDIF} |
2331 |
|
fieldValue: Variant; |
2332 |
|
lookupValues: array of variant; |
2333 |
|
i, fieldCount: Integer; |
2409 |
|
|
2410 |
|
procedure TIBCustomDataSet.InternalPostRecord(Qry: TIBSQL; Buff: Pointer); |
2411 |
|
var |
2412 |
< |
i, j, k: Integer; |
2412 |
> |
i, j, k, arr: Integer; |
2413 |
|
pbd: PBlobDataArray; |
2414 |
+ |
pda: PArrayDataArray; |
2415 |
|
begin |
2416 |
|
pbd := PBlobDataArray(PChar(Buff) + FBlobCacheOffset); |
2417 |
< |
j := 0; |
2417 |
> |
pda := PArrayDataArray(PChar(Buff) + FArrayCacheOffset); |
2418 |
> |
j := 0; arr := 0; |
2419 |
|
for i := 0 to FieldCount - 1 do |
2420 |
|
if Fields[i].IsBlob then |
2421 |
|
begin |
2424 |
|
begin |
2425 |
|
pbd^[j].Finalize; |
2426 |
|
PISC_QUAD( |
2427 |
< |
PChar(Buff) + PRecordData(Buff)^.rdFields[k].fdDataOfs)^ := |
2427 |
> |
PChar(Buff) + FFieldColumns^[k].fdDataOfs)^ := |
2428 |
|
pbd^[j].BlobID; |
2429 |
|
PRecordData(Buff)^.rdFields[k].fdIsNull := pbd^[j].Size = 0; |
2430 |
+ |
end |
2431 |
+ |
else |
2432 |
+ |
begin |
2433 |
+ |
PRecordData(Buff)^.rdFields[k].fdIsNull := true; |
2434 |
+ |
with PISC_QUAD(PChar(Buff) + FFieldColumns^[k].fdDataOfs)^ do |
2435 |
+ |
begin |
2436 |
+ |
gds_quad_high := 0; |
2437 |
+ |
gds_quad_low := 0; |
2438 |
+ |
end; |
2439 |
|
end; |
2440 |
|
Inc(j); |
2441 |
+ |
end |
2442 |
+ |
else |
2443 |
+ |
if Fields[i] is TIBArrayField then |
2444 |
+ |
begin |
2445 |
+ |
if pda^[arr] <> nil then |
2446 |
+ |
begin |
2447 |
+ |
k := FMappedFieldPosition[Fields[i].FieldNo -1]; |
2448 |
+ |
PISC_QUAD( |
2449 |
+ |
PChar(Buff) + FFieldColumns^[k].fdDataOfs)^ := pda^[arr].ArrayIntf.GetArrayID; |
2450 |
+ |
PRecordData(Buff)^.rdFields[k].fdIsNull := pda^[arr].ArrayIntf.IsEmpty; |
2451 |
+ |
end; |
2452 |
+ |
Inc(arr); |
2453 |
|
end; |
2454 |
|
if Assigned(FUpdateObject) then |
2455 |
|
begin |
2461 |
|
FUpdateObject.Apply(ukModify,Buff); |
2462 |
|
end |
2463 |
|
else begin |
2464 |
< |
SetInternalSQLParams(Qry, Buff); |
2464 |
> |
SetInternalSQLParams(Qry.Params, Buff); |
2465 |
|
Qry.ExecQuery; |
2466 |
|
end; |
2467 |
+ |
if Qry.FieldCount > 0 then {Has RETURNING Clause} |
2468 |
+ |
UpdateRecordFromQuery(Qry.Current,Buff); |
2469 |
|
PRecordData(Buff)^.rdUpdateStatus := usUnmodified; |
2470 |
|
PRecordData(Buff)^.rdCachedUpdateStatus := cusUnmodified; |
2471 |
|
SetModified(False); |
2497 |
|
end |
2498 |
|
else |
2499 |
|
Qry := FQRefresh; |
2500 |
< |
SetInternalSQLParams(Qry, Buff); |
2500 |
> |
SetInternalSQLParams(Qry.Params, Buff); |
2501 |
|
Qry.ExecQuery; |
2502 |
|
try |
2503 |
< |
if (Qry.SQLType = SQLExecProcedure) or |
2171 |
< |
(Qry.Next <> nil) then |
2503 |
> |
if (Qry.SQLStatementType = SQLExecProcedure) or Qry.Next then |
2504 |
|
begin |
2505 |
|
ofs := PRecordData(Buff)^.rdSavedOffset; |
2506 |
|
FetchCurrentRecordToBuffer(Qry, |
2593 |
|
end; |
2594 |
|
|
2595 |
|
procedure TIBCustomDataSet.InternalPrepare; |
2264 |
– |
var |
2265 |
– |
DidActivate: Boolean; |
2596 |
|
begin |
2597 |
|
if FInternalPrepared then |
2598 |
|
Exit; |
2269 |
– |
DidActivate := False; |
2599 |
|
FBase.SetCursor; |
2600 |
|
try |
2601 |
|
ActivateConnection; |
2602 |
< |
DidActivate := ActivateTransaction; |
2602 |
> |
ActivateTransaction; |
2603 |
|
FBase.CheckDatabase; |
2604 |
|
FBase.CheckTransaction; |
2605 |
|
if HasParser and (FParser.SQLText <> FQSelect.SQL.Text) then |
2637 |
|
end else |
2638 |
|
IBError(ibxeEmptyQuery, [nil]); |
2639 |
|
finally |
2311 |
– |
if DidActivate then |
2312 |
– |
DeactivateTransaction; |
2640 |
|
FBase.RestoreCursor; |
2641 |
|
end; |
2642 |
|
end; |
2666 |
|
begin |
2667 |
|
CopyRecordBuffer(Buffer, OldBuffer); |
2668 |
|
if BlobFieldCount > 0 then |
2669 |
< |
FillChar(PChar(OldBuffer)[FBlobCacheOffset], BlobFieldCount * SizeOf(TIBBlobStream), |
2669 |
> |
FillChar(PChar(OldBuffer)[FBlobCacheOffset], |
2670 |
> |
BlobFieldCount * SizeOf(TIBBlobStream) + ArrayFieldCount * SizeOf(IArray), |
2671 |
|
0); |
2672 |
|
end; |
2673 |
|
|
2709 |
|
if (FBase.Database <> Value) then |
2710 |
|
begin |
2711 |
|
CheckDatasetClosed; |
2712 |
+ |
InternalUnPrepare; |
2713 |
|
FBase.Database := Value; |
2714 |
|
FQDelete.Database := Value; |
2715 |
|
FQInsert.Database := Value; |
2716 |
|
FQRefresh.Database := Value; |
2717 |
|
FQSelect.Database := Value; |
2718 |
|
FQModify.Database := Value; |
2719 |
+ |
FDatabaseInfo.Database := Value; |
2720 |
|
end; |
2721 |
|
end; |
2722 |
|
|
2738 |
|
end; |
2739 |
|
end; |
2740 |
|
|
2741 |
< |
procedure TIBCustomDataSet.SetInternalSQLParams(Qry: TIBSQL; Buffer: Pointer); |
2741 |
> |
procedure TIBCustomDataSet.SetInternalSQLParams(Params: ISQLParams; Buffer: Pointer); |
2742 |
|
var |
2743 |
|
i, j: Integer; |
2744 |
|
cr, data: PChar; |
2746 |
|
st: RawByteString; |
2747 |
|
OldBuffer: Pointer; |
2748 |
|
ts: TTimeStamp; |
2749 |
+ |
Param: ISQLParam; |
2750 |
|
begin |
2751 |
|
if (Buffer = nil) then |
2752 |
|
IBError(ibxeBufferNotSet, [nil]); |
2754 |
|
InternalPrepare; |
2755 |
|
OldBuffer := nil; |
2756 |
|
try |
2757 |
< |
for i := 0 to Qry.Params.Count - 1 do |
2757 |
> |
for i := 0 to Params.GetCount - 1 do |
2758 |
|
begin |
2759 |
< |
fn := Qry.Params[i].Name; |
2759 |
> |
Param := Params[i]; |
2760 |
> |
fn := Param.Name; |
2761 |
|
if (Pos('OLD_', fn) = 1) then {mbcs ok} |
2762 |
|
begin |
2763 |
|
fn := Copy(fn, 5, Length(fn)); |
2777 |
|
cr := Buffer; |
2778 |
|
j := FQSelect.FieldIndex[fn] + 1; |
2779 |
|
if (j > 0) then |
2780 |
< |
with PRecordData(cr)^ do |
2780 |
> |
with PRecordData(cr)^,rdFields[j], FFieldColumns^[j] do |
2781 |
|
begin |
2782 |
< |
if Qry.Params[i].name = 'IBX_INTERNAL_DBKEY' then {do not localize} |
2782 |
> |
if Param.name = 'IBX_INTERNAL_DBKEY' then {do not localize} |
2783 |
|
begin |
2784 |
< |
PIBDBKey(Qry.Params[i].AsPointer)^ := rdDBKey; |
2784 |
> |
PIBDBKey(Param.AsPointer)^ := rdDBKey; |
2785 |
|
continue; |
2786 |
|
end; |
2787 |
< |
if rdFields[j].fdIsNull then |
2788 |
< |
Qry.Params[i].IsNull := True |
2787 |
> |
if fdIsNull then |
2788 |
> |
Param.IsNull := True |
2789 |
|
else begin |
2790 |
< |
Qry.Params[i].IsNull := False; |
2791 |
< |
data := cr + rdFields[j].fdDataOfs; |
2792 |
< |
case rdFields[j].fdDataType of |
2790 |
> |
Param.IsNull := False; |
2791 |
> |
data := cr + fdDataOfs; |
2792 |
> |
case fdDataType of |
2793 |
|
SQL_TEXT, SQL_VARYING: |
2794 |
|
begin |
2795 |
< |
SetString(st, data, rdFields[j].fdDataLength); |
2796 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
2797 |
< |
SetCodePage(st,rdFields[j].fdCodePage,false); |
2466 |
< |
{$ENDIF} |
2467 |
< |
Qry.Params[i].AsString := st; |
2795 |
> |
SetString(st, data, fdDataLength); |
2796 |
> |
SetCodePage(st,fdCodePage,false); |
2797 |
> |
Param.AsString := st; |
2798 |
|
end; |
2799 |
|
SQL_FLOAT, SQL_DOUBLE, SQL_D_FLOAT: |
2800 |
< |
Qry.Params[i].AsDouble := PDouble(data)^; |
2800 |
> |
Param.AsDouble := PDouble(data)^; |
2801 |
|
SQL_SHORT, SQL_LONG: |
2802 |
|
begin |
2803 |
< |
if rdFields[j].fdDataScale = 0 then |
2804 |
< |
Qry.Params[i].AsLong := PLong(data)^ |
2475 |
< |
else if rdFields[j].fdDataScale >= (-4) then |
2476 |
< |
Qry.Params[i].AsCurrency := PCurrency(data)^ |
2803 |
> |
if fdDataScale = 0 then |
2804 |
> |
Param.AsLong := PLong(data)^ |
2805 |
|
else |
2806 |
< |
Qry.Params[i].AsDouble := PDouble(data)^; |
2806 |
> |
if fdDataScale >= (-4) then |
2807 |
> |
Param.AsCurrency := PCurrency(data)^ |
2808 |
> |
else |
2809 |
> |
Param.AsDouble := PDouble(data)^; |
2810 |
|
end; |
2811 |
|
SQL_INT64: |
2812 |
|
begin |
2813 |
< |
if rdFields[j].fdDataScale = 0 then |
2814 |
< |
Qry.Params[i].AsInt64 := PInt64(data)^ |
2815 |
< |
else if rdFields[j].fdDataScale >= (-4) then |
2816 |
< |
Qry.Params[i].AsCurrency := PCurrency(data)^ |
2813 |
> |
if fdDataScale = 0 then |
2814 |
> |
Param.AsInt64 := PInt64(data)^ |
2815 |
> |
else |
2816 |
> |
if fdDataScale >= (-4) then |
2817 |
> |
Param.AsCurrency := PCurrency(data)^ |
2818 |
|
else |
2819 |
< |
Qry.Params[i].AsDouble := PDouble(data)^; |
2819 |
> |
Param.AsDouble := PDouble(data)^; |
2820 |
|
end; |
2821 |
|
SQL_BLOB, SQL_ARRAY, SQL_QUAD: |
2822 |
< |
Qry.Params[i].AsQuad := PISC_QUAD(data)^; |
2822 |
> |
Param.AsQuad := PISC_QUAD(data)^; |
2823 |
|
SQL_TYPE_DATE: |
2824 |
|
begin |
2825 |
|
ts.Date := PInt(data)^; |
2826 |
|
ts.Time := 0; |
2827 |
< |
Qry.Params[i].AsDate := |
2496 |
< |
TimeStampToDateTime(ts); |
2827 |
> |
Param.AsDate := TimeStampToDateTime(ts); |
2828 |
|
end; |
2829 |
|
SQL_TYPE_TIME: |
2830 |
|
begin |
2831 |
|
ts.Date := 0; |
2832 |
|
ts.Time := PInt(data)^; |
2833 |
< |
Qry.Params[i].AsTime := |
2503 |
< |
TimeStampToDateTime(ts); |
2833 |
> |
Param.AsTime := TimeStampToDateTime(ts); |
2834 |
|
end; |
2835 |
|
SQL_TIMESTAMP: |
2836 |
< |
Qry.Params[i].AsDateTime := |
2836 |
> |
Param.AsDateTime := |
2837 |
|
TimeStampToDateTime(MSecsToTimeStamp(trunc(PDouble(data)^))); |
2838 |
|
SQL_BOOLEAN: |
2839 |
< |
Qry.Params[i].AsBoolean := PWordBool(data)^; |
2839 |
> |
Param.AsBoolean := PWordBool(data)^; |
2840 |
|
end; |
2841 |
|
end; |
2842 |
|
end; |
2992 |
|
Result := Assigned( FQSelect ) and FQSelect.EOF; |
2993 |
|
end; |
2994 |
|
|
2995 |
< |
function TIBCustomDataSet.ParamByName(ParamName: String): TIBXSQLVAR; |
2995 |
> |
function TIBCustomDataSet.ParamByName(ParamName: String): ISQLParam; |
2996 |
|
begin |
2997 |
|
ActivateConnection; |
2998 |
|
ActivateTransaction; |
3129 |
|
Buff: PChar; |
3130 |
|
bTr, bDB: Boolean; |
3131 |
|
begin |
3132 |
+ |
if (Field = nil) or (Field.DataSet <> self) then |
3133 |
+ |
IBError(ibxFieldNotinDataSet,[Field.Name,Name]); |
3134 |
|
Buff := GetActiveBuf; |
3135 |
|
if Buff = nil then |
3136 |
|
begin |
3137 |
|
fs := TIBBlobStream.Create; |
3138 |
|
fs.Mode := bmReadWrite; |
3139 |
+ |
fs.Database := Database; |
3140 |
+ |
fs.Transaction := Transaction; |
3141 |
+ |
fs.SetField(Field); |
3142 |
|
FBlobStreamList.Add(Pointer(fs)); |
3143 |
|
result := TIBDSBlobStream.Create(Field, fs, Mode); |
3144 |
|
exit; |
3153 |
|
fs.Mode := bmReadWrite; |
3154 |
|
fs.Database := Database; |
3155 |
|
fs.Transaction := Transaction; |
3156 |
+ |
fs.SetField(Field); |
3157 |
|
fs.BlobID := |
3158 |
< |
PISC_QUAD(@Buff[PRecordData(Buff)^.rdFields[FMappedFieldPosition[Field.FieldNo - 1]].fdDataOfs])^; |
3158 |
> |
PISC_QUAD(@Buff[FFieldColumns^[FMappedFieldPosition[Field.FieldNo - 1]].fdDataOfs])^; |
3159 |
|
if (CachedUpdates) then |
3160 |
|
begin |
3161 |
|
bTr := not Transaction.InTransaction; |
3176 |
|
result := TIBDSBlobStream.Create(Field, fs, Mode); |
3177 |
|
end; |
3178 |
|
|
3179 |
+ |
function TIBCustomDataSet.GetArray(Field: TIBArrayField): IArray; |
3180 |
+ |
var Buff: PChar; |
3181 |
+ |
pda: PArrayDataArray; |
3182 |
+ |
bTr, bDB: Boolean; |
3183 |
+ |
begin |
3184 |
+ |
if (Field = nil) or (Field.DataSet <> self) then |
3185 |
+ |
IBError(ibxFieldNotinDataSet,[Field.Name,Name]); |
3186 |
+ |
Buff := GetActiveBuf; |
3187 |
+ |
if Buff = nil then |
3188 |
+ |
Result := Database.Attachment.CreateArray(Transaction.TransactionIntf, |
3189 |
+ |
Field.FRelationName,Field.FieldName) |
3190 |
+ |
else |
3191 |
+ |
begin |
3192 |
+ |
pda := PArrayDataArray(Buff + FArrayCacheOffset); |
3193 |
+ |
if pda^[Field.FCacheOffset] = nil then |
3194 |
+ |
begin |
3195 |
+ |
AdjustRecordOnInsert(Buff); |
3196 |
+ |
if Field.IsNull then |
3197 |
+ |
Result := Database.Attachment.CreateArray(Transaction.TransactionIntf, |
3198 |
+ |
Field.FRelationName,Field.FieldName) |
3199 |
+ |
else |
3200 |
+ |
Result := Database.Attachment.OpenArray(Transaction.TransactionIntf, |
3201 |
+ |
Field.FRelationName,Field.FieldName,Field.ArrayID); |
3202 |
+ |
pda^[Field.FCacheOffset] := TIBArray.Create(Field,Result); |
3203 |
+ |
FArrayList.Add(pda^[Field.FCacheOffset]); |
3204 |
+ |
if (CachedUpdates) then |
3205 |
+ |
begin |
3206 |
+ |
bTr := not Transaction.InTransaction; |
3207 |
+ |
bDB := not Database.Connected; |
3208 |
+ |
if bDB then |
3209 |
+ |
Database.Open; |
3210 |
+ |
if bTr then |
3211 |
+ |
Transaction.StartTransaction; |
3212 |
+ |
pda^[Field.FCacheOffset].ArrayIntf.PreLoad; |
3213 |
+ |
if bTr then |
3214 |
+ |
Transaction.Commit; |
3215 |
+ |
if bDB then |
3216 |
+ |
Database.Close; |
3217 |
+ |
end; |
3218 |
+ |
WriteRecordCache(PRecordData(Buff)^.rdRecordNumber, Pointer(Buff)); |
3219 |
+ |
end |
3220 |
+ |
else |
3221 |
+ |
Result := pda^[Field.FCacheOffset].ArrayIntf; |
3222 |
+ |
end; |
3223 |
+ |
end; |
3224 |
+ |
|
3225 |
+ |
procedure TIBCustomDataSet.SetArrayIntf(AnArray: IArray; Field: TIBArrayField); |
3226 |
+ |
var Buff: PChar; |
3227 |
+ |
pda: PArrayDataArray; |
3228 |
+ |
begin |
3229 |
+ |
if (Field = nil) or (Field.DataSet <> self) then |
3230 |
+ |
IBError(ibxFieldNotinDataSet,[Field.Name,Name]); |
3231 |
+ |
Buff := GetActiveBuf; |
3232 |
+ |
if Buff <> nil then |
3233 |
+ |
begin |
3234 |
+ |
AdjustRecordOnInsert(Buff); |
3235 |
+ |
pda := PArrayDataArray(Buff + FArrayCacheOffset); |
3236 |
+ |
pda^[Field.FCacheOffset].FArray := AnArray; |
3237 |
+ |
WriteRecordCache(PRecordData(Buff)^.rdRecordNumber, Pointer(Buff)); |
3238 |
+ |
end; |
3239 |
+ |
end; |
3240 |
+ |
|
3241 |
|
function TIBCustomDataSet.CompareBookmarks(Bookmark1, Bookmark2: TBookmark): Integer; |
3242 |
|
const |
3243 |
|
CMPLess = -1; |
3318 |
|
procedure TIBCustomDataSet.DoBeforeClose; |
3319 |
|
begin |
3320 |
|
inherited DoBeforeClose; |
3321 |
+ |
if FInTransactionEnd and (FCloseAction = TARollback) then |
3322 |
+ |
Exit; |
3323 |
|
if State in [dsInsert,dsEdit] then |
3324 |
|
begin |
2925 |
– |
if FInTransactionEnd and (FCloseAction = TARollback) then |
2926 |
– |
Exit; |
2927 |
– |
|
3325 |
|
if DataSetCloseAction = dcSaveChanges then |
3326 |
|
Post; |
3327 |
|
{Note this can fail with an exception e.g. due to |
3328 |
|
database validation error. In which case the dataset remains open } |
3329 |
|
end; |
3330 |
+ |
if FCachedUpdates and FUpdatesPending and (DataSetCloseAction = dcSaveChanges) then |
3331 |
+ |
ApplyUpdates; |
3332 |
|
end; |
3333 |
|
|
3334 |
|
procedure TIBCustomDataSet.DoBeforeOpen; |
3360 |
|
|
3361 |
|
procedure TIBCustomDataSet.FetchAll; |
3362 |
|
var |
2964 |
– |
{$IFDEF NEW_TBOOKMARK } |
3363 |
|
CurBookmark: TBookmark; |
2966 |
– |
{$ELSE} |
2967 |
– |
CurBookmark: string; |
2968 |
– |
{$ENDIF} |
3364 |
|
begin |
3365 |
|
FBase.SetCursor; |
3366 |
|
try |
3471 |
|
if result and (Buffer <> nil) then |
3472 |
|
Move(Buff[1], Buffer^, Field.DataSize); |
3473 |
|
end |
3474 |
< |
else if (FMappedFieldPosition[Field.FieldNo - 1] > 0) and |
3474 |
> |
else |
3475 |
> |
if (FMappedFieldPosition[Field.FieldNo - 1] > 0) and |
3476 |
|
(FMappedFieldPosition[Field.FieldNo - 1] <= CurrentRecord^.rdFieldCount) then |
3477 |
+ |
with CurrentRecord^.rdFields[FMappedFieldPosition[Field.FieldNo - 1]], |
3478 |
+ |
FFieldColumns^[FMappedFieldPosition[Field.FieldNo - 1]] do |
3479 |
|
begin |
3480 |
< |
result := not CurrentRecord^.rdFields[FMappedFieldPosition[Field.FieldNo - 1]].fdIsNull; |
3480 |
> |
result := not fdIsNull; |
3481 |
|
if result and (Buffer <> nil) then |
3084 |
– |
with CurrentRecord^.rdFields[FMappedFieldPosition[Field.FieldNo - 1]] do |
3482 |
|
begin |
3483 |
< |
Data := Buff + CurrentRecord^.rdFields[FMappedFieldPosition[Field.FieldNo - 1]].fdDataOfs; |
3483 |
> |
Data := Buff + fdDataOfs; |
3484 |
|
if (fdDataType = SQL_VARYING) or (fdDataType = SQL_TEXT) then |
3485 |
|
begin |
3486 |
|
if fdDataLength < Field.DataSize then |
3551 |
|
if FCurrentRecord < FRecordCount then |
3552 |
|
ReadRecordCache(FCurrentRecord, Buffer, False) |
3553 |
|
else begin |
3554 |
< |
while (not FQSelect.EOF) and |
3158 |
< |
(FQSelect.Next <> nil) and |
3554 |
> |
while (not FQSelect.EOF) and FQSelect.Next and |
3555 |
|
(FCurrentRecord >= FRecordCount) do begin |
3556 |
|
FetchCurrentRecordToBuffer(FQSelect, FRecordCount, Buffer); |
3557 |
|
Inc(FRecordCount); |
3662 |
|
var |
3663 |
|
Buff: PChar; |
3664 |
|
CurRec: Integer; |
3665 |
+ |
pda: PArrayDataArray; |
3666 |
+ |
i: integer; |
3667 |
|
begin |
3668 |
|
inherited InternalCancel; |
3669 |
|
Buff := GetActiveBuf; |
3670 |
< |
if Buff <> nil then begin |
3670 |
> |
if Buff <> nil then |
3671 |
> |
begin |
3672 |
> |
pda := PArrayDataArray(Buff + FArrayCacheOffset); |
3673 |
> |
for i := 0 to ArrayFieldCount - 1 do |
3674 |
> |
pda^[i].ArrayIntf.CancelChanges; |
3675 |
|
CurRec := FCurrentRecord; |
3676 |
|
AdjustRecordOnInsert(Buff); |
3677 |
|
if (State = dsEdit) then begin |
3694 |
|
DeactivateTransaction; |
3695 |
|
FQSelect.Close; |
3696 |
|
ClearBlobCache; |
3697 |
+ |
ClearArrayCache; |
3698 |
|
FreeRecordBuffer(FModelBuffer); |
3699 |
|
FreeRecordBuffer(FOldBuffer); |
3700 |
|
FCurrentRecord := -1; |
3710 |
|
FOBEnd := 0; |
3711 |
|
FreeMem(FBufferCache); |
3712 |
|
FBufferCache := nil; |
3713 |
+ |
FreeMem(FFieldColumns); |
3714 |
+ |
FFieldColumns := nil; |
3715 |
|
FreeMem(FOldBufferCache); |
3716 |
|
FOldBufferCache := nil; |
3717 |
|
BindFields(False); |
3786 |
|
'and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME '+ {do not localize} |
3787 |
|
'and ((not F.RDB$COMPUTED_BLR is NULL) or ' + {do not localize} |
3788 |
|
' (not F.RDB$DEFAULT_VALUE is NULL)) '; {do not localize} |
3789 |
+ |
|
3790 |
+ |
DefaultSQLODS12 = 'Select F.RDB$COMPUTED_BLR, ' + {do not localize} |
3791 |
+ |
'F.RDB$DEFAULT_VALUE, R.RDB$FIELD_NAME, R.RDB$IDENTITY_TYPE ' + {do not localize} |
3792 |
+ |
'from RDB$RELATION_FIELDS R, RDB$FIELDS F ' + {do not localize} |
3793 |
+ |
'where R.RDB$RELATION_NAME = :RELATION ' + {do not localize} |
3794 |
+ |
'and R.RDB$FIELD_SOURCE = F.RDB$FIELD_NAME '+ {do not localize} |
3795 |
+ |
'and ((not F.RDB$COMPUTED_BLR is NULL) or ' + {do not localize} |
3796 |
+ |
' (not F.RDB$DEFAULT_VALUE is NULL) or ' + {do not localize} |
3797 |
+ |
' ( not R.RDB$IDENTITY_TYPE is NULL))' ; {do not localize} |
3798 |
+ |
|
3799 |
|
var |
3800 |
|
FieldType: TFieldType; |
3801 |
|
FieldSize: Word; |
3802 |
< |
charSetID: integer; |
3802 |
> |
FieldDataSize: integer; |
3803 |
> |
charSetID: short; |
3804 |
|
CharSetSize: integer; |
3805 |
|
CharSetName: RawByteString; |
3390 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
3806 |
|
FieldCodePage: TSystemCodePage; |
3392 |
– |
{$ENDIF} |
3807 |
|
FieldNullable : Boolean; |
3808 |
|
i, FieldPosition, FieldPrecision: Integer; |
3809 |
|
FieldAliasName, DBAliasName: string; |
3810 |
< |
RelationName, FieldName: string; |
3810 |
> |
aRelationName, FieldName: string; |
3811 |
|
Query : TIBSQL; |
3812 |
|
FieldIndex: Integer; |
3813 |
|
FRelationNodes : TRelationNode; |
3814 |
+ |
aArrayDimensions: integer; |
3815 |
+ |
aArrayBounds: TArrayBounds; |
3816 |
+ |
ArrayMetaData: IArrayMetaData; |
3817 |
|
|
3818 |
|
function Add_Node(Relation, Field : String) : TRelationNode; |
3819 |
|
var |
3836 |
|
FField.FieldName := Query.Fields[2].AsString; |
3837 |
|
FField.DEFAULT_VALUE := not Query.Fields[1].IsNull; |
3838 |
|
FField.COMPUTED_BLR := not Query.Fields[0].IsNull; |
3839 |
+ |
FField.IDENTITY_COLUMN := (Query.FieldCount > 3) and not Query.Fields[3].IsNull; |
3840 |
|
FField.NextField := Result.FieldNodes; |
3841 |
|
Result.FieldNodes := FField; |
3842 |
|
Query.Next; |
3890 |
|
FField := Ffield.NextField; |
3891 |
|
end; |
3892 |
|
|
3893 |
+ |
function Is_IDENTITY_COLUMN(Relation, Field : String) : Boolean; |
3894 |
+ |
var |
3895 |
+ |
FRelation : TRelationNode; |
3896 |
+ |
FField : TFieldNode; |
3897 |
+ |
begin |
3898 |
+ |
FRelation := FRelationNodes; |
3899 |
+ |
while Assigned(FRelation) and |
3900 |
+ |
(FRelation.RelationName <> Relation) do |
3901 |
+ |
FRelation := FRelation.NextRelation; |
3902 |
+ |
if not Assigned(FRelation) then |
3903 |
+ |
FRelation := Add_Node(Relation, Field); |
3904 |
+ |
Result := false; |
3905 |
+ |
FField := FRelation.FieldNodes; |
3906 |
+ |
while Assigned(FField) do |
3907 |
+ |
if FField.FieldName = Field then |
3908 |
+ |
begin |
3909 |
+ |
Result := Ffield.IDENTITY_COLUMN; |
3910 |
+ |
Exit; |
3911 |
+ |
end |
3912 |
+ |
else |
3913 |
+ |
FField := Ffield.NextField; |
3914 |
+ |
end; |
3915 |
+ |
|
3916 |
|
Procedure FreeNodes; |
3917 |
|
var |
3918 |
|
FRelation : TRelationNode; |
3935 |
|
begin |
3936 |
|
FRelationNodes := TRelationNode.Create; |
3937 |
|
FNeedsRefresh := False; |
3938 |
< |
Database.InternalTransaction.StartTransaction; |
3938 |
> |
if not Database.InternalTransaction.InTransaction then |
3939 |
> |
Database.InternalTransaction.StartTransaction; |
3940 |
|
Query := TIBSQL.Create(self); |
3941 |
|
try |
3942 |
|
Query.Database := DataBase; |
3944 |
|
FieldDefs.BeginUpdate; |
3945 |
|
FieldDefs.Clear; |
3946 |
|
FieldIndex := 0; |
3947 |
< |
if (Length(FMappedFieldPosition) < SourceQuery.Current.Count) then |
3948 |
< |
SetLength(FMappedFieldPosition, SourceQuery.Current.Count); |
3949 |
< |
Query.SQL.Text := DefaultSQL; |
3947 |
> |
if (Length(FMappedFieldPosition) < SourceQuery.MetaData.Count) then |
3948 |
> |
SetLength(FMappedFieldPosition, SourceQuery.MetaData.Count); |
3949 |
> |
if FDatabaseInfo.ODSMajorVersion >= 12 then |
3950 |
> |
Query.SQL.Text := DefaultSQLODS12 |
3951 |
> |
else |
3952 |
> |
Query.SQL.Text := DefaultSQL; |
3953 |
|
Query.Prepare; |
3954 |
< |
SetLength(FAliasNameMap, SourceQuery.Current.Count); |
3955 |
< |
SetLength(FAliasNameList, SourceQuery.Current.Count); |
3956 |
< |
for i := 0 to SourceQuery.Current.Count - 1 do |
3957 |
< |
with SourceQuery.Current[i].Data^ do |
3954 |
> |
SetLength(FAliasNameMap, SourceQuery.MetaData.Count); |
3955 |
> |
SetLength(FAliasNameList, SourceQuery.MetaData.Count); |
3956 |
> |
for i := 0 to SourceQuery.MetaData.GetCount - 1 do |
3957 |
> |
with SourceQuery.MetaData[i] do |
3958 |
|
begin |
3959 |
|
{ Get the field name } |
3960 |
< |
FieldAliasName := SourceQuery.Current[i].Name; |
3961 |
< |
SetString(DBAliasName, aliasname, aliasname_length); |
3962 |
< |
SetString(RelationName, relname, relname_length); |
3963 |
< |
SetString(FieldName, sqlname, sqlname_length); |
3960 |
> |
FieldAliasName := GetName; |
3961 |
> |
DBAliasName := GetAliasname; |
3962 |
> |
aRelationName := getRelationName; |
3963 |
> |
FieldName := getSQLName; |
3964 |
|
FAliasNameList[i] := DBAliasName; |
3965 |
|
FieldSize := 0; |
3966 |
+ |
FieldDataSize := GetSize; |
3967 |
|
FieldPrecision := 0; |
3968 |
< |
FieldNullable := SourceQuery.Current[i].IsNullable; |
3968 |
> |
FieldNullable := IsNullable; |
3969 |
|
CharSetSize := 0; |
3970 |
|
CharSetName := ''; |
3525 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
3971 |
|
FieldCodePage := CP_NONE; |
3972 |
< |
{$ENDIF} |
3973 |
< |
case sqltype and not 1 of |
3972 |
> |
aArrayDimensions := 0; |
3973 |
> |
SetLength(aArrayBounds,0); |
3974 |
> |
case SQLType of |
3975 |
|
{ All VARCHAR's must be converted to strings before recording |
3976 |
|
their values } |
3977 |
|
SQL_VARYING, SQL_TEXT: |
3978 |
|
begin |
3979 |
< |
CharSetID := SourceQuery.Current[i].GetCharSetID; |
3980 |
< |
TFirebirdCharacterSets.CharSetWidth(CharSetID,CharSetSize); |
3981 |
< |
CharSetName := TFirebirdCharacterSets.GetCharsetName(CharSetID); |
3982 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
3983 |
< |
TFirebirdCharacterSets.CharSetID2CodePage(CharSetID,FieldCodePage); |
3538 |
< |
{$ENDIF} |
3539 |
< |
FieldSize := sqllen; |
3979 |
> |
if not Database.Attachment.CharSetWidth(getCharSetID,CharSetSize) then |
3980 |
> |
CharSetSize := 1; |
3981 |
> |
CharSetName := Database.Attachment.GetCharsetName(getCharSetID); |
3982 |
> |
Database.Attachment.CharSetID2CodePage(getCharSetID,FieldCodePage); |
3983 |
> |
FieldSize := FieldDataSize div CharSetSize; |
3984 |
|
FieldType := ftString; |
3985 |
|
end; |
3986 |
|
{ All Doubles/Floats should be cast to doubles } |
3988 |
|
FieldType := ftFloat; |
3989 |
|
SQL_SHORT: |
3990 |
|
begin |
3991 |
< |
if (sqlscale = 0) then |
3991 |
> |
if (getScale = 0) then |
3992 |
|
FieldType := ftSmallInt |
3993 |
|
else begin |
3994 |
|
FieldType := ftBCD; |
3995 |
|
FieldPrecision := 4; |
3996 |
< |
FieldSize := -sqlscale; |
3996 |
> |
FieldSize := -getScale; |
3997 |
|
end; |
3998 |
|
end; |
3999 |
|
SQL_LONG: |
4000 |
|
begin |
4001 |
< |
if (sqlscale = 0) then |
4001 |
> |
if (getScale = 0) then |
4002 |
|
FieldType := ftInteger |
4003 |
< |
else if (sqlscale >= (-4)) then |
4003 |
> |
else if (getScale >= (-4)) then |
4004 |
|
begin |
4005 |
|
FieldType := ftBCD; |
4006 |
|
FieldPrecision := 9; |
4007 |
< |
FieldSize := -sqlscale; |
4007 |
> |
FieldSize := -getScale; |
4008 |
|
end |
4009 |
|
else |
4010 |
|
if Database.SQLDialect = 1 then |
4016 |
|
begin |
4017 |
|
FieldType := ftFMTBCD; |
4018 |
|
FieldPrecision := 9; |
4019 |
< |
FieldSize := -sqlscale; |
4019 |
> |
FieldSize := -getScale; |
4020 |
|
end; |
4021 |
|
end; |
4022 |
|
|
4023 |
|
SQL_INT64: |
4024 |
|
begin |
4025 |
< |
if (sqlscale = 0) then |
4025 |
> |
if (getScale = 0) then |
4026 |
|
FieldType := ftLargeInt |
4027 |
< |
else if (sqlscale >= (-4)) then |
4027 |
> |
else if (getScale >= (-4)) then |
4028 |
|
begin |
4029 |
|
FieldType := ftBCD; |
4030 |
|
FieldPrecision := 18; |
4031 |
< |
FieldSize := -sqlscale; |
4031 |
> |
FieldSize := -getScale; |
4032 |
|
end |
4033 |
|
else |
4034 |
< |
FieldType := ftFloat |
4034 |
> |
FieldType := ftFloat; |
4035 |
|
end; |
4036 |
|
SQL_TIMESTAMP: FieldType := ftDateTime; |
4037 |
|
SQL_TYPE_TIME: FieldType := ftTime; |
4039 |
|
SQL_BLOB: |
4040 |
|
begin |
4041 |
|
FieldSize := sizeof (TISC_QUAD); |
4042 |
< |
if (sqlsubtype = 1) then |
4042 |
> |
if (getSubtype = 1) then |
4043 |
|
begin |
4044 |
< |
CharSetID := SourceQuery.Current[i].GetCharSetID; |
4045 |
< |
TFirebirdCharacterSets.CharSetWidth(CharSetID,CharSetSize); |
4046 |
< |
CharSetName := TFirebirdCharacterSets.GetCharsetName(CharSetID); |
4047 |
< |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
3604 |
< |
TFirebirdCharacterSets.CharSetID2CodePage(CharSetID,FieldCodePage); |
3605 |
< |
{$ENDIF} |
4044 |
> |
if not Database.Attachment.CharSetWidth(getCharSetID,CharSetSize) then |
4045 |
> |
CharSetSize := 1; |
4046 |
> |
CharSetName := Database.Attachment.GetCharsetName(getCharSetID); |
4047 |
> |
Database.Attachment.CharSetID2CodePage(getCharSetID,FieldCodePage); |
4048 |
|
FieldType := ftMemo; |
4049 |
|
end |
4050 |
|
else |
4053 |
|
SQL_ARRAY: |
4054 |
|
begin |
4055 |
|
FieldSize := sizeof (TISC_QUAD); |
4056 |
< |
FieldType := ftUnknown; |
4056 |
> |
FieldType := ftArray; |
4057 |
> |
ArrayMetaData := GetArrayMetaData; |
4058 |
> |
if ArrayMetaData <> nil then |
4059 |
> |
begin |
4060 |
> |
aArrayDimensions := ArrayMetaData.GetDimensions; |
4061 |
> |
aArrayBounds := ArrayMetaData.GetBounds; |
4062 |
> |
end; |
4063 |
|
end; |
4064 |
|
SQL_BOOLEAN: |
4065 |
|
FieldType:= ftBoolean; |
4076 |
|
Name := FieldAliasName; |
4077 |
|
FAliasNameMap[FieldNo-1] := DBAliasName; |
4078 |
|
Size := FieldSize; |
4079 |
+ |
DataSize := FieldDataSize; |
4080 |
|
Precision := FieldPrecision; |
4081 |
|
Required := not FieldNullable; |
4082 |
+ |
RelationName := aRelationName; |
4083 |
|
InternalCalcField := False; |
4084 |
|
CharacterSetSize := CharSetSize; |
4085 |
|
CharacterSetName := CharSetName; |
3636 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
4086 |
|
CodePage := FieldCodePage; |
4087 |
< |
{$ENDIF} |
4087 |
> |
ArrayDimensions := aArrayDimensions; |
4088 |
> |
ArrayBounds := aArrayBounds; |
4089 |
|
if (FieldName <> '') and (RelationName <> '') then |
4090 |
|
begin |
4091 |
+ |
IdentityColumn := Is_IDENTITY_COLUMN(RelationName, FieldName); |
4092 |
|
if Has_COMPUTED_BLR(RelationName, FieldName) then |
4093 |
|
begin |
4094 |
|
Attributes := [faReadOnly]; |
4114 |
|
FreeNodes; |
4115 |
|
Database.InternalTransaction.Commit; |
4116 |
|
FieldDefs.EndUpdate; |
4117 |
+ |
FieldDefs.Updated := true; |
4118 |
|
end; |
4119 |
|
end; |
4120 |
|
|
4132 |
|
else begin |
4133 |
|
Buffer := AllocRecordBuffer; |
4134 |
|
try |
4135 |
< |
while FQSelect.Next <> nil do |
4135 |
> |
while FQSelect.Next do |
4136 |
|
begin |
4137 |
|
FetchCurrentRecordToBuffer(FQSelect, FRecordCount, Buffer); |
4138 |
|
Inc(FRecordCount); |
4147 |
|
procedure TIBCustomDataSet.InternalSetParamsFromCursor; |
4148 |
|
var |
4149 |
|
i: Integer; |
4150 |
< |
cur_param: TIBXSQLVAR; |
4150 |
> |
cur_param: ISQLParam; |
4151 |
|
cur_field: TField; |
4152 |
|
s: TStream; |
4153 |
|
begin |
4155 |
|
IBError(ibxeEmptyQuery, [nil]); |
4156 |
|
if not FInternalPrepared then |
4157 |
|
InternalPrepare; |
4158 |
< |
if (SQLParams.Count > 0) and (DataSource <> nil) and (DataSource.DataSet <> nil) then |
4158 |
> |
if (SQLParams.GetCount > 0) and (DataSource <> nil) and (DataSource.DataSet <> nil) then |
4159 |
|
begin |
4160 |
< |
for i := 0 to SQLParams.Count - 1 do |
4160 |
> |
for i := 0 to SQLParams.GetCount - 1 do |
4161 |
|
begin |
4162 |
|
cur_field := DataSource.DataSet.FindField(SQLParams[i].Name); |
4163 |
|
cur_param := SQLParams[i]; |
4191 |
|
try |
4192 |
|
s := DataSource.DataSet. |
4193 |
|
CreateBlobStream(cur_field, bmRead); |
4194 |
< |
cur_param.LoadFromStream(s); |
4194 |
> |
cur_param.AsBlob := TIBDSBlobStream(s).FBlobStream.Blob; |
4195 |
|
finally |
4196 |
|
s.free; |
4197 |
|
end; |
4198 |
|
end; |
4199 |
+ |
ftArray: |
4200 |
+ |
cur_param.AsArray := TIBArrayField(cur_field).ArrayIntf; |
4201 |
|
else |
4202 |
|
IBError(ibxeNotSupported, [nil]); |
4203 |
|
end; |
4230 |
|
result := SizeOf(TRecordData) + ((n - 1) * SizeOf(TFieldData)); |
4231 |
|
end; |
4232 |
|
|
3779 |
– |
function GetFieldDef(aFieldNo: integer): TIBFieldDef; |
3780 |
– |
var i: integer; |
3781 |
– |
begin |
3782 |
– |
Result := nil; |
3783 |
– |
for i := 0 to FieldDefs.Count - 1 do |
3784 |
– |
if FieldDefs[i].FieldNo = aFieldNo then |
3785 |
– |
begin |
3786 |
– |
Result := TIBFieldDef(FieldDefs[i]); |
3787 |
– |
break; |
3788 |
– |
end; |
3789 |
– |
end; |
3790 |
– |
|
3791 |
– |
procedure SetExtendedProperties; |
3792 |
– |
var i: integer; |
3793 |
– |
IBFieldDef: TIBFieldDef; |
3794 |
– |
begin |
3795 |
– |
for i := 0 to Fields.Count - 1 do |
3796 |
– |
if Fields[i].FieldNo > 0 then |
3797 |
– |
begin |
3798 |
– |
if(Fields[i] is TIBStringField) then |
3799 |
– |
with TIBStringField(Fields[i]) do |
3800 |
– |
begin |
3801 |
– |
IBFieldDef := GetFieldDef(FieldNo); |
3802 |
– |
if IBFieldDef <> nil then |
3803 |
– |
begin |
3804 |
– |
CharacterSetSize := IBFieldDef.CharacterSetSize; |
3805 |
– |
CharacterSetName := IBFieldDef.CharacterSetName; |
3806 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
3807 |
– |
CodePage := IBFieldDef.CodePage; |
3808 |
– |
{$ENDIF} |
3809 |
– |
end; |
3810 |
– |
end |
3811 |
– |
else |
3812 |
– |
if(Fields[i] is TIBMemoField) then |
3813 |
– |
with TIBMemoField(Fields[i]) do |
3814 |
– |
begin |
3815 |
– |
IBFieldDef := GetFieldDef(FieldNo); |
3816 |
– |
if IBFieldDef <> nil then |
3817 |
– |
begin |
3818 |
– |
CharacterSetSize := IBFieldDef.CharacterSetSize; |
3819 |
– |
CharacterSetName := IBFieldDef.CharacterSetName; |
3820 |
– |
{$IFDEF HAS_ANSISTRING_CODEPAGE} |
3821 |
– |
CodePage := IBFieldDef.CodePage; |
3822 |
– |
{$ENDIF} |
3823 |
– |
end; |
3824 |
– |
end |
3825 |
– |
end |
3826 |
– |
end; |
3827 |
– |
|
4233 |
|
begin |
4234 |
|
FBase.SetCursor; |
4235 |
|
try |
4239 |
|
IBError(ibxeEmptyQuery, [nil]); |
4240 |
|
if not FInternalPrepared then |
4241 |
|
InternalPrepare; |
4242 |
< |
if FQSelect.SQLType = SQLSelect then |
4242 |
> |
if FQSelect.SQLStatementType = SQLSelect then |
4243 |
|
begin |
4244 |
|
if DefaultFields then |
4245 |
|
CreateFields; |
4246 |
+ |
FArrayFieldCount := 0; |
4247 |
|
BindFields(True); |
3842 |
– |
SetExtendedProperties; |
4248 |
|
FCurrentRecord := -1; |
4249 |
|
FQSelect.ExecQuery; |
4250 |
|
FOpen := FQSelect.Open; |
4255 |
|
3. After the dummy fetch, FRecordSize will be appropriately |
4256 |
|
adjusted to reflect the additional "weight" of the field |
4257 |
|
data. |
4258 |
< |
4. Set up the FCalcFieldsOffset, FBlobCacheOffset and FRecordBufferSize. |
4258 |
> |
4. Set up the FCalcFieldsOffset, FBlobCacheOffset, FArrayCacheOffset and FRecordBufferSize. |
4259 |
|
5. Now, with the BufferSize available, allocate memory for chunks of records |
4260 |
|
6. Re-allocate the model buffer, accounting for the new |
4261 |
|
FRecordBufferSize. |
4262 |
|
7. Finally, calls to AllocRecordBuffer will work!. |
4263 |
|
} |
4264 |
|
{Step 1} |
4265 |
< |
FRecordSize := RecordDataLength(FQSelect.Current.Count); |
4265 |
> |
FRecordSize := RecordDataLength(FQSelect.FieldCount); |
4266 |
|
{Step 2, 3} |
4267 |
+ |
GetMem(FFieldColumns,sizeof(TFieldColumns) * (FQSelect.FieldCount)); |
4268 |
|
IBAlloc(FModelBuffer, 0, FRecordSize); |
4269 |
< |
FetchCurrentRecordToBuffer(FQSelect, -1, FModelBuffer); |
4269 |
> |
InitModelBuffer(FQSelect, FModelBuffer); |
4270 |
|
{Step 4} |
4271 |
|
FCalcFieldsOffset := FRecordSize; |
4272 |
|
FBlobCacheOffset := FCalcFieldsOffset + CalcFieldsSize; |
4273 |
< |
FRecordBufferSize := (FBlobCacheOffset + (BlobFieldCount * SizeOf(TIBBlobStream))); |
4273 |
> |
FArrayCacheOffset := (FBlobCacheOffset + (BlobFieldCount * SizeOf(TIBBlobStream))); |
4274 |
> |
FRecordBufferSize := FArrayCacheOffset + (ArrayFieldCount * sizeof(IArray)); |
4275 |
|
{Step 5} |
4276 |
|
if UniDirectional then |
4277 |
|
FBufferChunkSize := FRecordBufferSize * UniCache |
4287 |
|
FCacheSize := FBufferChunkSize; |
4288 |
|
FOldCacheSize := FBufferChunkSize; |
4289 |
|
{Step 6} |
4290 |
< |
IBAlloc(FModelBuffer, RecordDataLength(FQSelect.Current.Count), |
4290 |
> |
IBAlloc(FModelBuffer, RecordDataLength(FQSelect.FieldCount), |
4291 |
|
FRecordBufferSize); |
4292 |
|
{Step 7} |
4293 |
|
FOldBuffer := AllocRecordBuffer; |
4385 |
|
function TIBCustomDataSet.Locate(const KeyFields: string; const KeyValues: Variant; |
4386 |
|
Options: TLocateOptions): Boolean; |
4387 |
|
var |
3981 |
– |
{$IFDEF NEW_TBOOKMARK } |
4388 |
|
CurBookmark: TBookmark; |
3983 |
– |
{$ELSE} |
3984 |
– |
CurBookmark: string; |
3985 |
– |
{$ENDIF} |
4389 |
|
begin |
4390 |
|
DisableControls; |
4391 |
|
try |
4403 |
|
const ResultFields: string): Variant; |
4404 |
|
var |
4405 |
|
fl: TList; |
4003 |
– |
{$IFDEF NEW_TBOOKMARK } |
4406 |
|
CurBookmark: TBookmark; |
4005 |
– |
{$ELSE} |
4006 |
– |
CurBookmark: string; |
4007 |
– |
{$ENDIF} |
4407 |
|
begin |
4408 |
|
DisableControls; |
4409 |
|
fl := TList.Create; |
4476 |
|
MappedFieldPos := FMappedFieldPosition[Field.FieldNo - 1]; |
4477 |
|
if (MappedFieldPos > 0) and |
4478 |
|
(MappedFieldPos <= rdFieldCount) then |
4479 |
+ |
with rdFields[MappedFieldPos], FFieldColumns^[MappedFieldPos] do |
4480 |
|
begin |
4481 |
|
Field.Validate(Buffer); |
4482 |
|
if (Buffer = nil) or |
4483 |
|
(Field is TIBStringField) and (PChar(Buffer)[0] = #0) then |
4484 |
< |
rdFields[MappedFieldPos].fdIsNull := True |
4485 |
< |
else begin |
4486 |
< |
Move(Buffer^, Buff[rdFields[MappedFieldPos].fdDataOfs], |
4487 |
< |
rdFields[MappedFieldPos].fdDataSize); |
4488 |
< |
if (rdFields[MappedFieldPos].fdDataType = SQL_TEXT) or |
4489 |
< |
(rdFields[MappedFieldPos].fdDataType = SQL_VARYING) then |
4490 |
< |
rdFields[MappedFieldPos].fdDataLength := StrLen(PChar(Buffer)); |
4091 |
< |
rdFields[MappedFieldPos].fdIsNull := False; |
4484 |
> |
fdIsNull := True |
4485 |
> |
else |
4486 |
> |
begin |
4487 |
> |
Move(Buffer^, Buff[fdDataOfs],fdDataSize); |
4488 |
> |
if (fdDataType = SQL_TEXT) or (fdDataType = SQL_VARYING) then |
4489 |
> |
fdDataLength := StrLen(PChar(Buffer)); |
4490 |
> |
fdIsNull := False; |
4491 |
|
if rdUpdateStatus = usUnmodified then |
4492 |
|
begin |
4493 |
|
if CachedUpdates then |
4588 |
|
if FInternalPrepared then |
4589 |
|
begin |
4590 |
|
CheckDatasetClosed; |
4591 |
+ |
if FDidActivate then |
4592 |
+ |
DeactivateTransaction; |
4593 |
|
FieldDefs.Clear; |
4594 |
|
FieldDefs.Updated := false; |
4595 |
|
FInternalPrepared := False; |
4610 |
|
IBError(ibxeEmptyQuery, [nil]); |
4611 |
|
if not FInternalPrepared then |
4612 |
|
InternalPrepare; |
4613 |
< |
if FQSelect.SQLType = SQLSelect then |
4613 |
> |
if FQSelect.SQLStatementType = SQLSelect then |
4614 |
|
begin |
4615 |
|
IBError(ibxeIsASelectStatement, [nil]); |
4616 |
|
end |
4623 |
|
end; |
4624 |
|
end; |
4625 |
|
|
4626 |
< |
function TIBCustomDataSet.GetSelectStmtHandle: TISC_STMT_HANDLE; |
4626 |
> |
function TIBCustomDataSet.GetSelectStmtIntf: IStatement; |
4627 |
|
begin |
4628 |
< |
Result := FQSelect.Handle; |
4628 |
> |
Result := FQSelect.Statement; |
4629 |
|
end; |
4630 |
|
|
4631 |
|
function TIBCustomDataSet.GetParser: TSelectSQLParser; |
4680 |
|
|
4681 |
|
{ TIBDataSet IProviderSupport } |
4682 |
|
|
4683 |
< |
(*procedure TIBCustomDataSet.PSEndTransaction(Commit: Boolean); |
4683 |
> |
procedure TIBCustomDataSet.PSEndTransaction(Commit: Boolean); |
4684 |
|
begin |
4685 |
|
if Commit then |
4686 |
|
Transaction.Commit else |
4833 |
|
Transaction.StartTransaction; |
4834 |
|
end; |
4835 |
|
|
4836 |
< |
function TIBCustomDataSet.PSGetTableName: string; |
4836 |
> |
function TIBCustomDataSet.PsGetTableName: string; |
4837 |
|
begin |
4838 |
|
// if not FInternalPrepared then |
4839 |
|
// InternalPrepare; |
4843 |
|
if not FQSelect.Prepared then |
4844 |
|
FQSelect.Prepare; |
4845 |
|
Result := FQSelect.UniqueRelationName; |
4846 |
< |
end;*) |
4846 |
> |
end; |
4847 |
|
|
4848 |
|
procedure TIBDataSet.BatchInput(InputObject: TIBBatchInput); |
4849 |
|
begin |
4974 |
|
inherited Destroy; |
4975 |
|
end; |
4976 |
|
|
4977 |
< |
procedure TIBDataSetUpdateObject.SetRefreshSQL(Value: TStrings); |
4977 |
> |
procedure TIBDataSetUpdateObject.SetRefreshSQL(value: TStrings); |
4978 |
|
begin |
4979 |
|
FRefreshSQL.Assign(Value); |
4980 |
|
end; |
4981 |
|
|
4982 |
+ |
procedure TIBDataSetUpdateObject.InternalSetParams(Params: ISQLParams; |
4983 |
+ |
buff: PChar); |
4984 |
+ |
begin |
4985 |
+ |
if not Assigned(DataSet) then Exit; |
4986 |
+ |
DataSet.SetInternalSQLParams(Params, buff); |
4987 |
+ |
end; |
4988 |
+ |
|
4989 |
|
procedure TIBDataSetUpdateObject.InternalSetParams(Query: TIBSQL; buff: PChar); |
4990 |
|
begin |
4991 |
+ |
InternalSetParams(Query.Params,buff); |
4992 |
+ |
end; |
4993 |
+ |
|
4994 |
+ |
procedure TIBDataSetUpdateObject.UpdateRecordFromQuery(QryResults: IResults; |
4995 |
+ |
Buffer: PChar); |
4996 |
+ |
begin |
4997 |
|
if not Assigned(DataSet) then Exit; |
4998 |
< |
DataSet.SetInternalSQLParams(Query, buff); |
4998 |
> |
DataSet.UpdateRecordFromQuery(QryResults, Buffer); |
4999 |
|
end; |
5000 |
|
|
5001 |
|
function TIBDSBlobStream.GetSize: Int64; |