Hi All

VFP8.0.

I have just hit one that I can’t figure out and I don’t think it is a VFP problem but I need so help with how VFP works so I can get this working again. I am using Sybase Adaptive Sever Anywhere for my database. I have been using this database for years without problems. I use SQL pass through for all my data access. I change buffering to 5 on all my cursors that I wan to update to track what rows have been changed.

Friday, I upgraded to a new version (a patch or bug fix) and started getting an error doing a replace that said a column cannot be null when the database says it can be. It seems that using a multi-table join for a query causes the problem. If I just use a select * from table I don’t see this problem. My question is how does VFP decide if a column in a cursor should be nullable or not and if there is a way to override this behavior.

Thanks.