Alpha Video Training
Results 1 to 6 of 6

Thread: Crosstab Prevent Delete Table

  1. #1
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Crosstab Prevent Delete Table

    Hi,

    I am running a crosstab operation, but want to allow more then one user to run the crosstab at the same time.

    Having read through the user guide the 'crosstab.db' function creates a new crosstab. If two users run the crosstab at the same time only one of them will get the correct result, which is a major problem for me.

    How can i prevent the crosstab table being recreated every time it is run. Ideally i would just append to the existing table and place their user id in a field and manage the output from there.

    So my question is how can i amend the crosstab script so that it appends the data to the crosstab table rather than deleting and creating a new table?

    Thanks in advance.

    Denis

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

    Default Re: Crosstab Prevent Delete Table

    You can't do that in a crosstab script. You can create a result table and append the crosstab results to it. With the possibility of multiple crosstabs running you will need to check to see if the process is in use by any users before allowing anyone to perform it.
    There can be only one.

  3. #3
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Re: Crosstab Prevent Delete Table

    Thanks for the infor Stan.

    How would i go about checking to see if the process is in use by any users before allowing anyone to perform it?

    Denis

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Crosstab Prevent Delete Table

    You might create a script which


    checked a table for user activity (record as created by following)
    if no record found
    wrote a record to a table recording user id and start of process
    began the user process with the crosstab
    deleted the above record when done
    else
    notified user to try again later
    ended
    There can be only one.

  5. #5
    Member
    Real Name
    Denis Ahmet
    Join Date
    Jul 2005
    Location
    United Kingdom
    Posts
    988

    Default Re: Crosstab Prevent Delete Table

    Again thank you for your support, but i do not have enough knowledge to achieve this.

    Has anyone done this and is able to provide me some code?

    Denis

  6. #6
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default Re: Crosstab Prevent Delete Table

    I've never done it but I think you could edit the crosstab script and subsequent processing to work with files on each user's machine using

    A5.GET_PRIVATE_PATH()
    There can be only one.

Similar Threads

  1. Prevent row delete in emb browse
    By gaby_h in forum Alpha Five Version 9 - Desktop Applications
    Replies: 8
    Last Post: 02-10-2009, 12:46 PM
  2. Replies: 2
    Last Post: 01-30-2009, 07:14 PM
  3. How can I prevent duplicate entries in a browse table
    By brianp in forum Alpha Five Version 6
    Replies: 5
    Last Post: 05-13-2008, 06:08 AM
  4. Prevent delete if child has value?
    By Keith Hubert in forum Alpha Five Version 8
    Replies: 3
    Last Post: 12-13-2007, 10:06 AM
  5. How to prevent edit, or delete
    By rcarale in forum Alpha Five Version 6
    Replies: 1
    Last Post: 08-10-2006, 05:24 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
  •