Macro to insert data in database

[#1]

Hi guys,

I need to use a macro to insert just one value in a SQL Server Database.

I'm trying, but I think that my code is something wrong...

What's the best way to do that?

Exemple: insert into test (name) values ('qlikview')

Which code I have to use?

Could you send me a exemple or a qlik file that explain what to do?

Thank you so much.

Regards,

Rodrigo Almeida.

[#2]

Hi,

Is it possible to help me on this.

I have a report where my source is a directory of log files and it loads the files incrementally to a qvd.

and I also have a ODBC connection as follow:

ODBC CONNECT TO EQUIPMENT (XUserId is fYRJFKC, XPassword is VMCHLXL);

is it possible to send the data from the qvd to SQL table

the table name is PhoneReport and it has the same fields as the qvd.

Thxs

[Anonymous]

Did it worked for you?

Thanks

Javier

[Anonymous]

Hello,

I am having an issue with this code. It is working using the QV Desktop but when I publish it in the QV Server and try to do the same (QV 11R2 - IE Plugil - QV Web Server).. it raise a security error. I have checkd in the server, and the option to run unsafe macro is checked.

Any clue?

Thnxs

Javier