Situation is the following.
I have a Master dataset:
Code: Select all
SELECT ID, Name FROM TCustomers WHERE ID=:ID
Code: Select all
SELECT ID, Price, CustomerID FROM TOrders WHERE CustomerID =:ID
Code: Select all
SELECT ID, Value, CustomerID FROM TPayments WHERE CustomerID =:ID
Code: Select all
SELECT ID, Value, CustomerID FROM TOrderDetails WHERE CustomerID =:ID
2. Open all detailed Datasets.
2. User is viewing or editing all necessary info
3. Start transaction.
4. Post all Dataset if needed.
5. Commit transaction.
When I need to add new customers I simply change:
2. User is viewing or editing all necessary info -> 2. User INSERT all necessary info
It's OK, but I have to open all datasets and this make "empty" request to the DB server.
So the question is: How can I open dataset (set active=true) without executing DB request?