Skip to Content
author's profile photo Former Member
Former Member

Searching Table

How can we transfer Query Print Layout Template on machine to another machine ?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 05:11 PM

    Sandeep,

    Below is a SQL Script to copy Print Layouts from one Db to another, which includes Query Print Layouts.

    The query is based on the author of the PLD form, so if you open your Query Print Layout in PLD.

    Go to the PLD Menu

    Click "Display Document Properties"

    Change the Author to your name

    Now in the first part of the script, type the source and destination databases and type the author you used into the script.

    This will take every PLD by that author and copy it to the other db.

    Hope this helps,

    Brad Windecker

    ==================================================

    sorry, the formatting isn't working here. email me if you need the query.

    bwindecker@omegagroup.com

    Edited by: Brad Windecker on Jun 17, 2008 7:11 PM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 05:20 AM

    Hi Dear ,

    QLD is stored in database.There is master and Details tables for QLD.Master Data is stroed in "RDOC" and Details part is stored in "RITM" tables.

    You need to update two tables for coping the qld's. named "RDOC" and "RITM"

    Please follow the following steps

    Step 1) Note the Document Number of the QLD which is being copied.

    You can get the Document Number of the QLD as

    Open the QLD >Right click on any part of the Document >Display Document Properties-->Note the "Document ID" say "USRP0103"

    Step 2) Use the Following Script

    BEGIN TRAN

    INSERT INTO (Keva_Live_160508).(dbo).(RDOC) -- Destination Database

    SELECT (keva_live_010408).(DBO).(RDOC).* FROM --source database

    (keva_live_010408).(DBO).(RDOC) --source database

    WHERE (keva_live_010408).(DBO).(RDOC).DOCCODE ='USRP0103' --source database

    INSERT INTO (Keva_Live_160508).(dbo).(RITM) -- Destination Database

    SELECT (eva_live_010408)(BO).(RITM).* FROM --source database

    (eva_live_010408).(dbo).(RITM) -- source database

    WHERE (keva_live_010408).(DBO).(RITM).DOCCODE ='USRP0103'-- source database

    COMMIT TRAN

    Please Note : Use [ instead of ( in the above qry.

    Hope this will help you...

    If you need hlp document which i created email me on

    mahendra1909@gmail.com

    Warm Regards,

    Mahendra

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 18, 2008 at 05:51 AM

    hi sandeep,

    Use copy express to copy QPLD from one database to

    another database.

    Jeyakanthan

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.