Article ID: 174530
Article Last Modified on 10/15/2003
Insert ThisForm.Grid.RecordSource="" before releasing the form or
issuing a 'CLOSE TABLES' command.
-or-
Use a view or SQL Cursor as the record source for the grid.
-or-
Base Grids with multiple record sources on the parent table.
-or-
Instantiate cursors for parent tables prior to instantiating cursors
for child tables.
-or-
Use row buffering instead of table buffering.
SET MULTILOCKS ON
IF !FILE('test.dbc')
CREATE DATABASE test
CREATE TABLE test1 (var1 C(10), PRIMARY KEY var1 TAG var1)
CREATE TABLE test2 (var1 c(10), ;
FOREIGN KEY var1 TAG var1 REFERENCES test1 TAG var1)
ENDIF
SET MULTILOCKS ON
USE test2 IN 0
USE test1 IN 0
SELECT test1
SET ORDER TO TAG var1
SELECT test2
SET ORDER TO TAG var1
SET RELATION TO var1 INTO test1
=CURSORSETPROP('Buffering',5,'test2')
Form.Grid1.ColumnCount=2
Form.Grid1.RecordSourceType=1
Form.Grid1.RecordSource='test2'
Form.Grid1.Column1.ControlSource=test1.var1
Form.Grid1.Column2.ControlSource=test2.var1
=TABLEREVERT(.T.,'test2')
CLOSE TABLES ALL
Release ThisForm
Additional query words: Grid Column ControlSource RecordSource Buffering
Keywords: kbbug kbfix KB174530