Alpha Video Training
Results 1 to 3 of 3

Thread: Appending records

  1. #1
    Member Jesse Sanders's Avatar
    Real Name
    Jesse Sanders
    Join Date
    Jul 2000
    Location
    Lancaster PA
    Posts
    107

    Default Appending records

    I need to confirm this before I write alot of code.
    I need to reagularly update my database on the the web with new results.
    I saw that WAS does not support the append function.
    Is that correct or is there a loophole to running it.
    I am planning to use FTP to bring the new records to the website and then use append (Attached to an advanced button)to bring them into the database.
    If that won't work I plan on opening both databases and copy the records field by field into the website database.
    Any other ideas?

    Jesse

  2. #2
    "Certified" Alphaholic
    Real Name
    Cal Locklin
    Join Date
    Mar 2000
    Location
    S.E. Michigan
    Posts
    5,763

    Default RE: Appending records

    You asked for other ideas. This may not fit your situation but here's another idea....

    In my case I can add the records in the desktop portion of the app. Then, because I don't need to upload all the fields or all the records and some customers already have over 200,000 records so it's better to reduce the file size, I build a new table to upload; compress it with the zip commands in A5; and FTP that then run a page that opens up to automatically unzip the file. The "hard" part is that the user will probably want to close the browser window after the file is unzipped. Of course, it won't hurt anything if it's not closed. (Anybody know a way to unzip a file on a website without opening an A5w page? Lenny??)

    Note: Although the previous paragraph said "I" a lot, it's actually all handled by the app. The customer clicks an "import data" button and later, after reviewing the new data, clicks an "upload new data" button and Alpha FTPs it to their folder on the website.

    Cal Locklin
    www.aimsdc.net

  3. #3
    Member Jesse Sanders's Avatar
    Real Name
    Jesse Sanders
    Join Date
    Jul 2000
    Location
    Lancaster PA
    Posts
    107

    Default RE: Appending records

    Thanks,
    That is an Idea that might work.
    Jesse

Similar Threads

  1. Appending Records
    By kumargroup in forum Alpha Five Version 5
    Replies: 0
    Last Post: 07-10-2003, 09:20 AM
  2. Appending Records
    By Jules Klapper in forum Alpha Five Version 1
    Replies: 1
    Last Post: 03-13-2003, 11:09 AM
  3. Appending Records
    By Scott Rusoff in forum Alpha Five Version 5
    Replies: 1
    Last Post: 01-15-2003, 04:30 PM
  4. Appending records
    By Jim Stermer in forum Alpha Five Version 5
    Replies: 7
    Last Post: 01-07-2003, 10:58 AM
  5. appending records from set to set
    By Todd Warren in forum Alpha Five Version 4
    Replies: 3
    Last Post: 08-16-2000, 05:18 AM

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
  •