What is the syntax?

[#1]

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.

[jagan]

Hi,

Give table name in update query, UPDATE YourTableName SET.

Regards,

jagan.

[#3]

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.