Problem with VB6 App & SQL 2000 (Locking & lost transactions)
Hi,
We are having a big, big problem with our OLTP system.
We have a VB6 App. that receive transactions (TX) via Winsock from an
Access Server (NAC) that comes from Points-of-sales (POS)
The VB 6 App receive the pac...
more >>
I have two tables (in parent-child relationship)
Orders:
Id, Name, Type
Items:
Id, OrderId, Name, Type, Price
I want to do a select so that result looks like
Result:
Orders.Id, Orders.Name, Orders.Type, Count of Items for this Orders.Id
But I cannot figure out how to do this (cou...
more >>