- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Using variables for filenames...
I need to create QVD's for either production or test side and looking to use parameterized to variables to simplify the scripts.
For example
Test side - folder1\subfolder1\project\tablename-test.qvd
Prod side - folder2\subfolder2\project\tablename-prod.qvd
LET vEnvironment = 'prod';
LET vFolder = if(vEnvironment='prod','folder2\subfolder2\','folder1\subfolder1');
SET vQVDFilename = $(vFolder) & 'project\' & $1 & '-' & $(vEnvironment) & '.QVD';
//$1 is the tablename
STORE thistable INTO $(vQVDFilename('table')) (qvd);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Assuming that your QVW file is in the root folder's project, try this:
Let vTestPath = '..\folder1\subfolder1\project';
Let vProdPath = '..\folder2\subfolder2\project';
STORE ThisTable INTO $(vTestPath)\QVDFilename.qvd;
STORE ThisTable INTO $(vProdPath)\QVDFilename.qvd;
Hope this help.
Regads,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I need the table in the QVD filename so
\Prod-Table-QVD.qvd
or
\Test-Table-QVD.qvd
I want to have a single set of store commands for test or prod.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
LET vEnvironment = 'prod';
if '$(vEnvironment)' = 'prod' then
Let vPath = '..\folder2\subfolder2\project\Prod-';
else
Let vPath = '..\folder1\subfolder1\project\Test-';
end if
STORE YourTempTable INTO $(vPath)TableName-QVD.qvd;