You are not logged in. Please login or register.
My Visual Database → Script → Show specific record from database into textbox
Hello
Need a script to show record into texbox
Exemple
Table name : users
Column to search : name
Column to show record from : age
I want to enter the name into textbox1 and show the age into textbox2 depending on the name
Need script with SELECT sql query
Any help friends ?!
Hi,
There are many ways to do this - which is best depends on what is most suited to your project.
In the attachment are 3 options.
Option1: simply type in the name
Option2: click on a name in the tablegrid
Option3: select the name from the combobox.
As a general comment, it's not usually a good idea to hold someone's 'age' in a table - it is usually better to store their date of birth and then calculate their age when your program runs.
Derek.
simokami.zip 443.77 kb, 65 downloads since 2024-01-10
Hi derek ,
Thanks for help
For the age it's just an example
I will test the project you attached
There is one caveat. If there are several users in the database with the same name, then you need to decide how to display the search result. Typically in this case the result is displayed as a comma separated list of values. The group_concat() SQL-function will help in implementing such functionality.
procedure option1 (Sender: TObject);
begin
form1.edit2.text := sqlexecute('select GROUP_CONCAT(age,",") from example where name = "'+form1.edit1.text+'"');
end;
изображение_2024-01-11_115737343.png 20.55 kb, 15 downloads since 2024-01-11
My Visual Database → Script → Show specific record from database into textbox
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi