What is the syntax?

Tue, 20 Nov 2012 11:33:52 GMT

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.

Re: What is the syntax?

jagan — Tue, 20 Nov 2012 13:15:54 GMT

Hi,

Give table name in update query, UPDATE YourTableName SET.

Regards,

jagan.

Re: What is the syntax?

Tue, 20 Nov 2012 14:16:26 GMT

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.

topic What is the syntax? in QlikView

What is the syntax?

Re: What is the syntax?

Re: What is the syntax?