Devart Forums

Sorry if this is horribly newbie, but I am writing my very first real app using MySQl and Mydaq (4.00.1.6) I have a DBgrid, connected to a TmyTable,
There is a record in a table called calibration from which I want to extract which is denoted by the maximum value in a certain field, and display only that in the grid.

I tested what I want manually in SQL, and I can get the required dataset with this
select * from calibration where cal_reference_id= (select max (cal_reference_id) from calibration);

but any SQL I put in the filterSQL field of Tmytable which contains this MAX function creates an error #45000 FUNCTION not found uhtvisc.max

(Uhtvisc is the database in question)

I would be very grateful for any help I can get at this point - its the first time I have tried to use any DB programming in a Delphi app.

Thanks

Steve[/b]

Well just remove the space after the MAX:

GEswin wrote:Well just remove the space after the MAX:

Code: Select all

select * from calibration where cal_reference_id= (select max(cal_reference_id) from calibration);

Thanks for your comment. It helps quite a bit, yet that is still invalid SQL, according to Delphi, when entered into the filterSQL property when the code is run.

Funnily enough, the original SQL shown was copied directly from the MySQL CLI when I tested what I wanted to do, and of course it worked fine there.

As SQL in a Tmyquery object though, it works fine as well.

Anyway, you have definitely got me accelerating up the learning curve.

Thanks again
Steve

Well in FilterSQL afaik you only have to put the WHERE part, without the where... it would be:
But as you say, using TmyQuery solved the problem ,and i can suggest you better use TmyQuery on most cases, except when you want to see all table (TMyTable is a wrapper of TMyQuery).

Regards

GEswin wrote: But as you say, using TmyQuery solved the problem ,and i can suggest you better use TmyQuery on most cases, except when you want to see all table (TMyTable is a wrapper of TMyQuery).

Pieter,
Thank you very much for your help. I have finally moved off the start blocks.
Steve