Archives of the TeradataForum
Message Posted: Thu, 22 May 2003 @ 22:11:11 GMT
Open the Query in Design Mode.
1. Right Click on Open Portion of Query.
2. Find Properties and Click it. You will find the Following Window.
__________________ Query Properties Description...... ---- ---etc RecordsetType....Dynaset ---- ---- ---etc Order By ....... ___________________
3. Please set the Recordsettype = Snapshot. Run the Query , you should get the Results.
Fields in snapshots. While most queries return recordsets that you can edit, some queries return snapshots, which can't be edited.
4. Some more Explanation for RecordsetType The RecordsetType property uses the following settings.
Setting Description Visual Basic
Dynaset (Inconsistent Updates)
Siva K Vetukuri.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|