General information
Title:
There is a NULL value in
Environment versions
Network:
Windows 2000 Server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only