Click here to Skip to main content
15,899,314 members

Comments by bayotle (Top 13 by date)

bayotle 22-Apr-16 19:36pm View    
I did already! ;)
Thanks for the kick!
bayotle 22-Apr-16 12:53pm View    
Thanks, that pushed me in a different direction that may or may not be a valid solution but for now the initial problem is resolved.

I added the cb.ConflictOption and took a quick 'peek' and then got the idea to replace * with the fields I was actually updating and it worked..

a day wasted on trying to correct an issue in the db just so I could resume recoding other issues!

Thanks!
bayotle 22-Apr-16 10:43am View    
Actually yes, and the date1/date2 work fine for 100's of records, the date_modified and date_entered work for one record but if I try to update multiples, it fails on update (where marked)
bayotle 22-Apr-16 4:47am View    
Thanks for the quick reply!
Actually those lines do work, it's the date_modified / date_entered line that's failing...
The other lines were test code to see wth was going on! ;)
bayotle 11-Apr-16 7:10am View    
Thanks but that's related to vb6, no way I can see to set Keycode = 0