Questions tagged [tadoquery]
119 questions
0
votes
1 answer
Delphi TADOQuery.next skipping a record
Description of the application/processing
I'm maintaining some old code in Delphi XE. The application runs a query on a database on a remote server, and then creates a report on the PC. We've had a bug report that some data in one of the fields is…
Jeedee
- 548
- 5
- 24
0
votes
1 answer
Delphi 2007 - I want to Read an .html file's content and then using ADO Insert or Update a SQL Server 2008 table with the HTML content
I read the data line by line or stream it into a String (cHTML) then using a TADOQuery I use a simple Update or insert query
UPDATE Tablename
Set cFieldName = cHTML,
Where a = b
The cHTML is basically the HTML file's contents
The errors I get are…
user1787988
- 31
- 4
0
votes
2 answers
2 TADOQUERY master and Detail tablefilter insert
How can i work with 2 Tadoquery and work like a Tadoquery (master) Tadotable(detail) !!
var tempvar : Variant;
begin
Edit1.text:=Ano.value;
Begin
with Ano_planeamento do //Laço de consulta por codigo
…
ml.
- 163
- 1
- 4
- 15
0
votes
1 answer
Temp table over multiple ADOQueries
Is there a way to make multiple TADOQuery have access to the same session or transaction information?
Both TADOQuery have the same TADOCOnnection, but that doesn't work.
Example - I have one query that generates a temp table, I want to use that temp…
runfastman
- 927
- 2
- 11
- 31
0
votes
2 answers
Indy Server and AdoQuery are conflicting
I have two programs one is a client the other is a server for the client.
The client sends some data to the server like this and then reads the response:
idtcpclient1.WriteLn(command); //Command contains data that the server needs eg. name and…
Craig
- 548
- 9
- 24
0
votes
1 answer
Delphi: Fields of TADOQuery invoked in another module suddenly have default values
I have two datamodules in an application: TPAymentDataModule and TJobEditDataModule. In one DataModule I have to invoke a certain TADOQuery from the other module to update the database:
(This piece of code is in TPaymentDataModule):
procedure…
AunAun
- 1,423
- 2
- 14
- 25
0
votes
0 answers
Multiple tables in SELECT query
I'm trying to select columns from multiple tables. Here's the code I have:
SELECT
Sum(IIf((tblChain.InitialZone="1"),1,0)) AS SCCH,
tblStatHistory.HomeTeam,
Sum(IIf(([Pentagraph]="HANDB") Or ([Pentagraph]="HANBB") Or ([Pentagraph]="HBCL")…
Brodie Messenger
- 11
- 3
0
votes
1 answer
Delphi displays question marks when reading from MS Access
I installed a new Windows 7 on my computer.
I have a delphi 7 application that is using TAdoQuery to select from MS Access data from a table that has hebrew letter.
In Access the data is saved okay.
The system Locale is having Hebrew as the…
Avraham Cohen
- 57
- 5
0
votes
1 answer
Cant find column but it exist
hi im working on delphi 10 and sybase.
Im having this issue 2 days ago and i've tried a lot of things.
i set the adoconnection properties in build, searh my db and its ready. I can insert,delete and update but when im trying to make a select x from…
Jose Valverde
- 19
- 1
- 3
- 9
0
votes
3 answers
TADOQuery filter and an expression always true
I am trying to filter some records from a TADOQuery. I set the filtered property to true and when I set the filter to field='value', all works fine. I would like to dynamically build this filter by appending
AND field='value'
to a value…
Peter Perháč
- 20,434
- 21
- 120
- 152
0
votes
2 answers
TADOQuery and TADOConnection memory leak
I use C++ Builder XE3. In windows service we have IdTCP server on ( Indy TCP Server ) in function tcp_serverExecute(TIdContext *AContext) - which as I understand spawn new thread.
I create TADOConnection and TADOQuery ( after I call CoInitialize )…
Oleg
- 9
- 2
0
votes
0 answers
Delphi 2005 freezes where entering a sql line
I've a problem that I'm not able to solve.
I've a project in delphi 2005 and I created a form by copying an old one, editing its name and programming the changes I want.
The application works fine, but when I'm writting source code and I enter into…
davidrgh
- 853
- 2
- 10
- 17
0
votes
1 answer
SQL syntax error
I want to run a simple SQL from Delphi 2007.
I use AdoQuery. My table has a column id and data type is int (autoincrement).
My question is if I execute
select * from comlist
there is no problem, it runs. But if I define a field on SQL like
select…
Hakan Subaşı
- 61
- 6
0
votes
1 answer
Multiline parameter in Delphi7 TAdoQuery
With Delphi 7 and SQL Server 2005 I'm trying to pass a multiline parameter (a Stringlist.text) to a TAdoQuery insert script.
The insert is successful, but when i take back data from the field, i take
Line 1 Line 2 Line 3
instead of
Line 1
Line…
Giorgio Forti
- 131
- 2
- 14
0
votes
2 answers
Receiving data from an SQL table in Delphi
I have a form which needs to fetch and display data from a MYSQL database.
The SQL code which I have written works fine, as I have tried to execute it within MYSQL.
I have also used a similar format of code to the one in my form, within another…
Babah254
- 13
- 4
- 9