prasiddutta
asked on
Which database is better for Delphi7?
Sir,
I want to build a School Management System in delphi 7. Which database is better. Please tell me.
Prasid
I want to build a School Management System in delphi 7. Which database is better. Please tell me.
Prasid
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Since you probably have Office - use Access as the back-end database.
Then in D7 use the ADO components.
Then in D7 use the ADO components.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
May be 3000 records present. And I also like VFP and access. Am I right?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oooo! Huge size. I'm tensed... What is the main problem if I use Access with help of ADO Connection?
In my opinion Access is not designed for large amount of data or for concurrent multiuser access.
In my opinion the best database for such application is either Firebird or PostgreSQL. Both are efficient, the have no significant limits, very easy administration and they are free.
In my projescts ususally use Firebird.
In my opinion the best database for such application is either Firebird or PostgreSQL. Both are efficient, the have no significant limits, very easy administration and they are free.
In my projescts ususally use Firebird.
ASKER
My drawback:
I don't know sql, oracle, firebird, interbase. You can provide me example for delphi.
I don't know sql, oracle, firebird, interbase. You can provide me example for delphi.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
if you do not know SQL it will be difficult.
I suggest you use Access 2007.It has nice built in templates which
you can easily adjust for your needs (see the pic)
sys.png
I suggest you use Access 2007.It has nice built in templates which
you can easily adjust for your needs (see the pic)
sys.png
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Geert, you always differ than others... I will try.
Geert,
Just out of curiosity, which version of Delphi is applicable to that project?
Just out of curiosity, which version of Delphi is applicable to that project?
ASKER
It work on delphi 7 version....! but not completely...
Did you try it on D6?
ASKER
no no no
I did help out in it with D7.
What doesn't work ?
I didn't check what's in the zip ...
What doesn't work ?
I didn't check what's in the zip ...
ASKER
Lot of error. Plz run in your D7. I'm not expert thus I can not predict the error.
you don't need to predict
copy paste works from the messagebox which has focus
i allready stated it is the worst code i have ever seen
i think the newer version required the devexpress quantumgrid and treeview
copy paste works from the messagebox which has focus
i allready stated it is the worst code i have ever seen
i think the newer version required the devexpress quantumgrid and treeview
ASKER
Yes! This instruction help me little bit!
On the other hand, I would enthusiastically use Delphi for such an application. It has all of the things you mention about Visual FoxPro as well as several other properties that make it my "weapon of choice" for such pplications. Of course, I am also sure that VFP has other aspects that may make it your "weapon of choice."
However, the key point here is whether or not it is Uprasiddutta's "weapon of choice" (or, possibly, "weapon of necessity" ;-).
Delphi has a fairly large following outside of the US (and not that small of one inside the US ;-), so it is entirely possible that there is more support for the application if it is written in Delphi than if it is written in VFP.
In any case, I would think that we should honor the initial problem statement given in the original post:
"I want to build a School Management System in delphi 7."