Simple LOAD question

[alexis]

Hi all,

In my applicartion I have a need to create a table (I call it "ReloadTimes") that contains some data from a QVD file as well as some "local" information (see below to see what I mean.

Try as I might I always end up with just the one row (the content of the QVD file). The "local" stuff does not get added - I am sure it is something simple but it's Friday afternoon and my brain s already in "weekend" mode.

Regards

Alexis

LET vThisAppReloadTime=Now();

ReloadTimes:

LOAD      Source,

                  ReloadTime

FROM

[Welfare_ReLoadTime.qvd]

(qvd);

LOAD 'ApplicationReload'     As Source,

     '$(vThisAppReloadTime)'  As ReloadTime;

//     $(vThisAppReloadTime) As ReloadTime;

[#2]

Hi,

there is missing resident on the end:

LOAD 'ApplicationReload'     As Source,

     '$(vThisAppReloadTime)'  As ReloadTime resident ReloadTimes;

[#3 · Accepted solution]

resident is missing, but should be as follows:

table2:

LOAD * INLINE [

    F1, F2

    ,'$(vThisAppReloadTime)'

];

LOAD 'ApplicationReload'     As Source,

     '$(vThisAppReloadTime)'  As ReloadTime resident table2;

This will add new row to the ReloadTimes table.

regards

[daveamz]

Hi,

Or you can use directly:

LET vThisAppReloadTime=Now();

ReloadTimes:

LOAD      Source,

                  ReloadTime

FROM

[Welfare_ReLoadTime.qvd]

(qvd);

LOAD * INLINE [

    Source, ReloadTime

    ApplicationReload,'$(vThisAppReloadTime)'

];

Regards,

[alexis]

Very helpful - thanx!

[alexis]

Thank you for your swift response.

Alexis