[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

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
0
mbauomi
Asked:
mbauomi
  • 4
  • 2
1 Solution
 
KECommented:
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
 
KECommented:
Any comments ?
0
 
mbauomiAuthor Commented:
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
KECommented:
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
 
mbauomiAuthor Commented:
Ok thanks.. but can u tell me where i can find documents about  databases {dbase-paradox} and network
0
 
KECommented:
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.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now