topic Re: Button->properties->Actions->Dynamic update->SQL INSERT INTO ?? in QlikView

Button->properties->Actions->Dynamic update->SQL INSERT INTO ??

Sun, 30 Jun 2013 22:01:06 GMT

Hello i'll like to know if is that possible ?? (i'm french and my qlikview is in french so i don't know english word)

Button->properties->Actions->Dynamic update-> ( and here do "SQL INSERT INTO table_name (column_name) VALUES (name_value); )

that work in qlikview script but i need it, in this button ^^ if you have if you have syntax that interested me.

I working on error log file (.txt) and I trying to create a module which can extract desired information through QlikView.

Re: Button->properties->Actions->Dynamic update->SQL INSERT INTO ??

Fri, 06 Dec 2013 06:11:51 GMT

Yes, dynamic update can be used for inserting values in to a table.

Use this syntax;

insert into Table_Name(Field_Name) values('Value needs to be inserted')

Thanks,

Anoop

Re: Button->properties->Actions->Dynamic update->SQL INSERT INTO ??

Fri, 06 Dec 2013 09:04:39 GMT

Hi Anoop,

I have tried the mentioned syntax and Values are not getting inserted to the field.

Could you please elaborate bit in detailed.

Thanks in Advance.

Rajesh.

Re: Re: Button->properties->Actions->Dynamic update->SQL INSERT INTO ??

Fri, 06 Dec 2013 09:20:39 GMT

Hi Rajesh,

Please refer the attached sample document.

Thnaks,

Anoop

Re: Button->properties->Actions->Dynamic update->SQL INSERT INTO ??

Fri, 06 Dec 2013 11:08:15 GMT

Hi Anoop,

It was really gud and could you please explain how you have taken this:

Fruits:

LOAD Name

FROM

Dyn.xlsx

(ooxml, embedded labels, table is Fruits);

Re: Re: Button->properties->Actions->Dynamic update->SQL INSERT INTO ??

Fri, 06 Dec 2013 11:52:04 GMT

Hi Rajesh,

I am just loading 3 rows of data using the load script. Remaining data has been added through dynamic update statement written in the text object action. Please check the Action written in the text object.

Please let me know if this helps.

Thanks,

Anoop