update table automatic using temp variable

Jigar Patel

hello everyone,

i am confused how can i do not know pls help me:-

i use three table. name is 1) ExpectedVisitorTable 2) GatePassTable

now first I insert record in Expected Visitor c# Form and save record in ExpectedTable.

then i get Expected Visitor's record show on GatePass Form. and then i save record in GatePass Table and then automatic update expected visitor table's fileld name is expectedentry 0(zero) (note- expectedentry default value is 0(zero) but i want to update to 1(one))

now how can i update automatic expectedentry field. which query i use to update???

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Francis Susaimichael10y ago
now how can i update automatic expectedentry field. which query i use to update???

You need to consider to use triggers.You should create trigger on the "GetPass" table.

CREATE TRIGGER reminder1
ON GetPass
FOR INSERT AS
UPDATE ExpectedVisitor set expectedentry ='A'

Hope this helps!
Prem Anandh J10y ago
use triggers in your database and update the ExpectedVisitorTable field when record modified in GatePass.
refer triggers.