Re: Distinct
You should to populate the ComboBox in this way:
procedure Form1_OnShow (Sender: string; Action: string);
begin
frmpelatis.ComboBox1.dbSQLExecute ('SELECT DISTINCT name.name, name.id FROM name GROUP BY name.name');
end;
My Visual Database → Script → Distinct
You should to populate the ComboBox in this way:
procedure Form1_OnShow (Sender: string; Action: string);
begin
frmpelatis.ComboBox1.dbSQLExecute ('SELECT DISTINCT name.name, name.id FROM name GROUP BY name.name');
end;
do you have teamviewer on your pc?if yes let me know
I have installed the 2.2
But the script http://myvisualdatabase.com/forum/misc. … download=1 works only fro the first record.
After that it let you to add records with the same names
yes I have teamviewer
whats your e-mail?
give me your id and password
pha1984@yandex.com
pha1984@yandex.com
I send it on your e-mail
Hi v_pozidis!
I attached your project here. Maybe it will be helpful for others.
Hi v_pozidis!
I attached your project here. Maybe it will be helpful for others.
Great job.
Could you please explain whats count means and also the upper and lower ?
existing_name_count1 := SQLExecute('SELECT COUNT(name) FROM name WHERE upper(name)=upper("'+new_name+'")');
existing_name_count2 := SQLExecute('SELECT COUNT(name) FROM name WHERE lower(name)=lower("'+new_name+'")');
1. The Count() function returns the number of rows that matches a specified criteria.
2. Lower and Upper functions convert the value of a field to lowercase and uppercase respectively.
pha1984 wrote:Hi v_pozidis!
I attached your project here. Maybe it will be helpful for others.Great job.
Could you please explain whats count means and also the upper and lower ?existing_name_count1 := SQLExecute('SELECT COUNT(name) FROM name WHERE upper(name)=upper("'+new_name+'")');
existing_name_count2 := SQLExecute('SELECT COUNT(name) FROM name WHERE lower(name)=lower("'+new_name+'")');
My Visual Database → Script → Distinct
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi