cancel
Showing results for 
Search instead for 
Did you mean: 

Searching Table

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member187989
Active Contributor
0 Kudos

hi sandeep,

Use copy express to copy QPLD from one database to

another database.

Jeyakanthan

Former Member
0 Kudos

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

Former Member
0 Kudos

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