Project

General

Profile

Bug #8032

Deleted records are returned by a preselect query

Added by Stanislav Lomany 6 months ago. Updated 4 months ago.

Status:
Closed
Priority:
Normal
Assignee:
Alexandru Donica
Target version:
-
Start date:
Due date:
% Done:

100%

billable:
No
vendor_id:
GCD
case_num:
version:

History

#1 Updated by Stanislav Lomany 6 months ago

Here's a testcase. A record was preselected by a query and then deleted in the same session. It is still returned by the preselect query. This issue has been in trunk for a long time.

def temp-table tt field f1 as integer.

def var i as integer.
create tt. tt.f1 = 1.
create tt. tt.f1 = 2.

def query q for tt scrolling.
open query q preselect each tt.

def buffer xtt for tt.
find first xtt where xtt.f1 = 1. delete xtt.

get first q.
message tt.f1. // 2 in FWD, 1 in 4GL

#2 Updated by Alexandru Lungu 6 months ago

  • Assignee set to Alexandru Donica
  • Status changed from New to WIP

This is already handled in #5768. There are multiple attempts to fix this (the last one is 5768c). This will be fixed once 5768c is merged.

#3 Updated by Alexandru Lungu 4 months ago

5768a was merged to trunk. This task can be Closed.

#4 Updated by Greg Shah 4 months ago

  • % Done changed from 0 to 100
  • Status changed from WIP to Closed

Also available in: Atom PDF