bbass
Member
Hello, I'm a long time developer but a brand new EntOne Developer, so forgive me if this is a elementary question...I have looked for an answer but have not found it. Basically all I want to do in a form is what the following SQL statment would accomplish:
Update Schema/Table
SET
TblFld = FrmFldB
WHERE
TblFld = FrmFldA
I have a very simple Fix/Inspect form (would this be the correct form type to use for this) with 2 text input fields (FrmFldA, FrmFldB) and a Button (that will process the above SQL logic). I have an appropriate BV associated with the form, however, directly updating the table would be fine also. In the Button Clicked ER, is it a two step process where you would do a Table IO Select, then a Table IO Update to the BV/Table? I've tried both and haven't been able to get it to work. What am I missing to implement this SQL logic with ER? Thank you for your help.
Update Schema/Table
SET
TblFld = FrmFldB
WHERE
TblFld = FrmFldA
I have a very simple Fix/Inspect form (would this be the correct form type to use for this) with 2 text input fields (FrmFldA, FrmFldB) and a Button (that will process the above SQL logic). I have an appropriate BV associated with the form, however, directly updating the table would be fine also. In the Button Clicked ER, is it a two step process where you would do a Table IO Select, then a Table IO Update to the BV/Table? I've tried both and haven't been able to get it to work. What am I missing to implement this SQL logic with ER? Thank you for your help.