Guys,
here is my code:
Sub Map (vTableName, vTableId, vFullFileName, vPath)
Let vMapingTable = '$(vPath)Mapping.qvd';
IF (NOT isNull(qvdCreateTime('$(vMapingTable)'))) THEN
Map_Table:
LOAD * From $(vMapingTable);
Concatenate (Map_Table)
LOAD * INLINE [
FullFileName, TableName, TableId
$(vFullFileName), $(vResTable), $(vTableId)
];
ELSE
Map_Table:
LOAD * INLINE [
FullFileName, TableName, TableId
$(vFullFileName), $(vResTable), $(vTableId)
];
ENDIF
Store Map_Table into $(vMapingTable);
Drop Map_Table;
End Sub
This function is supposed to be called many times to store some values in a QVD file.
Here i check if the file exists and if it does then i load that QVD file and then trying to concatenate the current values to it and then store it in QVD file.
In case the QVD file does not exist then I just store the current variables in the QVD file.
It is not working.
First pass goes well i.e. the "ELSE" part of code and it stores the data in QVD file.
During subsequent passes i.e. "IF" part of code is creating problem...during this pass when the control comes to "Store ...." statement then debugger stops running and I see in log that "Map_Table << INLB85" kind of statements there.
Can you please help me what is going wrong here?