Board index » delphi » Inconsistent view of data Paradox VS MS SQL
Kevin Davidson
Delphi Developer |
Mon, 06 Aug 2001 03:00:00 GMT
Inconsistent view of data Paradox VS MS SQL
In a nutshell, if one is processing a group of rows from a Paradox
dataset and changes a column so as to make a row no longer matching the select clause, the BDE loses its little mind (specifically it's record pointer) and skips over other rows. This was found with Delphi c/s 3.02 and BDE 4.51. When the same program was run with MS SQL Server and SQL Links, it worked OK. When the following program was run with Paradox, the displayed numbers procedure TForm1.Button1Click(Sender: TObject); RequestLive := False; SQL.Text := 'select * from QERYOVER where LETTER_NUMBER = 0'; while not EOF do begin Close; ShowMessage('Result set contains: ' + IntToStr(reccnt) + ' records, end; EEEK! -- |