Hi Raoshan, if you declare your keys as Identities this should not happen.
>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
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould