Regards, I have this problem for a long time and I solved it by not using the DESC clause in ORDER BY of a MySql query, but unfortunately right now it is mandatory, I use an xBrowse with TDolphin that contains a query with 3 tables related to LEFT JOIN, until But when I use the xBrowse and click on the heads containing the fields for which I make the LEFT JOIN, then I get this error message "Error MYSQL / 1052 Column 'id_provee' in order clause is ambiguous", in The other columns does the ordering without problems, now if I remove the DESC of the query, everything works well in all the columns, nor idea of how to solve this problem. I leave the code used, from now, thanks for the suggestions and answers, greetings ... thanks ...: shock:
CONSULTA MYSQL / TDolphin
- Code: Select all Expand view RUN
cSql := "SELECT cm.id_provee, pv.provee_nombres, cm.com_num_fac, "
cSql += "cm.com_fch_fac, cm.com_peso_kilo, cm.com_unidades "
cSql += "FROM ge_pollos_compras_master AS cm "
cSql += "LEFT JOIN ge_pollos_compras_detalles AS cd ON cm.id_provee = cd.id_provee "
cSql += "AND cm.com_num_fac = cd.com_num_fac "
cSql += "LEFT JOIN ge_provee_master AS pv ON cm.id_provee = pv.id_provee "
cSql += "GROUP BY cm.id_compra_mas "
cSql += "ORDER BY cm.com_fch_fac DESC" // SI QUITO "DESC" TRABAJA TODO BIEN
XBrowse / TDolphin
- Code: Select all Expand view RUN
REDEFINE XBROWSE aBrw[2] ID 100 OF oFldx:aDialogs[2] ;
DATASOURCE oQryComPro ;
LINES CELL AUTOSORT AUTOCOLS ;
HEADERS "Cod.", "Nombre Proveedores", "Factura", "Fecha", "Kilos Compra" ,;
"Cant.Piezas";
COLUMNS "id_provee", "provee_nombres", "com_num_fac", "com_fch_fac" ,;
"com_peso_kilo", "com_unidades" ;
COLSIZES 50, 200, 50, 70, 80, 80 ;
JUSTIFY 2, , 2, 2 ;
PICTURES , , , , oPi:nKg1, oPi:nPi5
