topic AW:syntax error STORE in QlikView

syntax error STORE

chrisg — Fri, 25 Sep 2009 01:24:39 GMT

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

syntax error STORE

Anonymous — Fri, 25 Sep 2009 01:29:51 GMT

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.

syntax error STORE

Fri, 25 Sep 2009 03:08:33 GMT

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"

AW:syntax error STORE

chrisg — Fri, 25 Sep 2009 12:52:05 GMT

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

syntax error STORE

biester — Fri, 25 Sep 2009 13:06:19 GMT

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

AW:Re: syntax error STORE

chrisg — Fri, 25 Sep 2009 14:19:15 GMT

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

AW:Re: syntax error STORE

chrisg — Fri, 25 Sep 2009 14:19:24 GMT

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

AW:Re: syntax error STORE

biester — Fri, 25 Sep 2009 14:28:59 GMT

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

syntax error STORE

Fri, 25 Sep 2009 14:31:01 GMT

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

AW:Re: AW:Re: syntax error STORE

chrisg — Fri, 25 Sep 2009 14:43:14 GMT


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

AW:Re: syntax error STORE

chrisg — Fri, 25 Sep 2009 14:48:08 GMT


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

AW:Re: AW:Re: syntax error STORE

chrisg — Fri, 25 Sep 2009 15:05:40 GMT

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

AW:Re: AW:Re: syntax error STORE

biester — Fri, 25 Sep 2009 15:06:24 GMT

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

AW:Re: AW:Re: syntax error STORE

biester — Fri, 25 Sep 2009 15:15:17 GMT

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

AW:Re: AW:Re: AW:Re: syntax error STORE

chrisg — Fri, 25 Sep 2009 15:16:46 GMT


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

AW:Re: AW:Re: AW:Re: syntax error STORE

chrisg — Fri, 25 Sep 2009 15:23:32 GMT


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

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

AW:Re: AW:Re: AW:Re: syntax error STORE

biester — Fri, 25 Sep 2009 15:37:54 GMT

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

AW:syntax error STORE

rbecher — Fri, 25 Sep 2009 15:45:49 GMT

Hi Christoph,

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

- Ralf

syntax error STORE

Fri, 25 Sep 2009 16:03:57 GMT

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

AW:Re: syntax error STORE

chrisg — Fri, 25 Sep 2009 16:31:14 GMT


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