Stack Overflow
Stack Overflow

Questions tagged [tadoquery]

119 questions
2
votes
1 answer

TADOQuery: 'EDatabaseError type mismatch for field 'MyField', expecting: String actual: FixedWideChar'

I have 3 different databases (development, homolog and prod), each of them in one of the following Oracle versions: 11g and 10g. I'm using a TADOQuery to query for some data in only one of those databases at a time. When I run my app in dev or prod…
gustavogbc
  • 695
  • 11
  • 33
2
votes
1 answer

Data type mismatch in criteria expression when changing adoquery.active

i have the following query SELECT * FROM Project WHERE Status = "In Progress" when i run the program it successfully lists all the project titles with the status 'In Progress' in a DBlookuplistbox, I have a button with the code:…
Jeowkes
  • 501
  • 7
  • 20
1
vote
0 answers

How do I pass a parameter to a TADO query

I am writing a script using Pascal in our ERP system. I am connecting to a MS Access database which has two tables. TIMESHEETHEADER and TIMESHEETLINES. I have a query that is reading from the database. I would like to pass some variables to the…
Simon King
  • 165
  • 2
  • 17
1
vote
1 answer

Can't query a string from an SQL table

I am trying to pass the value of a group from the database into a TEdit when an item is selected in a TComboBox. However, the value returned should be a string, not an integer. In the text field for the group, the value returned is 0. Can anyone…
Nur Atikah
  • 31
  • 3
1
vote
1 answer

Error on Quoted String within ADOQuery in Delphi: `Parameter object is improperly defined. Inconsistent or incomplete information was provided.`

I am having trouble with below ADOQuery quoted string %ABC%: adoQuery1.SQL.Clear; adoQuery1.SQL.Text := 'SELECT * FROM MyDB.MyTable WHERE MyField LIKE ''''%ABC%'''' '; adoQuery1.ExecSQL; adoQuery1.Close; adoQuery1.Open; I also tried to pass below…
RickyBelmont
  • 619
  • 4
  • 11
1
vote
2 answers

How can i import data/information values from databases and display them into labels captions?

What I'm using for my database (all connected together): ADOConnection1, ADOQuery1, DataSource1, MS-Access, Delphi 10.3 I'm trying to get the values(of all types, mostly strings) from my Database (that's on ms access Database) and put them to text…
Charles stealth
  • 61
  • 7
1
vote
0 answers

Datasnap how does it handle multiple Clients

I have a really simple DataSnap Server and a Android Datasnap client . The Server itself is configured with default values. Only the Port and IP was changed. I have on the Server in the ServerContainer form a ADOQuery and a DataSetProvider. I also…
user1937012
  • 1,031
  • 11
  • 20
1
vote
1 answer

Leave Update Query Value Unchanged with ADOQuery and Delphi 10.2

I have a Interface between 2 systems that exchange data between each other. This is a default interface that could be modified by GUI, for example you can choose between using a group of fields on both sides, or you can choose to leave the value as…
fisi-pjm
  • 378
  • 2
  • 16
1
vote
1 answer

How can I use multiple TcxDBTextEdit with formatted data stored in a single DB field?

I have a need to store two values in a single database field (yes, I agree that it is bad practice, but this is a legacy database that can't be altered). The data is stored as string1#4string2. The data needs to be edited using two separate…
Magnus
  • 17,157
  • 19
  • 104
  • 189
1
vote
2 answers

Working with TADOQuery in thread

I'm writing the application, which connects to the DB and repetitively (1 minute interval) reads the data from a database. It's something like RSS feed reader, but with local DB. If the data reading fails, I try to reestablish the connection. I've…
user532231
1
vote
1 answer

Can I get all records from one speciefic field with single command?

I have a database *.mdb. The task is to get all the values from a certain field of this database and write them to a file. Now the code looks something like this while not ADOQuery1.Eof do begin …
Anton
  • 21
  • 1
1
vote
1 answer

TADOQuery returns empty recordset in second execution

I have quite an incredible situation using a TADOQuery against an MS Access database. In the following code (just a test case), the first execution of the query returns the correct record, the second execution instead returns an "empty" record (i.e.…
Stefano Losi
  • 719
  • 7
  • 18
1
vote
1 answer

Delphi, ADOQuery,ClientDataSet

I want save ClientDataSet to file and then open this file in AdoQuery (AdoQuery.LoadFromFile()). Is it possible? Or how can I save dataset to pfADTG file format? Best regards Pawel
Paweł Rzońca
  • 53
  • 4
1
vote
0 answers

Ado Query in Delphi 7 To Converts Joined Columns Into Rows Based on Primary Key

I'm using delphi 7 and ado query to connect to an access database with three tables All the tables are related by Primary Key, i'm using the following query using ado query to get the three tables in one single row and it works fine :…
Aliana Donovan
  • 71
  • 1
  • 6
1
vote
1 answer

getting the checked nodes from tcxtreelist

I have a tcxtreelist Does anyone know how to get all the checkedNodes? I need to go through my tcxtreelist get a certain value from the tcxtreelist and write it to a string with comma delimited Anyone can help me with this? Thanks Kind Regards
Fly
  • 43
  • 1
  • 8
1 2
3
4 5 6 7 8