Stack Overflow
Stack Overflow

Questions tagged [tadoquery]

119 questions
0
votes
2 answers

Only display fields selected in TCheckListBox in a DBGrid via SQL

So I have a TDBGrid that displays the content of a Query via SQL. I need to be able to only show the fields/columns that are selected in a TCheckListBox. How do I go about this problem? In this case the 'Lengte' field should not be included'
Janrich
  • 55
  • 1
  • 6
0
votes
0 answers

Delphi TadoQuery - Parameter type conversion

I send with Jquery and Ajax Parameters from the Webpage to my Delphi Webserver. Those Parameters will be used in the select, but as soon as i get to TADOQ.Open; i get a exception which contains the message bellow the code section. I'm new to Delphi,…
René
  • 1
  • 4
0
votes
1 answer

Delphi TADOQuery - change table fields definition leads to misbehaviour

I'm refactoring an existing Delphi VCL application, migrating the underlying DB from Access 97 (!!) to SQL Server 2014. In the process, we decided for a table to change some field definitions, in particular we changed the field 'Ora' type from…
Stefano Losi
  • 719
  • 7
  • 18
0
votes
1 answer

ADOQuery and DBNavigator

OK. I have simple Database ,DBGrid and DBNavigator . I use this code for my adoquery and view in this in my DBGrid select Count(*)As 1 , 2 3 from Table1 Group by 1, 2 The problem is that if i have two or more the same article from 1 and i try to…
Georgi Gavrilski
  • 31
  • 1
  • 1
  • 3
0
votes
1 answer

ADOQuery to save new and update record

I created one TForm to create new user into Access Database. I created DBedit1 which updates the Edit1 with change event. If enter totally new data into my TEdit files and press save with the insert into query it saves the data without any…
Fiaz
  • 30
  • 2
  • 9
0
votes
1 answer

Delphi 7 TAdoQuery too slow

I'm using Delphi 7 and SQL Server 2008. The connection is AdoConnection and the Query component I'm using is TAdoQuery. When i run the following simple query in sql server select FMStreamid, Latitude, Longitude, RealTime from tblFMStream where…
ppetkov
  • 47
  • 5
0
votes
1 answer

(Delphi) query.next not working

I need help to fix my code... I try to build some application with this code Adoquery.close; ADOQuery1.SQL.Clear; ADOQuery1.SQL.Add('select * from schedule where every like ''%5%'''); ADOQuery1.Open; if not ADOQuery1.Eof then begin …
Gigih Arie
  • 13
  • 2
0
votes
0 answers

Strange security bug SQL Server 2008 and Delphi 10 Seattle

I met strange security result on my Delphi 10 Seattle using SQL Server 2008. I need read-only DB access, so made dedicated r/o user; ADO connection string in TADOConnection uses its credentials. Test query select system_user shows its…
Sergey Ryvkin
  • 81
  • 7
0
votes
1 answer

Delphi ADO error "Multi-Step operation generated errors. check each status value" when opening DBF file with memo type

I'm building a simple delphi program to transfer data from dbf file into sql server. The dbf file it self contain a memo field which data is saved on .fpt file. When i try to open it with ADOQuery, when I tried to scroll down to the next row, I got…
ryuusoultaker
  • 69
  • 9
0
votes
0 answers

Data Refresh From Database when using TADOQuery, TClientDataSet, TDataSetProvider in Delphi

I have a TADOQuery connected to a database, and sql set to fetch data. TDataSetProvider to the above query TClientDataSet connected to the provider TDataSource connected to the Data set Data source connected to a TcxGrid The Client Data Set is also…
John Fowler
  • 1
  • 1
0
votes
1 answer

adoQuery Filter

Could you please provide me with a simple example of using the Filter Property of ADOQuery in Delphi 7? Thanks.
none
  • 4,669
  • 14
  • 62
  • 102
0
votes
2 answers

insert to a different table onNewRecord

got an ADOQuery that has OnNewRecord event. on the procedure i try to add data automaticaly to another table. the data is a few rows that are needed and handled in clientDataSet in case of cancellation. at the loc OtherAdoQuery.insert; I get error…
none
  • 4,669
  • 14
  • 62
  • 102
0
votes
1 answer

Populate ComboBox with Title Case Query Result

with TdmBCElections.Create(Self) do begin with dmBCElections, qryParties do begin SQL.Clear; if rgpParty.ItemIndex = 0 then SQL.Text := 'SELECT StrConv(P_Surname, 3), StrConv(P_Names, 3) ' + 'FROM Parties WHERE P_Type =…
Reginald Greyling
  • 363
  • 3
  • 19
0
votes
0 answers

Access violation, Delphi 2005 TADOQuery

I have a programme in Delphi 2005 which uses a TADOQuery component, CalQuery, in several places. The connection, CalCon, connects to an Access *.mdb file (created in Access 2003). It has been working fine until today when it suddenly stopped…
Matthew
  • 164
  • 1
  • 2
  • 10
0
votes
0 answers

Delphi7 TADOQuery filter not accurate at quick report

i want to show report with date range i have code procedure TForm1.ButtonPreviewClick(Sender: TObject); begin ... ADOQuery1.Active := False; ADOQuery1.SQL.Text:=''; ADOQuery1.SQL.Text :='SELECT * FROM tablename WHERE datefield…
Banned User
  • 9
  • 1
1 2 3 4 5
6
7 8