syntax error STORE

[chrisg]

Hi,

i want to log some dataand try to store the data into a QVD

-----------------------------------------------------------------------------

Directory;
Main:
LOAD [L/R],
now() AS Now,
filename() AS Filename,
Land
FROM [Export file ECD008247M für Februar 2009.xls] (biff, embedded labels, table is Tabelle1$);

STORE Now FROM Main INTO test.qvd;

-----------------------------------------------------------------------------

the debugger is running to the end put when i close the debugger window the pop-up with an error msg appers

i am using QV 8.5

thx

Chris

[Anonymous]

Chris,
I don't think you can use store like this, just one field from a table. The syntax is
STORE Main INTO test.qvd.
Certainly you can create another table that contains only one field, and store this new table.

[#3]

To accomplish what your asking should be..

Main:
LOAD [L/R],
now() AS Now,
filename() AS Filename,
Land
FROM [Export file ECD008247M für Februar 2009.xls] (biff, embedded labels, table is Tabelle1$);

Table_To_Store:

LOAD

Now

RESIDENT Main;

STORE Table_To_Store INTO MYQVD.QVD;

This will load only that single field "Now"

[chrisg]

Thx,

but the syntax should be:

STORE[ *fieldlist FROM] tabelle INTO filename

*fieldlist::= ( * | field ) { , field } )

so simply the question: what is wrong with

STORE Now FROM Main INTO test.qvd;

Thx

Chris

[biester]

Chris is right, the syntax he uses should be correct (at least I cannot see any errors). I checked it with enclosed app, and it works like a charm (though I'm using QV 9.0 SR1). According to the manual it should also work in 8.5.

But the jumping point would be: which error ARE you getting, Chris? Perhaps you mustn't write to the directory you try to store the qvd to.

Rgds,
Joachim

[chrisg]

Many thx! - your app is running but it does not work with :

FROM [Export file ECD008247M für Februar 2009.xls] (biff, embedded labels, table is Tabelle1$);

biester wrote:
But the jumping point would be: which error ARE you getting, Chris? Perhaps you mustn't write to the directory you try to store the qvd to.
 <div></div>

only the Pop-UP ??

Any Idea

Thx

Chris

[chrisg]

Many thx! - your app is running but it does not work with :

FROM [Export file ECD008247M für Februar 2009.xls] (biff, embedded labels, table is Tabelle1$);

biester wrote:
But the jumping point would be: which error ARE you getting, Chris? Perhaps you mustn't write to the directory you try to store the qvd to.
 <div></div>

only the Pop-UP ??

Any Idea

Thx

Chris

[biester]

Generate a logfile and look what it says. Where does the error occur? It seems it's not the STORE, but the LOAD-command. Have you tried a more compact filename than [Export file ECD008274M für Februar 2009.xls] ? Perhaps you could try to copy the file to eg. EXFILEFEB2009.xls and then try to load from this.

Rgds,
Joachim

[#9]

Dear Chris,

The problem is not with the store command.

The problem is in the excel sheet name you are using.

FROM [Export file ECD008247M für Februar 2009.xls] (biff, embedded labels, table is Tabelle1$);

instead try using:

FROM [Export file ECD008247M für Februar 2009.xls] (biff, embedded labels, table is [Tabelle1$]);

and you should be able to reload.

Thanks & Best Regards,

Kuldeep Tak

[chrisg]

biester wrote:
Generate a logfile and look what it says. Where does the error occur? It seems it's not the STORE, but the LOAD-command. <div></div>

Sorry - but how can i Do that?

biester wrote:
It seems it's not the STORE, but the LOAD-command. Have you tried a more compact filename than [Export file ECD008274M für Februar 2009.xls] ? Perhaps you could try to copy the file to eg. EXFILEFEB2009.xls and then try to load from this.
 <div></div>

thx but - no diffrent

best regards
Chris