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

[chrisg]

Kuldeep Tak wrote:
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<div></div>

Sorry to say - does not work!

Chris

[chrisg]

Hi Joachim,

here ist the LOG:

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

25.09.2009 10:00:41: Start der Skript-Ausführung
25.09.2009 10:00:41: QlikView Version:8.50.6206.5

........

25.09.2009 10:00:41: General Script Error
25.09.2009 10:00:41: Fehler bei der Ausführung
25.09.2009 10:00:41: Ende der Skript-Ausführung

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

And now??

Thx

Chris

[biester]

Settings / Document Properties / Tab "General" / check "Generate Logfile".

bzw in der deutschen QlikView Fassung:

Einstellungen / Eigenschaften des Dokuments / Reiter "Allgemein" / "Log Datei anlegen" anhaken.

You can also try to comment out your original LOAD statement and instead load an inline table (similar to the one in my demo) and store it. Anyway we have to find out whether it's the load or the store ...

Rgds,
Joachim

[biester]

and nothing between "QlikView Version: " and "General Script Error" ???? You left out the most essential lines, the ones immedietaly before the "General Script Error"

Rgds,
Joachim

[chrisg]

biester wrote:
You can also try to comment out your original LOAD statement and instead load an inline table (similar to the one in my demo) and store it. Anyway we have to find out whether it's the load or the store ... <div></div>

i did - and this is working fine!

Thx

Chris

[chrisg]

biester wrote:
and nothing between "QlikView Version: " and "General Script Error" ???? You left out the most essential lines, the ones immedietaly before the "General Script Error"
 <div></div>

sorry: - i thougt there is nothing spez.
----------------------------------------------------------------------

25.09.2009 10:00:41: Start der Skript-Ausführung
25.09.2009 10:00:41: QlikView Version:8.50.6206.5
25.09.2009 10:00:41: 0002 SET ThousandSep='.'
25.09.2009 10:00:41: 0003 SET DecimalSep=','
25.09.2009 10:00:41: 0004 SET MoneyThousandSep='.'
25.09.2009 10:00:41: 0005 SET MoneyDecimalSep=','
25.09.2009 10:00:41: 0006 SET MoneyFormat='€ #.##0,00;-€ #.##0,00'
25.09.2009 10:00:41: 0007 SET TimeFormat='hh:mm:ss'
25.09.2009 10:00:41: 0008 SET DateFormat='DD.MM.YYYY'
25.09.2009 10:00:41: 0009 SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]'
25.09.2009 10:00:41: 0010 SET MonthNames='Jän;Feb;Mär;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez'
25.09.2009 10:00:41: 0011 SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So'
25.09.2009 10:00:41: 0014 Directory
25.09.2009 10:00:41: 0015 Main:
25.09.2009 10:00:41: 0016 LOAD [L/R],
25.09.2009 10:00:41: 0017 Land,
25.09.2009 10:00:41: 0018 Periode,
25.09.2009 10:00:41: 0019 Artikel,
25.09.2009 10:00:41: 0020 Bezeichnung,
25.09.2009 10:00:41: 0021 [EAN-Code],
25.09.2009 10:00:41: 0022 Menge,
25.09.2009 10:00:41: 0023 Preis,
25.09.2009 10:00:41: 0024 Nettowert
25.09.2009 10:00:41: 0025 FROM Export.xls (biff, embedded labels, table is [Tabelle1$])
25.09.2009 10:00:41: 9 Felder gefunden: L/R, Land, Periode, Artikel, Bezeichnung, EAN-Code, Menge, Preis, Nettowert, 228 Sätze erhalten
25.09.2009 10:00:41: 0040 STORE Land From Main INTO test.qvd
25.09.2009 10:00:41: General Script Error
25.09.2009 10:00:41: Fehler bei der Ausführung
25.09.2009 10:00:41: Ende der Skript-Ausführung

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

[biester]

Okay, then it obviously is a combination of the LOAD and STORE - I've to think it over and open my eyes widely - perhaps it's soemthing very near and we just don't see it, like:

"Was ist das Schwerste von allem?
Was dir das Leichteste dünket.
Mit den Augen zu sehen,
was vor den Augen dir lieget." (Goethe)

😉 Rgds,
Joachim

[rbecher]

Hi Christoph,

I tried your script and it works on QV9 SR1. So, I would suggest to call support.

- Ralf

[#10]

Hi

are you missing the FIELD? I mean STORE FIELD Now FROM Main INTO Test.qvd?

[chrisg]

Jeanne Petersen wrote:
Hi
are you missing the FIELD? I mean STORE FIELD Now FROM Main INTO Test.qvd?<div></div>

i think the SYNTAX is:

STORE[ *fieldlist FROM] tabelle INTO filename

best regards
Christoph