Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

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.

5 Replies
Not applicable

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

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


Not applicable

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

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.

Not applicable

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

Hi Rajesh,

Please refer the attached sample document.

Thnaks,

Anoop

Not applicable

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

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);

Not applicable

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

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 

Community Browser