ViewVC Help

View File | Revision Log | Show Annotations | Download File | View Changeset | Root Listing

root/public/ibx/trunk/runtime/IBQuery.pas

Comparing ibx/trunk/runtime/IBQuery.pas (file contents):
Revision 19 by tony, Mon Jul 7 13:00:15 2014 UTC vs.
Revision 45 by tony, Tue Dec 6 10:33:46 2016 UTC

#	Line 1 | Line 1
1	<	{************************************************************************}
2	<	{                                                                        }
3	<	{       Borland Delphi Visual Component Library                          }
4	<	{       InterBase Express core components                                }
5	<	{                                                                        }
6	<	{       Copyright (c) 1998-2000 Inprise Corporation                      }
7	<	{                                                                        }
8	<	{    InterBase Express is based in part on the product                   }
9	<	{    Free IB Components, written by Gregory H. Deatz for                 }
10	<	{    Hoagland, Longo, Moran, Dunst & Doukas Company.                     }
11	<	{    Free IB Components is used under license.                           }
12	<	{                                                                        }
13	<	{    The contents of this file are subject to the InterBase              }
14	<	{    Public License Version 1.0 (the "License"); you may not             }
15	<	{    use this file except in compliance with the License. You            }
16	<	{    may obtain a copy of the License at http://www.Inprise.com/IPL.html }
17	<	{    Software distributed under the License is distributed on            }
18	<	{    an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either              }
19	<	{    express or implied. See the License for the specific language       }
20	<	{    governing rights and limitations under the License.                 }
21	<	{    The Original Code was created by InterBase Software Corporation     }
22	<	{       and its successors.                                              }
23	<	{    Portions created by Inprise Corporation are Copyright (C) Inprise   }
24	<	{       Corporation. All Rights Reserved.                                }
25	<	{    Contributor(s): Jeff Overcash                                       }
26	<	{                                                                        }
27	<	{    IBX For Lazarus (Firebird Express)                                  }
28	<	{    Contributor: Tony Whyman, MWA Software http://www.mwasoftware.co.uk }
29	<	{    Portions created by MWA Software are copyright McCallum Whyman      }
30	<	{    Associates Ltd 2011                                                 }
31	<	{                                                                        }
32	<	{************************************************************************}
33	<
34	<	unit IBQuery;
35	<
36	<	interface
37	<
38	<	{$Mode Delphi}
39	<
40	<	uses
41	<	{$IFDEF WINDOWS }
42	<	Windows,
43	<	{$ELSE}
44	<	unix,
45	<	{$ENDIF}
46	<	SysUtils, Graphics, Classes, Controls, Db,
47	<	IBHeader, IB, IBCustomDataSet, IBSQL;
48	<
49	<	type
50	<
51	<	{ TIBQuery }
52	<
53	<	TIBQuery = class(TIBCustomDataSet)
54	<	private
55	<	FSQL: TStrings;
56	<	FPrepared: Boolean;
57	<	FParams: TParams;
58	<	FText: string;
59	<	FRowsAffected: Integer;
60	<	FCheckRowsAffected: Boolean;
61	<	function GetRowsAffected: Integer;
62	<	procedure PrepareSQL(Value: PChar);
63	<	procedure QueryChanged(Sender: TObject);
64	<	procedure ReadParamData(Reader: TReader);
65	<	procedure SetQuery(Value: TStrings);
66	<	procedure SetParamsList(Value: TParams);
67	<	procedure SetParams;
68	<	procedure SetParamsFromCursor;
69	<	procedure SetPrepared(Value: Boolean);
70	<	procedure SetPrepare(Value: Boolean);
71	<	procedure WriteParamData(Writer: TWriter);
72	<	function GetStmtHandle: TISC_STMT_HANDLE;
73	<
74	<	protected
75	<	{ IProviderSupport }
76	<	(*    procedure PSExecute; override;
77	<	function PSGetParams: TParams; override;
78	<	function PSGetTableName: string; override;
79	<	procedure PSSetCommandText(const CommandText: string); override;
80	<	procedure PSSetParams(AParams: TParams); override;  *)
81	<
82	<	procedure DefineProperties(Filer: TFiler); override;
83	<	procedure InitFieldDefs; override;
84	<	procedure InternalOpen; override;
85	<	procedure Disconnect; override;
86	<	function GetParamsCount: Word;
87	<	function GenerateQueryForLiveUpdate : Boolean;
88	<	procedure SetFiltered(Value: Boolean); override;
89	<
90	<	public
91	<	constructor Create(AOwner: TComponent); override;
92	<	destructor Destroy; override;
93	<	procedure BatchInput(InputObject: TIBBatchInput);
94	<	procedure BatchOutput(OutputObject: TIBBatchOutput);
95	<	procedure ExecSQL;
96	<	procedure GetDetailLinkFields(MasterFields, DetailFields: TList);(* override;*)
97	<	function ParamByName(const Value: string): TParam;
98	<	procedure Prepare;
99	<	procedure UnPrepare;
100	<	property Prepared: Boolean read FPrepared write SetPrepare;
101	<	property ParamCount: Word read GetParamsCount;
102	<	property StmtHandle: TISC_STMT_HANDLE read GetStmtHandle;
103	<	property StatementType;
104	<	property Text: string read FText;
105	<	property RowsAffected: Integer read GetRowsAffected;
106	<	//   property Params: TParams read FParams write SetParamsList;
107	<
108	<	published
109	<	property Active;
110	<	property BufferChunks;
111	<	property CachedUpdates;
112	<	property DataSource read GetDataSource write SetDataSource;
113	<	property GenerateParamNames;
114	<	//   property Constraints stored ConstraintsStored;
115	<	property GeneratorField;
116	<	property ParamCheck;
117	<	property SQL: TStrings read FSQL write SetQuery;
118	<	property Params: TParams read FParams write SetParamsList;
119	<	property UniDirectional default False;
120	<	property UpdateObject;
121	<	property Filtered;
122	<
123	<	property BeforeDatabaseDisconnect;
124	<	property AfterDatabaseDisconnect;
125	<	property DatabaseFree;
126	<	property BeforeTransactionEnd;
127	<	property AfterTransactionEnd;
128	<	property TransactionFree;
129	<	property OnFilterRecord;
130	<	end;
131	<
132	<	implementation
133	<
134	<	{ TIBQuery }
135	<
136	<	constructor TIBQuery.Create(AOwner: TComponent);
137	<	begin
138	<	inherited Create(AOwner);
139	<	FSQL := TStringList.Create;
140	<	TStringList(SQL).OnChange := QueryChanged;
141	<	FParams := TParams.Create(Self);
142	<	ParamCheck := True;
143	<	FRowsAffected := -1;
144	<	end;
145	<
146	<	destructor TIBQuery.Destroy;
147	<	begin
148	<	Destroying;
149	<	Disconnect;
150	<	SQL.Free;
151	<	FParams.Free;
152	<	inherited Destroy;
153	<	end;
154	<
155	<	procedure TIBQuery.InitFieldDefs;
156	<	begin
157	<	inherited InitFieldDefs;
158	<	end;
159	<
160	<	procedure TIBQuery.InternalOpen;
161	<	begin
162	<	ActivateConnection();
163	<	ActivateTransaction;
164	<	QSelect.GenerateParamNames := GenerateParamNames;
165	<	SetPrepared(True);
166	<	if DataSource <> nil then
167	<	SetParamsFromCursor;
168	<	SetParams;
169	<	inherited InternalOpen;
170	<	end;
171	<
172	<	procedure TIBQuery.Disconnect;
173	<	begin
174	<	Close;
175	<	UnPrepare;
176	<	end;
177	<
178	<	procedure TIBQuery.SetPrepare(Value: Boolean);
179	<	begin
180	<	if Value then
181	<	Prepare
182	<	else
183	<	UnPrepare;
184	<	end;
185	<
186	<	procedure TIBQuery.Prepare;
187	<	begin
188	<	SetPrepared(True);
189	<	end;
190	<
191	<	procedure TIBQuery.UnPrepare;
192	<	begin
193	<	SetPrepared(False);
194	<	end;
195	<
196	<	procedure TIBQuery.SetQuery(Value: TStrings);
197	<	begin
198	<	if SQL.Text <> Value.Text then
199	<	begin
200	<	Disconnect;
201	<	SQL.BeginUpdate;
202	<	try
203	<	SQL.Assign(Value);
204	<	finally
205	<	SQL.EndUpdate;
206	<	end;
207	<	end;
208	<	end;
209	<
210	<	procedure TIBQuery.QueryChanged(Sender: TObject);
211	<	var
212	<	List: TParams;
213	<	begin
214	<	if not (csReading in ComponentState) then
215	<	begin
216	<	Disconnect;
217	<	if ParamCheck or (csDesigning in ComponentState) then
218	<	begin
219	<	List := TParams.Create(Self);
220	<	try
221	<	FText := List.ParseSQL(SQL.Text, True);
222	<	List.AssignValues(FParams);
223	<	FParams.Clear;
224	<	FParams.Assign(List);
225	<	finally
226	<	List.Free;
227	<	end;
228	<	end else
229	<	FText := SQL.Text;
230	<	DataEvent(dePropertyChange, 0);
231	<	end else
232	<	FText := FParams.ParseSQL(SQL.Text, true);
233	<	SelectSQL.Assign(SQL);
234	<	end;
235	<
236	<	procedure TIBQuery.SetParamsList(Value: TParams);
237	<	begin
238	<	FParams.AssignValues(Value);
239	<	end;
240	<
241	<	function TIBQuery.GetParamsCount: Word;
242	<	begin
243	<	Result := FParams.Count;
244	<	end;
245	<
246	<	procedure TIBQuery.DefineProperties(Filer: TFiler);
247	<
248	<	function WriteData: Boolean;
249	<	begin
250	<	{The following results in a stream read error with nested frames. Hence commented out until
251	<	someone fixes the LCL }
252	<	{    if Filer.Ancestor <> nil then
253	<	Result := not FParams.IsEqual(TIBQuery(Filer.Ancestor).FParams) else}
254	<	Result := FParams.Count > 0;
255	<	end;
256	<
257	<	begin
258	<	inherited DefineProperties(Filer);
259	<	Filer.DefineProperty('ParamData', ReadParamData, WriteParamData, WriteData); {do not localize}
260	<	end;
261	<
262	<	procedure TIBQuery.ReadParamData(Reader: TReader);
263	<	begin
264	<	FParams.Clear;
265	<	Reader.ReadValue;
266	<	Reader.ReadCollection(FParams);
267	<	end;
268	<
269	<	procedure TIBQuery.WriteParamData(Writer: TWriter);
270	<	begin
271	<	Writer.WriteCollection(Params);
272	<	end;
273	<
274	<	procedure TIBQuery.SetPrepared(Value: Boolean);
275	<	begin
276	<	CheckDatasetClosed;
277	<	if Value <> Prepared then
278	<	begin
279	<	if Value then
280	<	begin
281	<	FRowsAffected := -1;
282	<	FCheckRowsAffected := True;
283	<	if Length(Text) > 1 then PrepareSQL(PChar(Text))
284	<	else IBError(ibxeEmptySQLStatement, [nil]);
285	<	end
286	<	else
287	<	begin
288	<	if FCheckRowsAffected then
289	<	FRowsAffected := RowsAffected;
290	<	InternalUnPrepare;
291	<	end;
292	<	FPrepared := Value;
293	<	end;
294	<	end;
295	<
296	<	procedure TIBQuery.SetParamsFromCursor;
297	<	var
298	<	I: Integer;
299	<	DataSet: TDataSet;
300	<	Field: TField;
301	<
302	<	procedure CheckRequiredParams;
303	<	var
304	<	I: Integer;
305	<	begin
306	<	for I := 0 to FParams.Count - 1 do
307	<	with FParams[I] do
308	<	if not Bound then
309	<	IBError(ibxeRequiredParamNotSet, [nil]);
310	<	end;
311	<
312	<	begin
313	<	if DataSource <> nil then
314	<	begin
315	<	DataSet := DataSource.DataSet;
316	<	if DataSet <> nil then
317	<	begin
318	<	DataSet.FieldDefs.Update;
319	<	for I := 0 to FParams.Count - 1 do
320	<	if not FParams[I].Bound then
321	<	begin
322	<	Field := DataSet.FindField(FParams[I].Name);
323	<	if assigned(Field) then
324	<	begin
325	<	FParams[I].AssignField(Field);
326	<	FParams[I].Bound := False;
327	<	end;
328	<	end;
329	<	end
330	<	else
331	<	CheckRequiredParams;
332	<	end
333	<	else
334	<	CheckRequiredParams;
335	<	end;
336	<
337	<
338	<	function TIBQuery.ParamByName(const Value: string): TParam;
339	<	begin
340	<	Result := FParams.ParamByName(Value);
341	<	end;
342	<
343	<	procedure TIBQuery.BatchInput(InputObject: TIBBatchInput);
344	<	begin
345	<	InternalBatchInput(InputObject);
346	<	end;
347	<
348	<	procedure TIBQuery.BatchOutput(OutputObject: TIBBatchOutput);
349	<	begin
350	<	InternalBatchOutput(OutputObject);
351	<	end;
352	<
353	<	procedure TIBQuery.ExecSQL;
354	<	var
355	<	DidActivate: Boolean;
356	<	begin
357	<	CheckInActive;
358	<	if SQL.Count <= 0 then
359	<	begin
360	<	FCheckRowsAffected := False;
361	<	IBError(ibxeEmptySQLStatement, [nil]);
362	<	end;
363	<	ActivateConnection();
364	<	DidActivate := ActivateTransaction;
365	<	try
366	<	SetPrepared(True);
367	<	if DataSource <> nil then SetParamsFromCursor;
368	<	if FParams.Count > 0 then SetParams;
369	<	InternalExecQuery;
370	<	finally
371	<	if DidActivate then
372	<	DeactivateTransaction;
373	<	FCheckRowsAffected := True;
374	<	end;
375	<	end;
376	<
377	<	procedure TIBQuery.SetParams;
378	<
379	<	var
380	<	i : integer;
381	<	Buffer: Pointer;
382	<
383	<	begin
384	<	for I := 0 to FParams.Count - 1 do
385	<	begin
386	<	if Params[i].IsNull then
387	<	SQLParams[i].IsNull := True
388	<	else begin
389	<	SQLParams[i].IsNull := False;
390	<	case Params[i].DataType of
391	<	ftBytes:
392	<	begin
393	<	GetMem(Buffer,Params[i].GetDataSize);
394	<	try
395	<	Params[i].GetData(Buffer);
396	<	SQLParams[i].AsPointer := Buffer;
397	<	finally
398	<	FreeMem(Buffer);
399	<	end;
400	<	end;
401	<	ftString:
402	<	SQLParams[i].AsString := Params[i].AsString;
403	<	ftBoolean, ftSmallint, ftWord:
404	<	SQLParams[i].AsShort := Params[i].AsSmallInt;
405	<	ftInteger:
406	<	SQLParams[i].AsLong := Params[i].AsInteger;
407	<	ftLargeInt:
408	<	SQLParams[i].AsInt64 := Params[i].AsLargeInt;
409	<	ftFloat:
410	<	SQLParams[i].AsDouble := Params[i].AsFloat;
411	<	ftBCD, ftCurrency:
412	<	SQLParams[i].AsCurrency := Params[i].AsCurrency;
413	<	ftDate:
414	<	SQLParams[i].AsDate := Params[i].AsDateTime;
415	<	ftTime:
416	<	SQLParams[i].AsTime := Params[i].AsDateTime;
417	<	ftDateTime:
418	<	SQLParams[i].AsDateTime := Params[i].AsDateTime;
419	<	ftBlob, ftMemo:
420	<	SQLParams[i].AsString := Params[i].AsString;
421	<	else
422	<	IBError(ibxeNotSupported, [nil]);
423	<	end;
424	<	end;
425	<	end;
426	<	end;
427	<
428	<	procedure TIBQuery.PrepareSQL(Value: PChar);
429	<	begin
430	<	QSelect.GenerateParamNames := GenerateParamNames;
431	<	InternalPrepare;
432	<	end;
433	<
434	<
435	<	function TIBQuery.GetRowsAffected: Integer;
436	<	begin
437	<	Result := -1;
438	<	if Prepared then
439	<	Result := QSelect.RowsAffected
440	<	end;
441	<
442	<
443	<	procedure TIBQuery.GetDetailLinkFields(MasterFields, DetailFields: TList);
444	<
445	<	function AddFieldToList(const FieldName: string; DataSet: TDataSet;
446	<	List: TList): Boolean;
447	<	var
448	<	Field: TField;
449	<	begin
450	<	Field := DataSet.FindField(FieldName);
451	<	if (Field <> nil) then
452	<	List.Add(Field);
453	<	Result := Field <> nil;
454	<	end;
455	<
456	<	var
457	<	i: Integer;
458	<	begin
459	<	MasterFields.Clear;
460	<	DetailFields.Clear;
461	<	if (DataSource <> nil) and (DataSource.DataSet <> nil) then
462	<	for i := 0 to Params.Count - 1 do
463	<	if AddFieldToList(Params[i].Name, DataSource.DataSet, MasterFields) then
464	<	AddFieldToList(Params[i].Name, Self, DetailFields);
465	<	end;
466	<
467	<	function TIBQuery.GetStmtHandle: TISC_STMT_HANDLE;
468	<	begin
469	<	Result := SelectStmtHandle;
470	<	end;
471	<
472	<	function TIBQuery.GenerateQueryForLiveUpdate : Boolean;
473	<	begin
474	<	Result := False;
475	<	end;
476	<
477	<	procedure TIBQuery.SetFiltered(Value: Boolean);
478	<	begin
479	<	if(Filtered <> Value) then
480	<	begin
481	<	inherited SetFiltered(value);
482	<	if Active then
483	<	begin
484	<	Close;
485	<	Open;
486	<	end;
487	<	end
488	<	else
489	<	inherited SetFiltered(value);
490	<	end;
491	<
492	<	{ TIBQuery IProviderSupport }
493	<	(*
494	<	function TIBQuery.PSGetParams: TParams;
495	<	begin
496	<	Result := Params;
497	<	end;
498	<
499	<	procedure TIBQuery.PSSetParams(AParams: TParams);
500	<	begin
501	<	if AParams.Count <> 0 then
502	<	Params.Assign(AParams);
503	<	Close;
504	<	end;
505	<
506	<	function TIBQuery.PSGetTableName: string;
507	<	begin
508	<	Result := inherited PSGetTableName;
509	<	end;
510	<
511	<	procedure TIBQuery.PSExecute;
512	<	begin
513	<	ExecSQL;
514	<	end;
515	<
516	<	procedure TIBQuery.PSSetCommandText(const CommandText: string);
517	<	begin
518	<	if CommandText <> '' then
519	<	SQL.Text := CommandText;
520	<	end;
521	<	*)
522	<	end.
523	<
1	>	{************************************************************************}
2	>	{                                                                        }
3	>	{       Borland Delphi Visual Component Library                          }
4	>	{       InterBase Express core components                                }
5	>	{                                                                        }
6	>	{       Copyright (c) 1998-2000 Inprise Corporation                      }
7	>	{                                                                        }
8	>	{    InterBase Express is based in part on the product                   }
9	>	{    Free IB Components, written by Gregory H. Deatz for                 }
10	>	{    Hoagland, Longo, Moran, Dunst & Doukas Company.                     }
11	>	{    Free IB Components is used under license.                           }
12	>	{                                                                        }
13	>	{    The contents of this file are subject to the InterBase              }
14	>	{    Public License Version 1.0 (the "License"); you may not             }
15	>	{    use this file except in compliance with the License. You            }
16	>	{    may obtain a copy of the License at http://www.Inprise.com/IPL.html }
17	>	{    Software distributed under the License is distributed on            }
18	>	{    an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either              }
19	>	{    express or implied. See the License for the specific language       }
20	>	{    governing rights and limitations under the License.                 }
21	>	{    The Original Code was created by InterBase Software Corporation     }
22	>	{       and its successors.                                              }
23	>	{    Portions created by Inprise Corporation are Copyright (C) Inprise   }
24	>	{       Corporation. All Rights Reserved.                                }
25	>	{    Contributor(s): Jeff Overcash                                       }
26	>	{                                                                        }
27	>	{    IBX For Lazarus (Firebird Express)                                  }
28	>	{    Contributor: Tony Whyman, MWA Software http://www.mwasoftware.co.uk }
29	>	{    Portions created by MWA Software are copyright McCallum Whyman      }
30	>	{    Associates Ltd 2011                                                 }
31	>	{                                                                        }
32	>	{************************************************************************}
33	>
34	>	unit IBQuery;
35	>
36	>	interface
37	>
38	>	{$Mode Delphi}
39	>
40	>	uses
41	>	{$IFDEF WINDOWS }
42	>	Windows,
43	>	{$ELSE}
44	>	unix,
45	>	{$ENDIF}
46	>	SysUtils, Classes,  Db,
47	>	IBHeader, IB, IBCustomDataSet, IBSQL, IBSQLParser;
48	>
49	>	type
50	>
51	>	{ TIBQuery }
52	>
53	>	TIBQuery = class(TIBParserDataSet)
54	>	private
55	>	FSQL: TStrings;
56	>	FPrepared: Boolean;
57	>	FParams: TParams;
58	>	FText: string;
59	>	FRowsAffected: Integer;
60	>	FCheckRowsAffected: Boolean;
61	>	FSQLUpdating: boolean;
62	>	FInQueryChanged: boolean;
63	>	function GetRowsAffected: Integer;
64	>	procedure PrepareSQL;
65	>	procedure QueryChanged(Sender: TObject);
66	>	procedure ReadParamData(Reader: TReader);
67	>	procedure SetQuery(Value: TStrings);
68	>	procedure SetParamsList(Value: TParams);
69	>	procedure SetParams;
70	>	procedure SetParamsFromCursor;
71	>	procedure SetPrepared(Value: Boolean);
72	>	procedure SetPrepare(Value: Boolean);
73	>	procedure WriteParamData(Writer: TWriter);
74	>	function GetStmtHandle: IStatement;
75	>	procedure UpdateSQL;
76	>
77	>	protected
78	>	{ IProviderSupport }
79	>	(*    procedure PSExecute; override;
80	>	function PSGetParams: TParams; override;
81	>	function PSGetTableName: string; override;
82	>	procedure PSSetCommandText(const CommandText: string); override;
83	>	procedure PSSetParams(AParams: TParams); override;  *)
84	>
85	>	procedure DefineProperties(Filer: TFiler); override;
86	>	procedure InitFieldDefs; override;
87	>	procedure InternalOpen; override;
88	>	procedure Disconnect; override;
89	>	function GetParamsCount: Word;
90	>	function GenerateQueryForLiveUpdate : Boolean;
91	>	procedure SetFiltered(Value: Boolean); override;
92	>	procedure SQLChanged(Sender: TObject); override;
93	>	procedure SQLChanging(Sender: TObject); override;
94	>
95	>	public
96	>	constructor Create(AOwner: TComponent); override;
97	>	destructor Destroy; override;
98	>	procedure BatchInput(InputObject: TIBBatchInput);
99	>	procedure BatchOutput(OutputObject: TIBBatchOutput);
100	>	procedure ExecSQL;
101	>	procedure GetDetailLinkFields(MasterFields, DetailFields: TList);(* override;*)
102	>	function ParamByName(const Value: string): TParam;
103	>	procedure Prepare;
104	>	procedure UnPrepare;
105	>	procedure ResetParser; override;
106	>	property Prepared: Boolean read FPrepared write SetPrepare;
107	>	property ParamCount: Word read GetParamsCount;
108	>	property StmtHandle: IStatement read GetStmtHandle;
109	>	property StatementType;
110	>	property Text: string read FText;
111	>	property RowsAffected: Integer read GetRowsAffected;
112	>	//   property Params: TParams read FParams write SetParamsList;
113	>	property BaseSQLSelect;
114	>
115	>	published
116	>	property Active;
117	>	property AutoCommit;
118	>	property BufferChunks;
119	>	property CachedUpdates;
120	>	property DataSource read GetDataSource write SetDataSource;
121	>	property GenerateParamNames;
122	>	//   property Constraints stored ConstraintsStored;
123	>	property GeneratorField;
124	>	property ParamCheck;
125	>	property SQL: TStrings read FSQL write SetQuery;
126	>	property Params: TParams read FParams write SetParamsList;
127	>	property UniDirectional default False;
128	>	property UpdateObject;
129	>	property Filtered;
130	>	property DataSetCloseAction;
131	>
132	>	property BeforeDatabaseDisconnect;
133	>	property AfterDatabaseDisconnect;
134	>	property DatabaseFree;
135	>	property BeforeTransactionEnd;
136	>	property AfterTransactionEnd;
137	>	property TransactionFree;
138	>	property OnFilterRecord;
139	>	property OnValidatePost;
140	>	end;
141	>
142	>	implementation
143	>
144	>	uses FBMessages;
145	>
146	>	{ TIBQuery }
147	>
148	>	constructor TIBQuery.Create(AOwner: TComponent);
149	>	begin
150	>	inherited Create(AOwner);
151	>	FSQL := TStringList.Create;
152	>	TStringList(SQL).OnChange := QueryChanged;
153	>	FParams := TParams.Create(Self);
154	>	ParamCheck := True;
155	>	FRowsAffected := -1;
156	>	end;
157	>
158	>	destructor TIBQuery.Destroy;
159	>	begin
160	>	Destroying;
161	>	Disconnect;
162	>	SQL.Free;
163	>	FParams.Free;
164	>	inherited Destroy;
165	>	end;
166	>
167	>	procedure TIBQuery.InitFieldDefs;
168	>	begin
169	>	inherited InitFieldDefs;
170	>	end;
171	>
172	>	procedure TIBQuery.InternalOpen;
173	>	begin
174	>	ActivateConnection();
175	>	ActivateTransaction;
176	>	QSelect.GenerateParamNames := GenerateParamNames;
177	>	SetPrepared(True);
178	>	if DataSource <> nil then
179	>	SetParamsFromCursor;
180	>	SetParams;
181	>	inherited InternalOpen;
182	>	end;
183	>
184	>	procedure TIBQuery.Disconnect;
185	>	begin
186	>	Close;
187	>	UnPrepare;
188	>	end;
189	>
190	>	procedure TIBQuery.SetPrepare(Value: Boolean);
191	>	begin
192	>	if Value then
193	>	Prepare
194	>	else
195	>	UnPrepare;
196	>	end;
197	>
198	>	procedure TIBQuery.Prepare;
199	>	begin
200	>	SetPrepared(True);
201	>	end;
202	>
203	>	procedure TIBQuery.UnPrepare;
204	>	begin
205	>	SetPrepared(False);
206	>	end;
207	>
208	>	procedure TIBQuery.ResetParser;
209	>	begin
210	>	inherited ResetParser;
211	>	UpdateSQL;
212	>	end;
213	>
214	>	procedure TIBQuery.SetQuery(Value: TStrings);
215	>	begin
216	>	if SQL.Text <> Value.Text then
217	>	begin
218	>	Disconnect;
219	>	SQL.BeginUpdate;
220	>	try
221	>	SQL.Assign(Value);
222	>	finally
223	>	SQL.EndUpdate;
224	>	end;
225	>	end;
226	>	end;
227	>
228	>	procedure TIBQuery.QueryChanged(Sender: TObject);
229	>	begin
230	>	if FInQueryChanged then Exit;
231	>	FInQueryChanged := true;
232	>	try
233	>	if not (csReading in ComponentState) then
234	>	begin
235	>	Disconnect;
236	>	if csDesigning in ComponentState then
237	>	FText := FParams.ParseSQL(SQL.Text, true)
238	>	else
239	>	FText := SQL.Text;
240	>	DataEvent(dePropertyChange, 0);
241	>	end else
242	>	FText := FParams.ParseSQL(SQL.Text, true);
243	>
244	>	if not FSQLUpdating then
245	>	begin
246	>	Prepared := false;
247	>	SelectSQL.Assign(SQL);
248	>	end;
249	>	finally
250	>	FInQueryChanged := false;
251	>	end;
252	>	end;
253	>
254	>	procedure TIBQuery.SetParamsList(Value: TParams);
255	>	begin
256	>	FParams.AssignValues(Value);
257	>	end;
258	>
259	>	function TIBQuery.GetParamsCount: Word;
260	>	begin
261	>	Result := FParams.Count;
262	>	end;
263	>
264	>	procedure TIBQuery.DefineProperties(Filer: TFiler);
265	>
266	>	function WriteData: Boolean;
267	>	begin
268	>	{The following results in a stream read error with nested frames. Hence commented out until
269	>	someone fixes the LCL }
270	>	{    if Filer.Ancestor <> nil then
271	>	Result := not FParams.IsEqual(TIBQuery(Filer.Ancestor).FParams) else}
272	>	Result := FParams.Count > 0;
273	>	end;
274	>
275	>	begin
276	>	inherited DefineProperties(Filer);
277	>	Filer.DefineProperty('ParamData', ReadParamData, WriteParamData, WriteData); {do not localize}
278	>	end;
279	>
280	>
281	>	procedure TIBQuery.ReadParamData(Reader: TReader);
282	>	begin
283	>	FParams.Clear;
284	>	Reader.ReadValue;
285	>	Reader.ReadCollection(FParams);
286	>	end;
287	>
288	>	procedure TIBQuery.WriteParamData(Writer: TWriter);
289	>	begin
290	>	Writer.WriteCollection(Params);
291	>	end;
292	>
293	>	procedure TIBQuery.SetPrepared(Value: Boolean);
294	>	begin
295	>	CheckDatasetClosed;
296	>	if Value <> Prepared then
297	>	begin
298	>	if Value then
299	>	begin
300	>	FRowsAffected := -1;
301	>	FCheckRowsAffected := True;
302	>	if Length(Text) > 1 then PrepareSQL
303	>	else IBError(ibxeEmptySQLStatement, [nil]);
304	>	end
305	>	else
306	>	begin
307	>	if FCheckRowsAffected then
308	>	FRowsAffected := RowsAffected;
309	>	InternalUnPrepare;
310	>	FParams.Clear;
311	>	end;
312	>	FPrepared := Value;
313	>	end;
314	>	end;
315	>
316	>	procedure TIBQuery.SetParamsFromCursor;
317	>	var
318	>	I: Integer;
319	>	DataSet: TDataSet;
320	>	Field: TField;
321	>
322	>	procedure CheckRequiredParams;
323	>	var
324	>	I: Integer;
325	>	begin
326	>	for I := 0 to FParams.Count - 1 do
327	>	with FParams[I] do
328	>	if not Bound then
329	>	IBError(ibxeRequiredParamNotSet, [FParams[I].Name]);
330	>	end;
331	>
332	>	begin
333	>	if DataSource <> nil then
334	>	begin
335	>	DataSet := DataSource.DataSet;
336	>	if DataSet <> nil then
337	>	begin
338	>	DataSet.FieldDefs.Update;
339	>	for I := 0 to FParams.Count - 1 do
340	>	if not FParams[I].Bound then
341	>	begin
342	>	Field := DataSet.FindField(FParams[I].Name);
343	>	if assigned(Field) then
344	>	begin
345	>	FParams[I].AssignField(Field);
346	>	FParams[I].Bound := False;
347	>	end;
348	>	end;
349	>	end
350	>	else
351	>	CheckRequiredParams;
352	>	end
353	>	else
354	>	CheckRequiredParams;
355	>	end;
356	>
357	>
358	>	function TIBQuery.ParamByName(const Value: string): TParam;
359	>	begin
360	>	if not Prepared then
361	>	Prepare;
362	>	Result := FParams.ParamByName(Value);
363	>	end;
364	>
365	>	procedure TIBQuery.BatchInput(InputObject: TIBBatchInput);
366	>	begin
367	>	InternalBatchInput(InputObject);
368	>	end;
369	>
370	>	procedure TIBQuery.BatchOutput(OutputObject: TIBBatchOutput);
371	>	begin
372	>	InternalBatchOutput(OutputObject);
373	>	end;
374	>
375	>	procedure TIBQuery.ExecSQL;
376	>	var
377	>	DidActivate: Boolean;
378	>	begin
379	>	CheckInActive;
380	>	if SQL.Count <= 0 then
381	>	begin
382	>	FCheckRowsAffected := False;
383	>	IBError(ibxeEmptySQLStatement, [nil]);
384	>	end;
385	>	ActivateConnection();
386	>	DidActivate := ActivateTransaction;
387	>	try
388	>	SetPrepared(True);
389	>	if DataSource <> nil then SetParamsFromCursor;
390	>	if FParams.Count > 0 then SetParams;
391	>	InternalExecQuery;
392	>	finally
393	>	if DidActivate then
394	>	DeactivateTransaction;
395	>	FCheckRowsAffected := True;
396	>	end;
397	>	end;
398	>
399	>	procedure TIBQuery.SetParams;
400	>
401	>	var
402	>	i : integer;
403	>	Buffer: Pointer;
404	>	SQLParam: ISQLParam;
405	>
406	>	begin
407	>	for I := 0 to FParams.Count - 1 do
408	>	begin
409	>	SQLParam :=  SQLParams.ByName(Params[i].Name);
410	>	if Params[i].IsNull then
411	>	SQLParam.IsNull := True
412	>	else begin
413	>	SQLParam.IsNull := False;
414	>	case Params[i].DataType of
415	>	ftBytes:
416	>	begin
417	>	GetMem(Buffer,Params[i].GetDataSize);
418	>	try
419	>	Params[i].GetData(Buffer);
420	>	SQLParam.AsPointer := Buffer;
421	>	finally
422	>	FreeMem(Buffer);
423	>	end;
424	>	end;
425	>	ftString:
426	>	SQLParam.AsString := Params[i].AsString;
427	>	ftBoolean:
428	>	SQLParam.AsBoolean := Params[i].AsBoolean;
429	>	ftSmallint, ftWord:
430	>	SQLParam.AsShort := Params[i].AsSmallInt;
431	>	ftInteger:
432	>	SQLParam.AsLong := Params[i].AsInteger;
433	>	ftLargeInt:
434	>	SQLParam.AsInt64 := Params[i].AsLargeInt;
435	>	ftFloat:
436	>	SQLParam.AsDouble := Params[i].AsFloat;
437	>	ftBCD, ftCurrency:
438	>	SQLParam.AsCurrency := Params[i].AsCurrency;
439	>	ftDate:
440	>	SQLParam.AsDate := Params[i].AsDateTime;
441	>	ftTime:
442	>	SQLParam.AsTime := Params[i].AsDateTime;
443	>	ftDateTime:
444	>	SQLParam.AsDateTime := Params[i].AsDateTime;
445	>	ftBlob, ftMemo:
446	>	SQLParam.AsString := Params[i].AsString;
447	>	else
448	>	IBError(ibxeNotSupported, [nil]);
449	>	end;
450	>	end;
451	>	end;
452	>	end;
453	>
454	>	procedure TIBQuery.PrepareSQL;
455	>	var List: TParams;
456	>	begin
457	>	QSelect.GenerateParamNames := GenerateParamNames;
458	>	InternalPrepare;
459	>	UpdateSQL;
460	>	if ParamCheck  then
461	>	begin
462	>	List := TParams.Create(Self);
463	>	try
464	>	FText := List.ParseSQL(SQL.Text, True);
465	>	List.AssignValues(FParams);
466	>	FParams.Clear;
467	>	FParams.Assign(List);
468	>	finally
469	>	List.Free;
470	>	end;
471	>	end;
472	>	end;
473	>
474	>
475	>	function TIBQuery.GetRowsAffected: Integer;
476	>	begin
477	>	Result := -1;
478	>	if Prepared then
479	>	Result := QSelect.RowsAffected
480	>	end;
481	>
482	>
483	>	procedure TIBQuery.GetDetailLinkFields(MasterFields, DetailFields: TList);
484	>
485	>	function AddFieldToList(const FieldName: string; DataSet: TDataSet;
486	>	List: TList): Boolean;
487	>	var
488	>	Field: TField;
489	>	begin
490	>	Field := DataSet.FindField(FieldName);
491	>	if (Field <> nil) then
492	>	List.Add(Field);
493	>	Result := Field <> nil;
494	>	end;
495	>
496	>	var
497	>	i: Integer;
498	>	begin
499	>	MasterFields.Clear;
500	>	DetailFields.Clear;
501	>	if (DataSource <> nil) and (DataSource.DataSet <> nil) then
502	>	for i := 0 to Params.Count - 1 do
503	>	if AddFieldToList(Params[i].Name, DataSource.DataSet, MasterFields) then
504	>	AddFieldToList(Params[i].Name, Self, DetailFields);
505	>	end;
506	>
507	>	function TIBQuery.GetStmtHandle: IStatement;
508	>	begin
509	>	Result := SelectStmtHandle;
510	>	end;
511	>
512	>	procedure TIBQuery.UpdateSQL;
513	>	begin
514	>	if not FSQLUpdating and not FInQueryChanged and (SQL.Text <> SelectSQL.Text) then
515	>	begin
516	>	FSQLUpdating := true;
517	>	try
518	>	SQL.Text := SelectSQL.Text;
519	>	finally
520	>	FSQLUpdating := false
521	>	end;
522	>	end;
523	>	end;
524	>
525	>	function TIBQuery.GenerateQueryForLiveUpdate : Boolean;
526	>	begin
527	>	Result := False;
528	>	end;
529	>
530	>	procedure TIBQuery.SetFiltered(Value: Boolean);
531	>	begin
532	>	if(Filtered <> Value) then
533	>	begin
534	>	inherited SetFiltered(value);
535	>	if Active then
536	>	begin
537	>	Close;
538	>	Open;
539	>	end;
540	>	end
541	>	else
542	>	inherited SetFiltered(value);
543	>	end;
544	>
545	>	procedure TIBQuery.SQLChanged(Sender: TObject);
546	>	begin
547	>	inherited SQLChanged(Sender);
548	>	UpdateSQL;
549	>	end;
550	>
551	>	procedure TIBQuery.SQLChanging(Sender: TObject);
552	>	begin
553	>	inherited SQLChanging(Sender);
554	>	Prepared := false;
555	>	end;
556	>
557	>	{ TIBQuery IProviderSupport }
558	>	(*
559	>	function TIBQuery.PSGetParams: TParams;
560	>	begin
561	>	Result := Params;
562	>	end;
563	>
564	>	procedure TIBQuery.PSSetParams(AParams: TParams);
565	>	begin
566	>	if AParams.Count <> 0 then
567	>	Params.Assign(AParams);
568	>	Close;
569	>	end;
570	>
571	>	function TIBQuery.PSGetTableName: string;
572	>	begin
573	>	Result := inherited PSGetTableName;
574	>	end;
575	>
576	>	procedure TIBQuery.PSExecute;
577	>	begin
578	>	ExecSQL;
579	>	end;
580	>
581	>	procedure TIBQuery.PSSetCommandText(const CommandText: string);
582	>	begin
583	>	if CommandText <> '' then
584	>	SQL.Text := CommandText;
585	>	end;
586	>	*)
587	>	end.
588	>

Diff Legend

–	Removed lines
+	Added lines
<	Changed lines
>	Changed lines