cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

How to insert data into postgreSQL DB ?

jsok
5-Regular Member

How to insert data into postgreSQL DB ?

Hi 

Can anyone help me in regard to this subject with posted capture i attached ?

It would be appreciate if i get a reply from you.

 

 

 

 

이미지 4.png이미지 5.png이미지 6.png이미지 7.png

4 REPLIES 4
PaiChung
22-Sapphire I
(To:jsok)

Does this work if you hardcode the values that you are inserting

to be true/false or 0/1 ?

probably make that work first before going to the input parameters.

jsok
5-Regular Member
(To:PaiChung)

Hello PaiChung

 

Yes that has been worked since EMS created and tested.

Need more reply if you have idea for this post. 

 

 

jsok
5-Regular Member
(To:PaiChung)

hello  PaiChung 

 

It works as attached photo when i clicked Input action but i don't know why.

You pointed the hardcord value are just type by myself ?

If so then how did you know ?

 

 

이미지 1.png

 

이미지 2.png

PaiChung
22-Sapphire I
(To:jsok)

Not too sure, seems like it is at least picking up one value.

are you sure both input parameters have values assigned?

you could try to replace [[is_in_dock]] with just TRUE or FALSE (or 1 / 0)

and see what happens, this at least will confirm a value is written

if that is the case, then most likely you are not providing is_in_dock when the code runs

can it have to do with mapping?

Top Tags