Alpha Video Training
Results 1 to 3 of 3

Thread: Save records for Group-Variables

  1. #1
    "Certified" Alphaholic
    Real Name
    John Koh
    Join Date
    Jan 2004
    Location
    Maryland, USA
    Posts
    1,077

    Default Save records for Group-Variables

    Hi All,

    I have 3 property-Grid layout in one xdialog and each variables are pointer variables. I am wonder how to save the values into table.
    1st Property-grid variables as pMain.Id, pMain.Qty, pMain.Prdct....
    2nd Property-grid variables as pCove.Id, pCove.qty, pCove.Prdct, pCoveOc ...
    3rd Property-Grid variables as pOth.Id, pOth.qty. pOth.Prdct ...

    I want to save it to table as
    *Result table record in single table.
    Line_A pMain.Id pMain.qty pMain.Prdct pCove.id pCove.Prdct pCove.Oc more..
    Line_B pOth.Id pOth.Qty pOth.Prdct pOth. more..
    Line_C

    or One to Many structure.

    My parent_Table stored the "pMain" and "pOth" pointer variables data.
    The other variables as pCove.Id, pCove.qty, pCove.Prdct, pCoveOc ... save to Child table with Parent_table_Id.

    Result in the Parent table
    ParentLine_A pMain.Id pMain.qty pMain.Prdct pMain.more..
    ParentLine_B pOth.Id pOth.Qty pOth.Prdct pOth. more..
    ParentLine_C

    Result in the Child table
    ChildLine_A Parent_Id pCove.id pCove.Prdct pCove.Oc more..
    ChildLine_B

    Does anyone has any solution?

  2. #2
    "Certified" Alphaholic MoGrace's Avatar
    Real Name
    Robin
    Join Date
    Mar 2006
    Location
    Los Angeles
    Posts
    3,686

    Default Re: Save records for Group-Variables

    Where do the values in the xd vars come from now?
    Robin

    Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

  3. #3
    "Certified" Alphaholic
    Real Name
    John Koh
    Join Date
    Jan 2004
    Location
    Maryland, USA
    Posts
    1,077

    Default Re: Save records for Group-Variables

    Hi Robin,

    It came from data entry and I want to store to one_to_many table structure.

    My initial solution is
    * created three case UDF which is save the group of variables to same table(One table). My UDF works well but too many fields are blank records in the table.

Similar Threads

  1. Group Breaks : xbasic function to retrieve those records under the group
    By username1234 in forum Mobile & Browser Applications
    Replies: 0
    Last Post: 06-23-2015, 10:28 PM
  2. Auto save. Records are saved witn no need to press save record
    By MikeData in forum Alpha Five Version 11 - Desktop Applications
    Replies: 23
    Last Post: 07-23-2013, 03:07 PM
  3. Cannot Save Group GUID
    By MichaelCarroll in forum Application Server Version 10 - Web/Browser Applications
    Replies: 10
    Last Post: 01-18-2011, 10:19 AM
  4. Variables won't save
    By russ Boehle in forum Alpha Five Version 5
    Replies: 8
    Last Post: 10-16-2003, 05:16 AM
  5. User and Group Variables
    By David Priest in forum Alpha Five Version 5
    Replies: 2
    Last Post: 07-25-2003, 11:10 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
  •