Questions tagged [tadodataset]
25 questions
1
vote
1 answer
Delphi and ADODataset.Cancel
I'm using Dephi 10.1 Berlin and Access 2013.
My problem is related to TADODataSet.Cancel().
I want to show my user a message box asking for a confirmation before posting, in case data has been modified.
In the TADODataSet.BeforePost event, I added…
Alverio
- 11
- 1
1
vote
0 answers
How to get Image displayed in DBWPRichText component which inturn connected to Memotype Field?
I am working with Client server architecture in Delphi with SQL server 2014 as the database.
I have a database fieldname "Document" that is of type "Text" which contains rtf data which contains an image data. I am using ado dataset which gets the…
mano
- 308
- 3
- 19
1
vote
1 answer
Issue with TADODataSet on Delphi 10.1 Berlin. Query hangs
I am trying to operate an TADODataSet in a program on Delphi 10.1 Berlin
Here is my code:
rsGrid.Connection := MyADOConn;
rsGrid.CommandType := cmdText;
rsGrid.CommandText := 'my_StoredProc 100';
rsGrid.IndexName := 'ObjectID';
rsGrid.Active :=…
Interface Unknown
- 713
- 10
- 26
1
vote
2 answers
how to export TADODataSet with Fields Texts not Fields Values
I have a TADODataSet connected with a stored procedure which produce 40 Columns * 800 Row
the TADODataSet has an AfterOpen event which assign an OnGetText for it is Fields
like :
procedure TForm1.ADODataSet1AfterOpen(DataSet: TDataSet);
begin
with…
user1512094
- 611
- 2
- 10
- 23
0
votes
0 answers
How can I use the Locate Method of a TADODataSet with non-ASCII data in Delphi 10.3
I have an MS SQL Server 2019 table that has a column named "Char" and it is defined as nvarchar(4).
In my sample Delphi 10.3.3 code, I have a line that says:
found := ADODataSet1.Locate('Char', '⓪', []);
There is no record in the table with such a…
Kevin Davidson
- 131
- 8
0
votes
0 answers
How to check the availability of the TADODataSet in a dbgrid?
I use a DBGrid on my VCL Form. The grid is populated with the records, coming from a TADOConnection query. Semantically it looks like this:
Establish a connection to the database (SQL Server);
Fetch some records into a TADODataSet dataset;
Connect…
Interface Unknown
- 713
- 10
- 26
0
votes
1 answer
Error using TADODataset component with MS Access
I am attempting to replace a InterBase DB with a MS Access DB as a test, I am connect to the MS Access DB using the TADOConnection component successfully; however when I try to connect to a table using the TADODataset, I am able to set the…
Cliff Crerar
- 433
- 8
- 24
0
votes
1 answer
It does not work in ADODataSet IndexDef?
I am creating a persistent index ADODataSet but not order information, my code is as follows:
ADODataSetInforArtic.IndexDefs.Clear;
case ComboBoxOrden.AsValue of
0: begin
with ADODataSetInforArtic.IndexDefs.AddIndexDef do
begin
…
jmontegrosso
- 89
- 1
- 11
0
votes
1 answer
Destroying TADODataset created in runtime
I have a function that returns a TADODataset object:
// inside DataModule:
function TDM.GetWorkstationsList: TADODataset;
var
DS: TADODataSet;
begin
DS := TADODataSet.Create(nil);
DS.Connection := MyConnection; // MyConnection is…
Vasiliy Volkov
- 745
- 8
- 10
0
votes
4 answers
"either bof or eof is true or the current record has been deleted.." error on applyupdates that contains a delete operation
I am getting this error while resolving delete operation from ClientDatset to TAdoDataset (which bound to access table). I am using Delphi 2010.
My DatasetProvider between TClientDataset and TAdoDataset :
object dspTarifeler: TDataSetProvider
…
Serguzest
- 1,287
- 10
- 18