Re: #delete after form update

Harald Kapper writes: 

> On Tue, 03 Aug 2004 16:06:38 -0500, "cjackson" <cjackson@xxxxxxxxxxxxxxxx>
> wrote: 
>
> > I'm in pretty dire straits. After updating a form, the new record appears as 
> > #delete in all fields. The record is revealed after closing and reopening 
> > the form. I googled and found one other person having this problem with no 
> > solution.  
> >
> > W2K, Myodbc 3.51, Mysql, latest MDAC and Jet  
> >
> > Any ideas. This is really important because thousands of records must be 
> > input every day.
> > Thanks,
> > Craig Jackson
>
> afair this was an faq once :) 
>
> you got to add a timestamp column afaik to prevent this. 

Yes, I read this FAQ but it was in the context of #delete in updating table 
and not the form showing data immediately. Nonetheless, I added timestamp 
and it worked. Thanks. That was one of the many close calls in my life with 
open source. 

Craig Jackson 


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@xxxxxxxxxxx