Link to home
Start Free TrialLog in
Avatar of mbauomi
mbauomi

asked on

Network Application

Hi,
I need to make network application... what is the  best way to do it and
1- how to configure BDE
2-should  EXE file be in every machine
3- how to update database (if changed or one of users add record to it)  for other users get their databases updated
4- what problems maybe happen after setting my program and bde during users working

please refer to any available documentation and {freeware components}

Thanks
Avatar of KE
KE

1. Configuration of the BDE is determined by wich database/server you plan to use. The InstallShield wizard can configure the BDE settings when you install your application.
2. Not if you install your application on a shared network drive, but this will require some knowledge of setting the correct registry keys and also which DLL's that must reside on either a shared network drive or the Windows system directory.
I'll suggest that you use the InstallShield and install a complete package on every machine (for a beginning).
3. If you use a SQL database, some of them (if not every one) can alert your application when a certain exception or programmed event occurs - this will also require some knowledge. If you use Paradox or another filing database, you can program the BDE to query the database for new updates/changes, but it's not a ideal solution.
4. The BDE settings are only affecting the client. However - if you change the language setting it can affect the retrieval of previously stored strings in the database.
Any comments ?
Avatar of mbauomi

ASKER

ok.. in no 3
i don't use SQL database
What happen (after BDE settings is ok) when (by example)
2 users using the same database table when:
-sharing the same record (first do i need to check if the current  record is locked?)
-the very important is when one of them or both add or DELETE records from the same table (what do i need to do???) to UPDATE the table {cause that maybe doing problems... is that right??}

please describe with full details and EX

Thanks
ASKER CERTIFIED SOLUTION
Avatar of KE
KE

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of mbauomi

ASKER

Ok thanks.. but can u tell me where i can find documents about  databases {dbase-paradox} and network
Not really - the best advise I can give, is to visit the local bookstore and lookup a book on delphi database programming.
The manuals do also give a brief discussion on the subject - but if your'e starting from scratch, try the bookstore.
Maybee, there's something to catch on the net ?