Print only a record of a Table Grid (Page 1 of 2)

Hi

There cannot be two WHEREs in a SQL query and the condition is incorrectly defined.

Sample is good, but books (MVD, SQLite) need to be read.

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 Libro.id=$id

with sparrow's SQL solution

Hello, here i am again. I would like to know if it's possible change form caption of the ShowMessage istruction. I did a lot of searches but I found no informations about ShowMessage parameters. Thank you.

Hi Derek, I really liked your stylistic corrections and also the suggestions on what to avoid to make it more practical for the user instead of getting an error message don't make them do it. As always, your suggestions and directions are very valuable, in fact I'm getting many ideas from them.
Looking for the parameters for showmessage, I came across the messagedlg instruction but I understood that I had to write too much code, instead I saw and tried that with messagebox, in addition to writing a custom caption, you can also put warning icons and more.
As always I have to thank you so much derek and I also hope that your family are well.

Hi derek, where can you get the symbols you put as captions in the buttons? Thank you!

Thanks Derek! One more thing: how did you manage, in the beautiful project you attached, to hide the original MVD menu without writing the code:

frmStartup.mnifile.visible := false;
frmStartup.mniabout.visible := false;
frmStartup.mnioptions.visible := false;

Another thing that I find very useful from your project is that I also learned how to translate the original messageboxes with 'transalte' instruction.
I've tried doing the same with tooltip error messages for example when a field is required and nothing has been entered. Unfortunately it doesn't translate anything for me in this case.
Iput:

translate('The_Field_is_Required_Please_Enter_a_Value_for_the_Field', 'È necessario inserire qualcosa in questo campo');

Is there another way?
A thousand thanks.

Caio Fabio, Salut Jean,
The problem I was having was that I wanted to use the new 'visual styles' feature which can make your forms look a lot more modern but I also wanted to
1.  get rid of the standard MVD menu options (screen 01) which I don't like the User seeing.
2.  the menu options are easy enough to get rid of with a small script but this leaves an empty 'menu bar' at the top of the screen (screen 02) which I could find no way of removing by a script and I didn't want to start changing any visual styles files (*.vsf).
3.  Because the standard MVD menu only appears on the first form of your application and not on any of the others, I thought that by using a 'false' first form (in my example, it's call 'formfalse') and writing a small script (screen 03) to call another form and then close the 'falseform' immediately, it would solve both problems;  don't forget that the 'formfalse' tab needs to be moved to the very left of all the forms so that it becomes the first form that MVD sees when the application runs.
4.  And the result is (screen 04);  now there is no wasted space at the top of the form and you can use it for whatever you want.
5.  The only other thing to remember is to set all the other form positions to 'poScreenCenter' (why it behaves like this I have no idea!). 
Regards,
Derek.

Hi,
The condition to remain on 'frminserimento is nuovo = 'new' but I cannot see where you are ever setting it to 'new' in the first place.
You need to add something like this

procedure frmInserimento_OnShow (Sender: TObject; Action: string);
begin
  if action = 'NewRecord' then nuovo := 'new'
end;

Derek.

Greetings all,

Nice thread!

I like the idea of the symbols for button icons.  I know this is your personal collection derek, but some of them do not render properly for me.  I am guessing these are font specific.

I tried viewing it in both Notepad2 and Notepad++ and also pasted them into Word.

Which editor do you normally use?  And would you share the settings to get them to display properly?

I also get the same result pasting them into MVD.

-joshuA

Hi joshuA and derek,
I opened derek's file with Windows notepad and I even see the color characters (font: Arial). It's the first time in 30 years that I've seen color fonts in notepad, I thought it wouldn't even be possible. Maybe in the last one of Windows 11.
However you said well: it's a great idea to put the symbols like Caption.

Wow, those look nice from the 10+ notepads.  That explains it because I still use Windows 7 often.

sparrow: thank you for responding-  Unicode seems to be a moving object, thanks for the extra detail.  It may be possible to update on Windows 7, haha

Thanks again
-joshuA