Alpha Video Training
Results 1 to 10 of 10

Thread: UUID - Grid Event

  1. #1
    Member eboughey1's Avatar
    Real Name
    Elena Boughey
    Join Date
    Sep 2008
    Location
    Deltona, FL
    Posts
    166

    Default UUID - Grid Event

    I had the following under Intitialize (server events) on the dialog but it's not working right on the grid. It creates the record, but then creates a second one. I've tried several variations (remove all but the appending of uuid, remove tbl.close, etc) but still won't work. Maybe fresh eyes will help.

    The reason I'm creating this is because I want the user to see the 'newjobno' field on the screen when the job is started. The session variables are also used on submit to print the workorder.

    I'm just not that well versed on how the events work in the v10 beta (or the v9 either).

    Code:
    job_ID= remspecial(api_uuidcreate())
    
    tbl = table.open("[PathAlias.ADB_Path]\workorder.dbf")
    tbl.enter_begin()
    tbl.Jobno = alltrim(Job_ID)
    tbl.enter_end()
    datasubmitted.Jobno = Job_ID
    newjob=tbl.Newjobno
    tbl.close()
    session.Job_ID = Job_ID
    session.newjob = newjob
    datasubmitted.Newjobno = session.newjob
    Up and coming Alphaholic ;)

  2. #2
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,842

    Default Re: UUID - Grid Event

    If you create the job_id in Initialize, there is no reason to save the record and then "re-get" the job_id from the table. Just create it the id as you are and display it on the screen, but don't create a record UNTIL they submit and then use AfterValidate to create that record.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  3. #3
    Member eboughey1's Avatar
    Real Name
    Elena Boughey
    Join Date
    Sep 2008
    Location
    Deltona, FL
    Posts
    166

    Default Re: UUID - Grid Event

    Okay I believe it have it set up right, but the newjobno which is an auto incremented field and the client's job number keeps giving me problems.

    In Grid Initialize I have:

    Code:
    job_ID= remspecial(api_uuidcreate())
    
    tbl.Jobno = alltrim(Job_ID)
    e.rv.session.jobno = tbl.jobno
    e.rv.session.newjob = tbl.newjobno
    
    I keep getting the error using the above code in Grid Initiate:
    
    Error executing OnGridInitialize event handler: command: e.rv.session.newjob = tbl.newjobno Property not found
    tbl.newjobno subelement not found.
    In OnInitalValueCalculate I have:

    Code:
    e.newValues.jobno = e.rv.session.jobno
    e.newVaules.jobno = e.rv.session.newjob
    Up and coming Alphaholic ;)

  4. #4
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,842

    Default Re: UUID - Grid Event

    I thought you were using a Dialog because you used the term Initialize without mentioning Grid. You seem to be approaching this backwards, trying to create a table record before you actually accept any information from the user, in the Grid. How about forgetting trying to pre-create a record and use myjob_id = remspecial(api_uuidcreate()) to create a job_id that, if they don't finish the record, never gets used and never creates a record.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  5. #5
    Member eboughey1's Avatar
    Real Name
    Elena Boughey
    Join Date
    Sep 2008
    Location
    Deltona, FL
    Posts
    166

    Default Re: UUID - Grid Event

    You helped me on this when I had it set up in a dialog. We needed to set up the job id so I could display the auto incremented field value (Client Job #).

    I'm using the alpha 10 beta now because of the Ajax functionality so I need to do the same thing only in a grid.

    I don't really need the job id. What I need to display is that auto incremented number but it says '0'.

    I thought I could utilize the same commands but I don't understand the verbage on all of these grids.
    Up and coming Alphaholic ;)

  6. #6
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,842

    Default Re: UUID - Grid Event

    If your # is dependent on an auto-increment in the table, then you have to create the table record and then display THAT record in the grid to get the number. I am sure, even though I have not looked at it, that the Grid AJAX does not save a record until you submit the page or otherwise save the record.
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  7. #7
    Member eboughey1's Avatar
    Real Name
    Elena Boughey
    Join Date
    Sep 2008
    Location
    Deltona, FL
    Posts
    166

    Default Re: UUID - Grid Event

    So frustrated with this. I wish they would do a video on the events section.

    Okay, since I can't do the above, I'd like to at least set the field 'newjobno' to a session variable then redirect to a dialog page that uses that session variable.

    I tried the below in the 'onpagedirect' and set the submit to <Event> but got a 404 error saying <Self> was not found....

    Code:
    e.rv.session = "newjob"
    e.rv.session.newjob=e.rv.v.r1.newjobno ' 
    e.url="printwo.a5w"
    So now I want to just put the above info in the 'afterinsertrecord' area so when I set the submit to the dialog page it will pull the session variable.

    Now I'm getting the error because I'm not describing the session variable right. What is the format for 'afterinsertrecord' event when setting up a session variable?
    Up and coming Alphaholic ;)

  8. #8
    Volunteer Moderator Steve Wood's Avatar
    Real Name
    Steve Wood
    Join Date
    Nov 2003
    Location
    Bay Area, California
    Posts
    8,842

    Default Re: UUID - Grid Event

    Why do you want to use a Grid as opposed to a Dialog?
    Steve Wood
    Join the ALPHA DEVELOPERS NETWORK
    There is no Cloud. It's just someone else's computer.
    Web - Mobile - Hosting - Products - Frameworks - Developer Resources
    AlphaToGo | IADN (100% Alpha Anywhere Websites)

  9. #9
    Member Bob Moore's Avatar
    Real Name
    Robert Moore
    Join Date
    Jul 2003
    Location
    Boston, MA
    Posts
    443

    Default Re: UUID - Grid Event

    Try

    e.rv.session = "newjob"
    e.rv.session.newjob=e.rv.v.r_1.newjob
    e.url="printwo.a5w"

    In v10 if you are working with a new row that has not been committed the r_ prefix is used, if my memory serves me right.

    You can easily check this with Firebug.

  10. #10
    Member eboughey1's Avatar
    Real Name
    Elena Boughey
    Join Date
    Sep 2008
    Location
    Deltona, FL
    Posts
    166

    Default Re: UUID - Grid Event

    I want to use the grid because of the ajax function (edit combo and auto suggest).

    That's the only reason I'm changing over. I could never get the ajax code right in the dialog form.
    Up and coming Alphaholic ;)

Similar Threads

  1. v10 New Grid Event
    By mmaisterrena in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 08-01-2009, 06:59 PM
  2. Grid Event Format
    By Phil Rolf in forum Web Application Server v7
    Replies: 6
    Last Post: 11-18-2005, 11:20 AM
  3. Auto increment option to use UUID/GUID
    By Al Buchholz in forum Archived Wishlist
    Replies: 5
    Last Post: 01-31-2005, 07:18 AM
  4. Server event for child grid in grid linker page
    By Peter.Wayne in forum Web Application Server v6
    Replies: 1
    Last Post: 10-27-2004, 05:41 PM
  5. guid or uuid
    By Paul in forum Alpha Four Versions 7 and 8
    Replies: 0
    Last Post: 10-25-2002, 10:14 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
  •