Delphi dbexpress MySQL query format

Question

I am using Delphi 2010 dbexpress components to connect to my MySQL database. I am facing a problem executing this query.

  SQLQuery1.SQL.Clear;
  SQLQuery1.SQL.Add('Select ForNo,Description from fortab');
  SQLQuery1.Open;

It gives me an error saying
DBX Error :Unsupported field type.
now if I have the only 1 field in the query it will work fine i.e.

Select Description from fortab;

or

Select ForNo from fortab;  

fortab structure 
    ForNo: int(10) unsigned  NOT NULL, Primary key
    Description: varchar(45) NOT NULL,
    ENGINE=InnoDB DEFAULT CHARSET=latin1;

Can anyone specify me the proper format of retrieving multiple fields from the table?
Or is it that I will have to write individual queries for each field?

Can you post the definition of your table? It's hard to say what your problem might be without it. What are the column names and data types? — Ken White
– Ken White, Commented Feb 17, 2012 at 5:01
What is int(10)? I don't use MySQL, but an int should be an int, and shouldn't need a width specifier. Are you sure that's right? — Ken White
– Ken White, Commented Feb 17, 2012 at 5:15

Johan · Accepted Answer · 2012-02-17 10:46:21Z

1

Can anyone specify me the proper format of retrieving multiple fields from the table?

SELECT field1, field2, field3 FROM atable
WHERE field1 > 100
ORDER BY field1

answered Feb 17, 2012 at 10:46

Johan

77.4k28 gold badges204 silver badges346 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Shirish11 Over a year ago

I know but its not working for me. I have tried the same query using BDE and MyDAC it works fine but when it comes to dbExpress it fails. Have also tried the same in BDS 2006 but no success.

Collectives™ on Stack Overflow

Delphi dbexpress MySQL query format

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related