Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is the syntax?

Hi All,

I have a issue.

I have written the vb script like below

strHospitalQry = "Select * from HospitalRooms_Chunk"

set rstAuthors = cn.execute(strHospitalQry)

rstAuthors.MoveFirst

Do Until rstAuthors.EOF

Dim vPatientName

Dim vID

Dim vRoom

Dim vCheckIn

Dim vAttending

vPatientName=rstAuthors("PatientName")

vID=rstAuthors("ID")

vRoom=rstAuthors("Room")

vCheckIn=rstAuthors("CheckIn")

vAttending=rstAuthors("attending")

msgbox  vPatientName  /// It returns result as "Vivek"

SET Result =ActiveDocument.DynamicUpdateCommand ("UPDATE * SET Room='"&vRoom&"',PatientName='"&vPatientName&"',CheckIn='"&vCheckIn&"',attending='"&vAttending&"' WHERE ID='"&vID&"';") / But This Query is not working

please let me know the syntax of this

Thanks In advance.

Regards,

Kabilan K.

2 Replies
jagan
MVP
MVP

Hi,

Give table name in update query, UPDATE YourTableName SET.


Regards,

jagan.


Not applicable
Author

Hi jagan,

Thanks a Lot....

It is working.

Error Reason is --> I forgot to check the Dynamic update check box under the Server Tab in Dcoment Properties.

Regards,

Kabilan K.