Solved

Network Application

Posted on 1998-04-14
6
141 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 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

12 Experts available now in Live!

Get 1:1 Help Now