Admin Sir,
Can you do it for me?
I will pay the charges
I am non programmer, i can not write the scripts
Thank You
Nitin Ingale
922500310
My Visual Database → Posts by nitin.ingale08
Admin Sir,
Can you do it for me?
I will pay the charges
I am non programmer, i can not write the scripts
Thank You
Nitin Ingale
922500310
What's new?
- Added export data to CSV (according to standard RFC 4180) (Options > Export data)
- Added import data from CSV (according to standard RFC 4180) (Options > Import data)
Sir, can you do this for me to merge data in one SQLITE
Thank You
Nitin Ingale
922500310
Hi Sir
Any Solution to how to Merge Multiple Databases into a Single Database
Sir,
I created one software to handle my four-location institute students database. So at each location, I have different student database software created by my visual database.
Sir, Now I want to handle all student databases sitting in one location.
Means, Merge Multiple Databases into a Single Database.
Please help me, how I can do this, and all Table relation should be retained in a single SQL lite
Thank You
Nitin Ingale
922500310
Thank You Sir,
A Final project i build in beta version setup 3.7b.
In this 3.7b Version I used "ComboBox - Searchable True Option"
This makes my select entity from Drop-down very easy.
Can You Fix This Issues in 3.7 Version?
Or
I need To Buy New Version.
I finish my project and no further update will be done in my project. I build it for my self for small computer institute that I run. Thanks for your valuable supports for non programmer.
Please guide me what to do.
Regards
Nitin Ingale
Sir,
I am using beta version setup 3.7b
Please check with this version
Please find attach setup 3.7b link I am using
https://www.dropbox.com/s/exd6hl01kxk81 … b.zip?dl=0
Regards
Nitin Ingale
Thank You Sir, For Response.
Run Project & Go to StudentDB Button,
That open the Student Dashboard, In Student DB Grid Table group you find three student listed and i have attached photo from RegStudent Form.
On Click any row in Student Dashboard Grid Table form were three students are listed.
We Get The Error showing some number.
"We are using the concept in Student Dashboard form that is, Click on grid table row show student photo. Event Script is written in Grid Table."
"This type of error coming every database, where i uses this above concept, click on grid & show photo."
On doubleclick we can not access or edit data. by right click on row and show records then we can edit data or edit button we have to use.
Please help me and please fix error. "If we remove photo then no error"
Please Find updated attach file in link
https://www.dropbox.com/s/f5mak4jt73jp6 … P.rar?dl=0
Regards
Nitin Ingale
Sir,
Thanks For Response.
I am not programmer, I Build this project because without programming knowledge we can build database using this "My Visual Database".
all the script are given by this forum. Thanks a lot for every one, for helping me.
i am running an computer institute and created for my self to managing data.
I am now implementing this project and got this error.
I do not know about "LinkFile propert" you mention, that why i didn't use. as i am non programmer.
Please help me and please fix error.
Regards
Nitin Ingale
Dear Sir,
Go to StudentDB Button,
Click on row of Student DB Grid Table,
on click, its show student photo, but giving error,
by right click on row, show record, then i can asses record.
if i do not attach photo, then its working fine.
please fix this error,
Please Fine attach file in link
https://www.dropbox.com/s/c4qv77j101tmq … e.rar?dl=0
Regards
Nitin Ingale
Thank You Verry much Sir,
Have a Great Day
Regards
Nitin Ingale
Thank You Sir,
Unfortunately I am Not understand ....
" I manually updated the id_CourseDB inside of studentDB for all students with a Regdate within September.(5 Records). and
a, b, and c in SQLQuery button "
Meaning of a, b, c and manually updated.
Sorry for that...
You are right -- student records and course records are disconnected.
it is connected at "AddCourses"
I have updated form, just now how to consulate Grid Data? using SQLQuery button
Please see updated file in attachment.
https://www.dropbox.com/s/f5mak4jt73jp6 … P.rar?dl=0
Please empty Backup folder to upload file. if Necessary...
Regards
Nitin Ingale
Sir,
I have tried different ways using calculated field.
But output is coming as a blank 5 rows count.
5 rows is right for dates 1 September to 30 September result, but showing blank rows.
I think using sql script in button will work. I am not able to write sql script in botton to consulate data, to count course sold date wise.
Please help me sir.
Regards
Nitin ingale
Sir,
Please go Course admission Count botton.
Please see attach photo for detail explanation.
I want to count date wise course solds.
Please write a script in button to get output. or any other way.
Please see attach file. and photo for detail explanation.
https://www.dropbox.com/s/f5mak4jt73jp6 … P.rar?dl=0
Regards
Nitin Ingale
Thank you very much Sir.
Sir,
In TrackingDB, I want to copy 'Student Name' and 'Mobile No' to do further query.
For that, I return a script in grid cell check to
But, for some row it is display contain and for some row not display contain.
Ex- for first 3 row it is not display contain and 4,5,6,... row its display
and at bottom rows it is not display contain,
Please check
Or any other way?
Please see attach file and photo.
https://www.dropbox.com/s/f5mak4jt73jp6 … P.rar?dl=0
Regards
Nitin Ingale
Thank you very much sir.
Sir,
Is this bug?
Or we need to add some script to remove this below problem.
Header, Footer and grid line are get missing at 2nd ....3rd... time opening form.
because of this - I need to restart application, but 1st time ok, then again problem start...
please see attach photo for problem.
Please see your Sample ERP Revised 2 file.
Regards
Nitin Ingale
Sir,
Description:
I am created Database ERP software.
Side by side, I am doing actual entry and updating software as per demand raise.
In ERP Software, I have 28 dropdown menu, list is very big with records, for some dropdown menu +100.
Solution needed:
I want to preserve dropdown menu records at save as option.
May be, Tables Marks as Dictionary do not delete dropdown menu records.
Because:
Now the Database entries cross +2000
Deleting these records one by one is tedious.
Please help me with any solution with sample file.
Regards
Nitin Ingale
Sir,
Thank you very much for SQL coding,
Your Valuable efforts makes the true ERP System.
Thanks again for spending your valuable time to help me.
Have a Good Day Sir
Regards
Nitin Ingale
Thank very much Sir,
One more last problem, please help,
A. Summary Trainer
in Child: Batch Time: the problem is, its showing all student batch status, Time Wise.
I Also need the Batch Time wise data of each software belong to trainer handing.
I added one more child grid to get software wise Batch Time.
Please write SQL code for this button.
Please find attach updated file.
Thanks Sir,
Regards
Nitin Ingale
Sir,
Thank you,
A. Summary Trainer
1. Child Software table : Trainer handling software list is showing, In that I need the count of student, belongs to respective trainer.
2. Child Batch Time Table : Trainer's handing student status list is showing, In that I need the count of student belong to respective trainer.
B. Summary Software
1. Child Trainer table : Software handling Trainer list is showing, In that I need the count of student belong to respective software.
2. Child Batch Time Table : Software's handling student status list is showing, In that I need the count of student belong to respective software.
Child count is showing wrong result
Please see attach photo.
Regards
Nitin Ingale
DrivesSoft,
Please help me.
Regards
Nitin Ingale
Sir,
Also find Sample ERP Database schema that show what I want, and doing.
Please help sir.
Regards
Nitin Ingale
Sir,
1. Have used Calculated Field In Software table: But becouse of this table becoume not editable.
Cal_SoftEmpTotal
(select count(id) from Deliverable where Deliverable.id_Software = Software.id and Deliverable.id_EmployeeDB = EmployeeDB.id)
2. Ehwagner sir help me and table become editable: But Result showing wrong.
(select count(Deliverable.id) from Deliverable
Left Outer Join EmployeeDB On EmployeeDB.id = Deliverable.id_EmployeeDB
where Deliverable.id_Software = Software.id)
3. I added Deliverable.id_EmployeeDB = EmployeeDB.id to count properly but showing no change, but it should count.
(select count(Deliverable.id) from Deliverable
Left Outer Join EmployeeDB On EmployeeDB.id = Deliverable.id_EmployeeDB
where Deliverable.id_Software = Software.id and Deliverable.id_EmployeeDB = EmployeeDB.id)
Please help.
Please find updated file in attachment.
Regards
Nitin Ingale
Sir,
Thank you, But Report giving wrong Result numbers.
Please see attach photo, In which original description is explain in detail.
Please help.
Regards
Nitin Ingale
My Visual Database → Posts by nitin.ingale08
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi