Alpha Video Training
Results 1 to 4 of 4

Thread: v5 Spec in relation to file locking

  1. #1
    Ian Marshall
    Guest

    Default v5 Spec in relation to file locking

    Hello

    Can anyone provide the following information, as I am considering using Alpha5v5 for an apparel finance system.

    1. Locking - is this record or row level.
    2. Need to be able to access the application from 30 users.
    3. Is the application multi processor optimised.
    4. Can different databases be linked together.


    kind regards


    Ian Marshall

  2. #2
    VAR csda1's Avatar
    Real Name
    Ira J Perlow
    Join Date
    Apr 2000
    Location
    Boston, Massachusetts, USA
    Posts
    3,530

    Default RE: v5 Spec in relation to file locking

    Hi Ian,

    In response to your questions,

    1. not sure the difference you mean between record and row level, but A5 locks the record.

    2. 30 Users is not a particularly hard use of the program from a sharing perspective.

    3. It is not multi-processor optimized as far as I know, but I don't think that gains you much here. Most operations are disk bound or network bound.

    4. Yes, if you mean tables (ala Access definition) when you say databases. In A5, databases refer to a collection of individual tables. Sets are tables linked together by relations.

    Regards,

    Ira

  3. #3
    Ian Marshall
    Guest

    Default RE: v5 Spec in relation to file locking

    Thanks for the quick response.

    In relation to the third question regarding linking, i was thinking more along the lines of -

    4 actual databases, with tables, some of which are in sets.

    These individual databases would have links to tables in other databases.

    The reaon being we want to develop an aplication for our business which is a distributor and manufacturer of clothing. This would include the need for -

    1. Sales Order Processing.
    2. Purchase Order Processing.
    3. Accounts Receivable.
    4. Accounts Payable.
    5. General Ledger.
    6. Production Planing.
    7. Goods Inward.
    8. Goods Outward.
    9. Stock.
    10. Product Development.
    11. Customer Relationship Management.
    12. Credit control.
    13. Marketing.
    14. Budget and forecasting.
    15. Multi-Currency.
    16. E-commerce as long term goal.

    Any points you wish to put forward?

    kind regards

    Ian Marshall

  4. #4
    "Certified" Alphaholic Melvin Davidson's Avatar
    Real Name
    Melvin Davidson
    Join Date
    Apr 2000
    Location
    Parker, CO
    Posts
    1,197

    Default RE: v5 Spec in relation to file locking

    Ian,

    To further clarify question 1, record and row are synonymous, so the answer is yes. :)

    Question 3:

    There is no "hard" link. The same physical table can actually be referenced by several databases. All that is needed is to add the table into the database. As a rule,
    it's good practice to keep all databases's and tables in the same directory, but that is only for ease of development
    and portability.

    regards,
    Melvin Davidson

Similar Threads

  1. File Locking
    By David S in forum Alpha Five Version 5
    Replies: 1
    Last Post: 03-14-2005, 06:08 PM
  2. File locking
    By Roger Evans in forum Alpha Five Version 5
    Replies: 1
    Last Post: 05-12-2004, 10:32 AM
  3. File Locking Error
    By Ronald Frias in forum Alpha Five Version 5
    Replies: 4
    Last Post: 09-05-2002, 11:47 AM
  4. File locking error
    By DonWalton in forum Alpha Five Version 4
    Replies: 4
    Last Post: 06-21-2002, 08:58 AM
  5. FILE LOCKING
    By MARC DUVALSAINT in forum Announcements
    Replies: 0
    Last Post: 01-18-2001, 09:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •