Delphi - TStoredProc.Close (does it empty the set?)

Question

LEGACY ALERT - This is for Delphi 5 code. (I know it is super old. It is scheduled to be rewritten.... Some day.)

I am using the BDE and the TStoredProc object. When I call Close, this normally clears my dataset. However, I am seeing weird things happen so I thought I would ask this question.

If I have manually added rows to the dataset (i.e. via the Append method) then when I call close are they going to be deleted as well?

Values are being posted to the database that have no relation to the current set. (I am wondering if I have old data hanging round.) — Vaccano, Oct 01 '09 at 15:12

score 1 · Answer 1 · answered Oct 01 '09 at 00:00

1

Not sure with D5 and BDE, but I would say that you have to do an explicit Post to ensure the added record is actually stored.

answered Oct 01 '09 at 00:00

Francesca

21,452
4
49
90

score 0 · Answer 2 · answered Jan 21 '10 at 10:14

0

if you dont post they should be getting deleted

answered Jan 21 '10 at 10:14

Jonathan D

1,364
2
12
30

Delphi - TStoredProc.Close (does it empty the set?)

2 Answers2