Questions tagged [tadoquery]
119 questions
0
votes
1 answer
TDataSet->Cancel() still allowing Post to proceed
I am in a BeforePost event handler hoping to cancel the post before it goes through. At the end of my BeforePost function I call DataSet->Cancel(); and when debugging through this I see it go from my function to the TDataSet.DoBeforePost function…
user912447
- 696
- 1
- 11
- 31
0
votes
1 answer
ClientDataSet only partially transferring data from TADOQuery
I have two databases and I need to ensure that all records in one database have a matching record in the other. I will call these DB-SQL and DB-Legacy
This would be easy enough if both had an SQL interface, but unfortunately I only have this type of…
Matt Allwood
- 1,448
- 12
- 25
0
votes
2 answers
Delphi2005 - Using TADOQuery Results in another method
Because of code redundancy I generalized the usual ADOQuery handling into a method of its own, with the method returning the _RecordSet of the query.
Now, when I check the query results inside that method, they check out alright. But the returned…
Ben
- 99
- 1
- 7
0
votes
1 answer
How to insert value into the Excel file using ADO?
I'm using the following code to insert value in the Excel file:
sAppend:='INSERT INTO ["Excel 8.0;Database=' + Edit1.Text + ';"].[Sheet1$] (d) ' + FormatDateTime('d/m/yyyy', now)+';';
AdoQuery1.SQL.Text:=sAppend;
AdoQuery1.ExecSQL;
Previous routine…
bojan gavrilovic
- 167
- 5
- 13
0
votes
1 answer
how to show parent category in delphi 2010?
OK, I'm using Embarcadero Delphi 2010. Currently I'm using an Access database file named flib.mdb within that file, I make a table named MCategory which has 4 (four) columns named: codecategory as Text and Primary Key, parentcategory as Text,…
Galvion
- 1,353
- 7
- 23
- 35
-1
votes
1 answer
missing operator or semicolon error message
hi ive got an SQL with the following code,
SELECT SUM (Travel_Cost)
FROM Travel
WHERE Job_ID=:mcode
in order to allow the user to enter a value from an edit component which is passed to the SQL i have got the following code aswell,
procedure…
Jeowkes
- 501
- 7
- 20
-1
votes
1 answer
SQL query updates then revertes changes
I'm currently baffled by the one problem. I can insert and delete records from my table but I can't update certain fields. It does update it temporarily before reverting changes 0.5 seconds later, I physically see the change. Btw this is done in…
-1
votes
1 answer
How to coding patient search app in Delphi?
I'm working on a patient search app. I have a problem with ADOQuery.Active which does not deactivate when I delete a word in the search bar.
This is my code:
unit Unit1;
interface
uses
Winapi.Windows, Winapi.Messages, System.SysUtils,…
PATHOFF
- 11
-1
votes
1 answer
ADOQuery TimeOut with try except
I have an ADOQuery and a ADOConnection on the form , the simplified code looks like this :
on Form.Create I simply give ADOConnection the connection parameters and make sure it is closed.
After this I never open ADOConnection directly , it happens…
user1937012
- 1,031
- 11
- 20
-1
votes
1 answer
incompatible types: widestring and tintegerfield
Does anyone know what this happens?
I have declared all my database objects as integers as well as my dataset objects as integer
when I run my ado query, I get values, from here, im trying to assign it as to a dataset, which is also declared as…
Fly
- 43
- 1
- 8
-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
2 answers
HOW TO Using ADOQuery sum in Delphi
I have this SQL query:
As you can see, it works fine. Except when I use it in Delphi.
I use TDBLookupComboBox, TEdit, and TButton. My idea is, whenever I click on the TButton, the EXE goes to check the table in SQL using information in the…
azera
- 3
- 2
-2
votes
1 answer
Delphi 7 object undefinedat
I have a web service that I have created using Delphi and I want to connect to sql server with it so I have added to the project an ADO Connection and ADOQuery had both of them configured and ready to use, there was only a small problem, there are…
user2414726
- 51
- 4
-4
votes
1 answer
Syntax error. in query expression -Delphi
I have following query and face error and i am Using XE8 with MS Access
Syntax error. in query expression 'select CCarID from tblcar where Car = (LX008)'
Procedure TFNewCarAct.BtnSaveClick(Sender:…
Munir
- 15
- 3