on 06-17-2008 1:57 PM
How can we transfer Query Print Layout Template on machine to another machine ?
hi sandeep,
Use copy express to copy QPLD from one database to
another database.
Jeyakanthan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
89 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.