Topic: Print only a record of a Table Grid
here i am again. The problem I can't solve this time is on the code to print only one selected record on a Table Grid.
As an action on clicking a button (bPrintselected) I chose "Report (SQL). The button is found in the first form (frmStart) and is the one with the writing "Print selected".
This is the code I wrote while studying the sample projects:
SELECT Libro.record_count, Libro.Titolo, Libro.Autore, Libro.Editore, Libro.Anno, Genere.Genere, Tipo.Tipo, Libro.id FROM Libro LEFT OUTER JOIN Genere ON Genere.id=Libro.id_Genere LEFT OUTER JOIN Tipo ON Tipo.id=Libro.id_Tipo WHERE Genere.id=$id WHERE Tipo.id=$id
The highlighted errors are those of the following images. Thanks to all and a greeting.