Hi,

I tried to search for an answer to this but couldn't find the problem.

I have a grid which i populate with a select command on my ms sql table.

If I take the full content of the table it works fine, but if i add the WHERE clause then only the last line is selectable and if i delete this line all the lines will be deleted.

I redid the table to add a id column just to try having unique values in the first column.

The following line is the working one:

$gr->select_command = "SELECT id, ref_NO_CLIENT, ref_NO_RUBRIQUE, DESCRIPTION_FR, SEQUENCE FROM Cli_Rub INNER JOIN ATCQ_RUBRIQUES ON Cli_Rub.ref_NO_RUBRIQUE = ATCQ_RUBRIQUES.NO_RUBRIQUE";

And now the line that mess things up: ($CLE contains the NO_CLIENT)

$gr->select_command = "SELECT id, ref_NO_CLIENT, ref_NO_RUBRIQUE, DESCRIPTION_FR, SEQUENCE FROM Cli_Rub INNER JOIN ATCQ_RUBRIQUES ON Cli_Rub.ref_NO_RUBRIQUE = ATCQ_RUBRIQUES.NO_RUBRIQUE WHERE id LIKE '$CLE%'";

Any help figuring why just adding this would mess things up would be appreciated.

Thanks