2. PHPRunner General questions
  3. Multi Master Detail
This topic is locked

Multi Master Detail

 		3/9/2006 00:02:20
PHPRunner General questions
D
 davidmylien author

Hi! admin :
A. Does PHPRunner 3.0 support Multi Master Detail ?

  1. I have PO tables : PO_Heads ,PO_Lines ,PO_Line_shipments
    PO:

    po_head_id (pk)
    PO_Lines

    po_lines_id (pk)

    po_head_id (fk)
    PO_Line_shipments

    po_shipment_id (pk)

    po_lines_id (fk)

    po_head_id (fk)
  2. I want to let my user can add/edit/ PO and fulfille po lines and po shipments in same screen ,

    How can I do it ?
    B. Does PHPRunner 3.0 support MySql 5.0 ?

    especially MySql has new feature that support view .
    C. Thanks for your kindly help.
    David Lien
Sergey Kornilov admin 3/9/2006

David,
A. 1. You can make PO_Lines as master for PO and PO_Line_shipments as master for PO_Lines. You can go to PO_Lines from PO and then go to PO_Lines_shipments from PO_Lines.
2. Theoretically you can do it using View and events. Create new View with all fields from PO_Lines and PO_Lines_shipments, use this view on the EDIT/ADD pages and then add some custom code to Before record updated/added events on the Events Tab.
B. PHPRunner 3.0 support MySql 5.0.
D
 		davidmylien author 3/10/2006

Hi Sergey !

  1. Thanks for your quickly reply.
  2. Can you give me a set of sample code for reference ?

    for I'm a new user of php & mySql.
  3. By the way , Can I have the sample code of live demo 1 & demo 2 ?
  4. Thanks again.
    David Lien
Sergey Kornilov admin 3/13/2006

David,

  1. Unfortunately, we don't have a ready to go solution for this.
  2. To receive the sample code of live demo please send a letter to [email=support@xlinesoft.com]support@xlinesoft.com[/email].
D
 		davidmylien author 3/13/2006

Hi: Sergey

  1. I sent a mail to support@xlinesoft.com ,

    but got following delivery staus nofification ,
  2. Could Please help me to transfer my request (sample code of demo 1 & 2) to

    support team.
  3. Thanks for your kindly help.
    David Lien
    my e-mail : davidmylien@gmail.com
    This is an automatically generated Delivery Status Notification
    Delivery to the following recipient failed permanently:
    support@xlinesoft.com.
    Technical details of permanent failure:

    PERM_FAILURE: SMTP Error (state 9): 550 not local host xlinesoft.com., not a gateway
    ----- Original message -----
    Received: by 10.37.13.12 with SMTP id q12mr229973nzi;

    Mon, 13 Mar 2006 04:41:05 -0800 (PST)

    Received: by 10.36.104.5 with HTTP; Mon, 13 Mar 2006 04:40:35 -0800 (PST)

    Message-ID: <fc7ccc770603130440m63b48ee1k@mail.gmail.com>

    Date: Mon, 13 Mar 2006 20:40:35 +0800

    From: "=?BIG5?B?RGF2aWQgTGllbiCzc6n6xKM=?=" <davidmylien@gmail.com>

    To: support@xlinesoft.com.

    Subject: request for sample code of phprunner live demo ( both 1 & 2)

    MIME-Version: 1.0

    Content-Type: multipart/alternative;

    boundary="----=_Part_13787_22032818.1142253635954"
    ------=_Part_13787_22032818.1142253635954

    Content-Type: text/plain; charset=ISO-8859-1

    Content-Transfer-Encoding: quoted-printable

    Content-Disposition: inline
    Hi ! Support :
  4. I had downloaded phprunner 3.0 for testing from 2 weeks ago ,

    and I would like to have your sample code of live demo ( both 1 & 2)

    for reference.
    ----- Message truncated -----