ADP Checkbox / Recordset trouble 
Author Message
 ADP Checkbox / Recordset trouble

Hello All,

I have a problem with this scenario:

SQL Server 2000 database, table 'table1' with bitfield named 'bit1'
Trigger FOR UPDATE on table1, set's values on 'table2', does not
change any values on table1.

ADP, Form in Datasheet view, Checkbox control bound to 'bit1'.

Problem :
When I update the row on my form, all columns work a-OK EXCEPT when I
change the checked value on checkbox 'bit1'.

Symptom :
After checking 'bit1', the record is updated and the trigger is
executed correclty, but then I cannot navigate off the current record.
 Arrow keys, mouse-click on another record's cells, mouse-click on
another record's record-selector, use of navigation bar, all do not
allow a move off the current record.
Only when the recordset of the form is reset (some other vba code does
this for me) do I recover correct functionality.

Please tell if you have this problem, if you have a solution, and if
you have some idea as to the reason for this issue.

Thanks in advance !!

Peter J. Fitzgibbons
ATG Networks, LLC - Systems Engineer



Wed, 01 Sep 2004 03:08:30 GMT
 ADP Checkbox / Recordset trouble

You, definetely how to look at the trigger syntax. Maybe you could email it
to me.

Quote:
> Hello All,

> I have a problem with this scenario:

> SQL Server 2000 database, table 'table1' with bitfield named 'bit1'
> Trigger FOR UPDATE on table1, set's values on 'table2', does not
> change any values on table1.

> ADP, Form in Datasheet view, Checkbox control bound to 'bit1'.

> Problem :
> When I update the row on my form, all columns work a-OK EXCEPT when I
> change the checked value on checkbox 'bit1'.

> Symptom :
> After checking 'bit1', the record is updated and the trigger is
> executed correclty, but then I cannot navigate off the current record.
>  Arrow keys, mouse-click on another record's cells, mouse-click on
> another record's record-selector, use of navigation bar, all do not
> allow a move off the current record.
> Only when the recordset of the form is reset (some other vba code does
> this for me) do I recover correct functionality.

> Please tell if you have this problem, if you have a solution, and if
> you have some idea as to the reason for this issue.

> Thanks in advance !!

> Peter J. Fitzgibbons
> ATG Networks, LLC - Systems Engineer




Wed, 08 Sep 2004 06:30:30 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Secure ADP, Distribute ADP and copy ADP

2. Trouble setting up an ADP database

3. Trouble with trapping SQL2000 errors in ADP

4. Troubles with ADP-View

5. Me.Recordset, bound checkbox, Access 2002 crash

6. Bug Report: DateTimePicker Checkbox and empty Recordset

7. Checkbox format in datagrid not showing checkboxes

8. Checkbox format in datagrid not showing checkboxes

9. Recordset not updateable in ADP - tried everything

10. Setting a ADP Report Record Source to a Recordset

11. mdb vs adp - opening a recordset

12. Access 2000 (adp) form recordset updates


 
Powered by phpBB® Forum Software