Solved

Network Application

Posted on 1998-04-14
6
143 Views
Last Modified: 2010-04-06
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
0
Comment
Question by:mbauomi
  • 4
  • 2
6 Comments
 
LVL 3

Expert Comment

by:KE
ID: 1361515
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.
0
 
LVL 3

Expert Comment

by:KE
ID: 1361516
Any comments ?
0
 

Author Comment

by:mbauomi
ID: 1361517
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
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 3

Accepted Solution

by:
KE earned 50 total points
ID: 1361518
The BDE willl automatically tell your user that the records is locked by an exception message, but that only applies to Paradox, dBase tables.
If you add or delete records, it will only affect the current state of you r components. i.e. if you have a DBGrid displaying 20 rows from your table, and row 10 is, changed by another user, the new data will not be displayed until the record is fetched again. i.e. if you scroll out of the window or doing a refresh on the table.
Changed data are not displayed automatically, it only shows when re-displaying.

0
 

Author Comment

by:mbauomi
ID: 1361519
Ok thanks.. but can u tell me where i can find documents about  databases {dbase-paradox} and network
0
 
LVL 3

Expert Comment

by:KE
ID: 1361520
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 ?
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question