I used DTPicker in a form and its connected to a table employee with field name BirthDate with a datatype smalldatetime, but when i edit the record having a "null value", the DTPicker have encounter error " Binding Collection Error.... Field not updatable".
Anybody can help me.
Thanks,
Qazz
Hello!
How a trigger run on specific date and time. I know how to create trigger but as far as I know, trigger only run on insert, update and delete. I create a trigger and I want to run it every first day of the month. If its not possible, any alternative solution?
Thanks,
Qazz
johnwm,
I have 2 datagrid in a form namely Datagrid1 & Datagrid2 and it connected with a table ItemMasterlist and ItemDetails respectively and command button Edit. If the user click Edit Button, they must check which table is to be edit. For example, if the datagrid1 is click before the edit...
I have 2 datagrid in a form and i want to know which datagrid is selected when i click a command button it will identify which datagrid is selected.
Thanks.
Need Help.
I have 2 table.
1. Employee
2. Transdata
employee transdata
empid name empid, unit, price, total
001 AAA 001 2 100 200
001 3 100 300
-----...
Thank you James & SQL Sister.
SQLSister is suggesting that "It is better to set up cascading deletes as these are more efficient than triggers."
How can i do that?
Thanks,
Qazz
Greetings!
Is there a trigger way to delete a particular record on parent table and automatically delete related records on child table?
Thank you,
Qazz
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.