topic DynamicUpdateCommand Update problem in QlikView

DynamicUpdateCommand Update problem

Anonymous — Mon, 09 May 2011 06:50:51 GMT

Hi,

I'm trying to use the DynamicUpdateCommand to update posts in a table. I use the following macro


sub Update
set vKat = ActiveDocument.Variables("vKategori")
NewKat = vKat.GetContent.String 
Set Result= ActiveDocument.DynamicUpdateCommand("UPDATE * SET Kategori="&NewKat&" WHERE Index2='2'")
if Result = false then
msgbox Result.ErrorMessage
end if

Later on I want to be able to switsch the "2" in the WHERE statment to a selected field. I've tried that but that doesn't work at all so i'm trying to get this right first.

Thanks in advance!

//A.

DynamicUpdateCommand Update problem

Mon, 09 May 2011 07:46:34 GMT

Hi,

You can try the below command, hope this will work

Set Result= ActiveDocument.DynamicUpdateCommand("UPDATE * SET Kategori='"&NewKat&"' WHERE Index2='"&2&"'")

Thanks & Regards

DynamicUpdateCommand Update problem

Anonymous — Mon, 09 May 2011 07:55:48 GMT

Hi,

No, didn't work. I get "Marco parse failed. Funtionality was lost" when i click OK.

//A.

DynamicUpdateCommand Update problem

Mon, 09 May 2011 08:08:22 GMT

Hi,

try below one and check your Module Security & Local Security

Set Result= ActiveDocument.DynamicUpdateCommand("UPDATE * SET Kategori='"&NewKat&"' WHERE (Index2='2')")

Thanks & Regards

DynamicUpdateCommand Update problem

Anonymous — Mon, 09 May 2011 08:14:13 GMT

Hi,

I worked! Thank you so much!

//A.

DynamicUpdateCommand Update problem

Anonymous — Mon, 09 May 2011 08:19:13 GMT

Hi again,

One more question while we're at it..

If i want to update several fields at the same time?

I tried this just now and it didn't work:

set vKat = ActiveDocument.Variables("vKategori")
NewKat = vKat.GetContent.String

set vSort = ActiveDocument.Variables("vSort")
NewSort = vSort.GetContent.String

Set Result= ActiveDocument.DynamicUpdateCommand("UPDATE * SET Kategori='"&NewKat&"' Sort='"&vSort&"' WHERE (Index2='2')")

Is it possible?

Thanks!

Annika

DynamicUpdateCommand Update problem

Mon, 09 May 2011 08:22:33 GMT

Hi,

Yeah, it is possible

Set Result= ActiveDocument.DynamicUpdateCommand("UPDATE * SET Kategori='"&NewKat&"',Sort='"&vSort&"' WHERE (Index2='2')")

Thanks & Regards

DynamicUpdateCommand Update problem

Anonymous — Mon, 09 May 2011 08:27:01 GMT

Hi,

I've tried the comma too but i get an error message.

I copy pasted yours too but still the same error message:

"The Object doesn't support the method or the property" (translated from swedish to english)

//A.

DynamicUpdateCommand Update problem

Anonymous — Mon, 09 May 2011 09:11:56 GMT

I made a workaround for now, simply just adding another statement like this:

Set Result= ActiveDocument.DynamicUpdateCommand("UPDATE * SET Kategori='"&NewKat&"' WHERE (Index2='"&SameIndex&"')")
Set Result= ActiveDocument.DynamicUpdateCommand("UPDATE * SET Sort='"&NewSort&"' WHERE (Index2='"&SameIndex&"')")

Probably not the prettiest sollution but i works 😃

DynamicUpdateCommand Update problem

erikb — Thu, 25 Aug 2011 11:42:26 GMT

Hi,

I found this post when I tried find solution for my problem. I'm trying to use the DynamicUpdateCommand to update posts in a table too. I would like to use "greater then" in "where" clausule of update statement:

sSQL="UPDATE tab_fs SET U2 = 2 WHERE Rok > 2005"

if I use " = " symbol, update statement work fine, but if I use ">" or "<" I get only empty error window.

I would like to know if it possible use greater or lower in where clausule.

Thanks.