With constant search in Forum and also thinking of Get and Set External PV SS, I

harshav over 8 years ago

With constant search in Forum and also thinking of Get and Set External PV SS, I am still not able to get update One PV of Date and Time type using IFM Manager Could some one Help me in this.
This is my Scenario,
I am having a CDT which contains text, Primary Key and other types which includes a Date and Time as well,
Using IFM manager I am able to update the values for PK and Text values using the below query.
"UPDATE_PMI " & 454 & " SET PV PK = [" &updatePK& "]"&", PV Text1 = [""" &UpdateText1& """]"&", PV Text2 = [""" &pv!UpdateText2& """]"

But when I try adding Date and Time Field it is throwing me an error I updated it like this adding to the above query
PV Date1 = [""" &UpdatedDate1& """]". I also tried with removing the 2 "" and tried as the way like integer, but it is giving me an error like found 9 tokens after parsing.
Could someone suggest how to do it for date and time field.

Discussion posts and replies are publicly visible

Parents

0 harshav over 8 years ago

@sagarI511, thanks for suggesting , It didn't work even , My problem is How many double Quotes we have to give for a Date field, it is not in which we will pass the double quotes, if I pass "" this also it is accepting, not that I need to pass it as char(34), but I am not sure of how many I have to give for Date field in IFM manager, Any thoughts on this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 harshav over 8 years ago

@sagarI511, thanks for suggesting , It didn't work even , My problem is How many double Quotes we have to give for a Date field, it is not in which we will pass the double quotes, if I pass "" this also it is accepting, not that I need to pass it as char(34), but I am not sure of how many I have to give for Date field in IFM manager, Any thoughts on this.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data