You can use it in personal edition also.
load * inline
Store test into test.qvd(qvd);
then reload once... After that from script, choose table files and select your qvd file from the path where it store.. may be file path is problem for you..
you can remove the test table from script because you will get same data from qvd file itself..
hope it helps
I'm trying to manage a table with 4 million records. So I would like to approach a sort of incremental loading, like load records year by year or month by month
what I mean is this:
load * from mytable where Yearfield = 2011
store test1 into myfile.qvd(qvd)
When I run the script again, I should have:
load * from mytable where Yearfield = 2012
store .... I don't know how to append these records to the existing into Myfile.qvd.
Thanks for your help and advices
First look at your qvd size if it has any data at all. Once sure, that your qvd file has data, then one possibility could be - you have used a DROP command somewhere after the LOAD (from qvd) command, it is not necessary that you drop the same loaded table to lose your table, but sometimes if you are loading two tables with all common fields the later one gets concatenated automatically to the pervious one, therefore if you drop the previous table... you lose your both tables, because there was no second table actually.
see, if this is the case.