Hi All,

I've developed a Visual Foxpro 7.0 Application with SQL-Server Database for a Retail Shop. At times the Application at Point-of-sale hangs up in the heavy rush. If I see into the table of POS then there is a NULL value in the Primary Key Column (cm_no) of the Cashmemo Master (cmm) and several NULL values in the Foreign Key Column (cm_no) of the Cashmemo Detail (cmd) table, both columns are designated as NOT NULL at the time of creation, and if I see the detail of table with 'sp_help cmm' then also it shows that this column is NOT nullable.

The whole application at all counters (there is only ten billing counters) remain hanged unless I delete the rows having NULL value from the respective tables (cmm and cmd)

It has become very irritating as there is heavy rush at the billing counter and a shut of 5 mins causes a big problem for them.

Please help me out to this problem...


Thanks


Raoshan