Alpha Video Training
Results 1 to 2 of 2

Thread: New Records to USB-Update another same application with USB

  1. #1
    Real Name
    Roman Rapido
    Join Date
    Nov 2011

    Default New Records to USB-Update another same application with USB

    How can I possibly automate a process wherein I add new records for example on a product table, then i'm going to copy these new items to a USB device to update another computer with the newly added records, an individual with a little experience in manipulating database systems can accomplish the process.I want end user to just click a button and its copied.This sample scenario is not web based, its a desktop application that are NOT connected in a LAN, Is there a script so that when i click a button, the new items will be added to a usb device, then with that usb, i will connect it to another computer then click a button-select the usb-then click OK-then the new items will be added to table on the new computer.Thank you!

  2. #2
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Bowling Green, KY

    Default Re: New Records to USB-Update another same application with USB

    You first need to have a way to filter for "new" records in your table(s). This might mean adding a field, blank initially, that gets populated when you copy the records to the usb.
    The usb device needs to have a table(s) to which you copy records.
    The receiving records process needs to append the records to a table(s) on the receiving end, verify the appended count, then empty the table on the usb device.

    If the receiving database is on a machine connected to the internet you might want to

    copy the records to a temporary table
    email the table to the receiving machine
    save the temporary table on the receiving machine
    append the records to the receiving database

    repeat as necessary.

Similar Threads

  1. copy selected records to usb flash drive
    By fddizon in forum Alpha Five Version 10 - Desktop Applications
    Replies: 4
    Last Post: 11-15-2010, 05:34 PM
  2. A5V8/V9 application from USB stick?
    By dvenus in forum Alpha Five Version 8
    Replies: 1
    Last Post: 05-02-2008, 04:09 PM
  3. USB Printer Help ... perhaps
    By DSG in forum Alpha Four Versions 7 and 8
    Replies: 2
    Last Post: 05-24-2005, 08:31 AM
  4. USB Printing
    By AlexW in forum Alpha Four Versions 7 and 8
    Replies: 10
    Last Post: 02-25-2004, 10:13 PM
    By PARCODE in forum Alpha Four Version 6 and Prior
    Replies: 4
    Last Post: 11-08-2001, 04:31 AM


Posting Permissions

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