>Hi there,
>
>I have got a form using optimistic, when I add a new record my indexes are not updated ! When I remove the buffering code and set the table to no buffering everything is ok.
>
>Where should I start ?
>
>Regards,
>
>Xavier
Two things:
1) After the TableUpdate(), issue the FLUSH command.
2) Turn off all write cache on the server.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer