Skip to forum content
My Visual Database
A Simple Solution for Creating Databases
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 1 of 3)
Hello, everybody.
i have a database with approx. 3000 entries. it has two combobox. first one is for selecting the area & second one is populated data based on combobox-1 selection. but the issue is each selection in combobox-1 has around 1000 entries which took a large amount of time to populate the second combox. is there any way to speed up the combobox population.
sample data:
combo box-1 linked table:
id Area desig
1 Domestic d
2 International i
3 Internal e
Combobox-2 linked table
id zone id_area
1 d001 1 similarly 1000+ entries
nn i001 2
.....
hii,
pl. help in passing the data to external VB or Js script.
I have attached a sample project where 2 textbox data need to be send to JS script to get result.
ps: attached JS file is for demo purpose for passing data. If this demonstration succeeded then we can easily develop much more than MVD can alone.
sparrow wrote:in calculated field use
CONCAT(ifnull(lot,''),ifnull(element1,''),ifnull(element2,''),ifnull(element3,''))
thank you!, works perfectly with existing data.
i am now trying to get the work done with tables having foreign key. i will let you know if any help required.
once again thank you.
Sorry, for not mentioning that my database is mysql .I am trying it but in mysql it s not working.
derek wrote:Hi Nrmuduli,
One way is to concatenate every field that you are interested in (it may be all of them or just a subset) into a calculated field and use that calculated field to search on.
Please see the attached.
Derek.
hii, Derek,
Exactly meet my requirement without much complexities. But how to make it with mysql.
Thank you.
If any one have other solution then pl. post. this will surely increase the knowledge.
sibprogsistem wrote:nrmuduli wrote:hiii,
I want to make a search field with button. my aim is to search the word/ phrase in the entire database irrespective of column & show in the table grid.
a sample screen shot made in excel attached.
any help is highly appreciate because in my existing programm i am able to do search by column wise linked to different fields in the interface.
if you need to request this program from scratch, then prepare your wallet.
if you already have a program and you need help, then attach your project
если вам нужно запросить эту программу с нуля, то подготовьте свой кошелек.
если у вас уже есть программа и вам нужна помощь, то прикрепите свой проект
hello, i have attached the sample project since my original program has some sensitive information. pl. help me if you can.
hiii,
I want to make a search field with button. my aim is to search the word/ phrase in the entire database irrespective of column & show in the table grid.
a sample screen shot made in excel attached.
any help is highly appreciate because in my existing programm i am able to do search by column wise linked to different fields in the interface.
Does any body tried firebase (no sql realtime database) with MVD.
pls check http://myvisualdatabase.com/forum/viewtopic.php?id=6080
Application.User.id;
Application.User.Username;
Application.User.Email;
Application.User.First_name;
Application.User.Last_name;
Application.User.Role;
Application.User.RoleId;
Application.User.is_admin;
Application.User.is_active;
Application.User.is_logged;
Application.User.Last_login;
Application.User.Date_joined;
Hii Jean,
Thanks for reply. this type of gantt chart is with me. but i need calender type view.
is it possible.
how to create a calendar with planner like the image attached.
Thanks Dimitry.
Working fine.
hiii,
is it possible to create a tree view from table grid data. or
1. is there any way to filter only projects that are running in current month or the selected time period
.
2. and second is, if i want to show only one project in tree view can it be possible.
reference post http://myvisualdatabase.com/forum/viewtopic.php?id=5180
Hii,
1. is there any way to filter only projects that are running in current month or the selected time period.
2. and second is, if i want to show only one project in tree view can it be possible.
thanks....
now its working..... 
HELP, It is not working in mysql connection.
completed my project in sqlite which is running & results are correct.
mysql server version: 5.7.20
mvd: 5.4 trail
further error shows during syntax check
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLQuery('SELECT id, id_Project , Start, End, StartActual, EndActual,Comment FR' at line 1
thanks for the reply.
let me elaborate more. first i have 5 nos of running projects, each project having number of tasks & each task having actual & projected time lines.
in this situation i can not think of how to take up the job.
thanks....
is there any way to draw chart like in the picture.
my goal is to modify the example gantt chart posted on the forum to display two rows for a single task. one is for expected date of start & end & other is Actual date of start & end. any suggestion is highly appreciated.
at my end it works
checked with v4.02 trail
i have removed some components & modify the script. so pls. do not replace your script with this script
Posts found: 1 to 25 of 52