1

(8 replies, posted in General)

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

2

(8 replies, posted in General)

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

3

(8 replies, posted in General)

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

5

(10 replies, posted in General)

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

6

(10 replies, posted in General)

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

7

(10 replies, posted in General)

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

8

(10 replies, posted in General)

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

9

(10 replies, posted in General)

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

10

(6 replies, posted in General)

Thank You Verry much Sir,
Have a Great Day

Regards
Nitin Ingale

11

(6 replies, posted in General)

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

12

(6 replies, posted in General)

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

13

(6 replies, posted in General)

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

14

(2 replies, posted in General)

Thank you very much Sir.

15

(2 replies, posted in General)

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