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

[biester]

@Jeanne:

No, there is no STORE FIELD, Chris's syntax is correct, it is:

STORE [fieldlist FROM] table INTO .....

Rgds,
Joachim

[prieper]

Have you checked, whether there are entries for "Land", think that you get this error also when trying to save a table or a field, which has no content.

Peter

[biester]

@Peter,

I checked, but I cannot confirm that. Even if I read in the field with Null() as Land there doesn't seem to be any problem.

Rgds,
Joachim

[prieper]

@ Joachim,

Is probably then the .qvd blocked by another application (or previously crashed QV)? Have you tried to store into a new name?

Peter

[biester]

Chris,

you could try two things:
- Make sure that before executing the script/reloading there is NO test.qvd in the target directory to find out if QVD is blocked and cannot be overwritten (as Peter suggests).

- Create a brand new qvw and copy the script to the new qvw and try again.

If both things don't help, I think it's really better to pass it to support.

Rgds,
Joachim