FiveTech Support Forums

Hi,

I have a problem in a Query syntax while converting my program from SQLite to MySQL.
In the table 'factui' there is a numeric field 'factuurnr'

In SQLite the command

oQry=oSQL:Query( 'SELECT SUBSTR(factuurnr,1,4) FROM factui DESC GROUP BY SUBSTR(factuurnr,1,4)' )

is working fine, but in MySQL I get a syntax error.
Does anyone know how to make this query in MySQL?

Thanks,
Marc

Problem solved,

It sould be

oQry=oSQL:Query( 'SELECT SUBSTR(factuurnr,1,4) FROM factui GROUP BY SUBSTR(factuurnr,1,4) DESC' )

The HeidiSQL program that comes with MarioDB is a very nice program vor cheching the database and query...

Marc