topic Viewing data inserted with DynamicUpdateCommand in QlikView

Viewing data inserted with DynamicUpdateCommand

Anonymous — Sat, 10 Nov 2012 05:50:22 GMT

After using the DynamicUpdateCommand to insert data, do i need to do anything else to see the new data in my tables?

Thanks.

Joao.

Re: Viewing data inserted with DynamicUpdateCommand

Anonymous — Sat, 10 Nov 2012 07:21:57 GMT

Nope. But remember that the data only persists in the session. If you want it to be available in a later session make sure that the data is being loaded into the data model with regular intervals.

Re: Viewing data inserted with DynamicUpdateCommand

Anonymous — Sat, 10 Nov 2012 07:44:52 GMT

Thanks Johannes.

i think the problem is that the insert is not even working. Unfortunately, I get a null error message, so don't know what the problem could be. perhaps you will have some ideas?

The table I'm trying to update (by inserting new values) has the following fields:

$Syn 1

BmAssetClass

BmDataSource

BenchmarkName

BmPortfolioManager

BmReturnType

ReturnDate

BmReturn

My insert statement looks like this:

set result = ActiveDocument.DynamicUpdateCommand ("INSERT INTO Benchmark (ReturnDate,BMReturn,BenchmarkName,BMDataSource) VALUES ("&retdate.Text&","&bmret.Text&",Constructed,MLR)")

I'm pulling the two values that I need (retdate and bmret) from a table where they are calculated from data that I pulled from R from a multiple linear regression. Could the problem be that I have left certain fields blank (BmAssetClass, BmPortfolioManager, BmReturnType), or because there is a synthetic key ($Syn 1)?

Thanks.

Joao.