tdataset is the base class for all dataset components. Defined in the DB.pas unit, it represents data in rows and columns.
Questions tagged [tdataset]
55 questions
0
votes
0 answers
how to use TDataset.AfterPost to log all changes to data?
I would like to log all the changes posted in a dataset Post event by looping through the changes in tdataset.afterpost event.
I use dataaware controls and i would like to store the changes done by a user.
My goal is to do it for all datasets in my…
UnDiUdin
- 14,924
- 39
- 151
- 249
0
votes
0 answers
Delphi - DataSet creating too many connections in MySQL
I am having a problem using the TFDDataSet component in my application.
I have a function that fetch many times if a customer has new orders. If it returns empty the function ends.
...
fdm_XMLREsumo.Close;
fdm_XMLREsumo.Active := false;
…
henrique romao
- 560
- 1
- 8
- 32
0
votes
2 answers
How to read field values of a TDataSet descendant without having to move its cursor
I see having the ability to read record values from a TDataSet descendant without having to move the cursor is a big improvement for people working with database applications.
I have searched long and hard on this topic but the closest I can find…
Loc Nguyen
- 21
- 3
0
votes
3 answers
Return no records if FIndKey results in False?
Using TDataSet.FindKey you can locate records. When it results in True the datasets cursor will be positioned on the found record.
I use this when I select items in a list on the left, corresponding data should appear on the right.
When it results…
jwilfong
- 45
- 1
- 5
0
votes
1 answer
How can I get access to Delphi's TField.DisplayText from _Recordset ADO interface?
I have passed TDataSet.Recordset: _Recordset interface using COM method outside the application. But I see there a wild DB data. How can I get access to Delphi's TField.DisplayText from _Recordset ADO interface? (TField.DisplayText shows data after…
Dmitry
- 14,306
- 23
- 105
- 189
0
votes
1 answer
TDataset thread races with DBGrid
I made TDataset descendant asynchronous, instead of sleep or ProcessMessages in main thread it works by events from network thread. So when Recordset is ready it calls
procedure TMySqlQuery.OrdinalOnDataReady(Sender: TObject);
begin
…
user2091150
- 978
- 12
- 25
0
votes
2 answers
RecordCount with UniDAC Dataset component
I'm using the TUniQuery component from UniDAC. I'd like to show how many records I have, so
I've put the following code to show in a Status Bar:
procedure TForm1.unyQuery1AfterFetch(DataSet: TCustomDADataSet);
begin
StatusBar1.Panels[1].Text :=…
Daniel Grillo
- 2,368
- 4
- 37
- 62
0
votes
1 answer
How to create a simple READ-ONLY TDataSet to access a memory structure
I have a memory structure which is (pretty much) static and read-only. I would like to present its data as a TDataSet descendent to enable me to use DB grids etc to view / report the data. I have no need of editing (in fact this must be prohibited).…
Brian Frost
- 13,334
- 11
- 80
- 154
-1
votes
1 answer
Delphi Database default value error
(SQL Server 2012, Delphi XE2, DataSet, DBGrid and adoquery)
I have a simple table with these columns:
id entering, exiting, description
entering and exiting the field to get the default value of 0
These defaults when creating the new record does…
cArf
- 81
- 1
- 5
-2
votes
1 answer
Access violation error when executing TDataSet's Next method
When looking to move the pointer on to the next record, an error message is shown that says:
Access violation at address 004070E2 in module 'main_p.exe'. Write of
address 00000000
Any way of resolving this?
var
i: integer;
begin
with…
Philip Ellis
- 53
- 1
- 5