Alpha Video Training
Results 1 to 4 of 4

Thread: Memo Database

  1. #1
    "Certified" Alphaholic Charles Hoens's Avatar
    Real Name
    Charles Hoens
    Join Date
    Sep 2000
    Location
    Princeton, NJ
    Posts
    1,170

    Default Memo Database

    Hello all!

    When I worked in a government computer environment (about 100 years ago) we had, in the computer room, an on-line file we called "OPSTAT". It was a large memo type file in which all the information and routines were placed by the operators on an ongoing basis. So, for example, if I made a change to the system configuration or installed something new or whatever, I logged it into the Opstat log file. At the end of each month the file was archived and a new one was begun. Now this was done using DEC and DCL (Dec command language), but the upthrust was that anyone authorized could view the file and be brought up to date with what was going on in the computer systems area. In fact, we made it required reading for all operators coming on shift, so they couldn't say that they were not aware of some problem or other. It was also searchable, so that if I were looking for a particular user name or system, etc. it would locate the "hit's" for me.

    OK. My question is developmental. How can I do this in A5? I'm concerned that the memo fields are not robust enough to withstand constant opening and closing and I'm not sure how they can be searched anyway. Has anyone else encountered this problem and/or does anyone have an idea of how to address this problem? Should I use a Word file, or a searchable PDF file perhaps? I was thinking of logging the note into a memo field and then writing that memo field to a Word file.

    Thanks for any ideas you might have.

    Charlie

  2. #2
    Volunteer Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,643

    Default Re: Memo Database

    Hi Charles,

    I'm not sure memo fields are an issue - provided that users are prohibited form navigating when they are open in any way. If you put the memo in a modal form so edits are isolated from navigation and users are forced to save or cancel any edits, you'll probably be safe from memo corruption. Lots of backups can't hurt either.

    I believe memo fields are searchable, but I don't use dbf any more unless for an old client.

    I don't know your needs, of course, but I would consider searchable category fields rather than stuff a whole bunch on info in a single memo field. But maybe that's not a good solution for you?

  3. #3
    Volunteer Moderator Peter.Greulich's Avatar
    Real Name
    Peter Greulich
    Join Date
    Apr 2000
    Location
    Boston, MA
    Posts
    11,643

    Default Re: Memo Database

    Oh, you're in web ( I thought it was desktop). Memo fields should be safe, but I guess it depends on how Alpha handles read/writes in web-dbf.

    But if your in web, you should seriously consider a SQl backend.

  4. #4
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,355

    Default Re: Memo Database

    Memo fields can be auto saved when navigating away from the field. That's how I handled the problem.
    Another way is a set with small succint 250k fields spawned off the header. Then you can capture the viewer as well by insisting that the field was opened full size to create an activity.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

Similar Threads

  1. Error when running memo check - past end of memo file
    By dchiass in forum Alpha Five Version 10 - Desktop Applications
    Replies: 3
    Last Post: 04-20-2018, 01:50 PM
  2. Group By Query With Memo Fields - make memo field an expression?
    By kingcarol in forum Application Server Version 11 - Web/Browser Applications
    Replies: 4
    Last Post: 06-30-2012, 05:54 PM
  3. Replies: 11
    Last Post: 10-02-2007, 05:12 PM
  4. table/database Description/memo
    By dpawley in forum Alpha Five Version 6
    Replies: 1
    Last Post: 10-07-2005, 01:15 PM
  5. Corruption of database - Memo fields
    By mike gibbard in forum Alpha Five Version 5
    Replies: 5
    Last Post: 11-02-2003, 03:04 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
  •