Solved

Network Application

Posted on 1998-04-14
6
140 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
Comment Utility
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
Comment Utility
Any comments ?
0
 

Author Comment

by:mbauomi
Comment Utility
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 3

Accepted Solution

by:
KE earned 50 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

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…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

772 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now