Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid RecordSource
Message
 
To
30/09/1997 14:02:56
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00052419
Message ID:
00052485
Views:
40
>>Hello Maria,
>>By any chance are you opening your table in an area greater than
>>255, if this is the case you will have a GPF for sure, that is
>>a known problem in VFP, you can not populate a grid with a table
>>that is open in a workarea greater than 255. That happens when you
>>use SELECT(1) to have an empty workarea or USE MyTableName in 1.
>>Hope this helps.
>
>
>Also, do you know if this problem is fixed in VFP 5.0?
>
>Maria

I am glad that I could help,
The problem is documented in the Knowledge Base, the article
number is Q141950 , they fixed the problem in 5.0a, I don't
know about 5.0. They say that it happens when you change the
recordSource property, but I think it happens even if you don't do
that.

Here is exactly what the article says :

PSS ID Number: Q141950
Article last modified on 01-08-1996
PSS database name: FOXPRO

3.00

WINDOWS


---------------------------------------------------------------------
The information in this article applies to:

- Microsoft Visual FoxPro for Windows, version 3.0
---------------------------------------------------------------------

SYMPTOMS
========

A general protection (GP) fault occurs when you change the RecordSource
property of a column in a grid.

CAUSE
=====

The GP fault may be caused by opening a table in area 256 or greater. For
example:

USE TEST IN SELECT(1)

This uses the last available work area, usually 32767.

STATUS
======

Microsoft is researching this behavior and will post new information here
in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION
================

Steps to Reproduce Behavior
---------------------------

1. Create a free table called Test with two fields named First and Last.
Make both fields Character(10). Enter a couple of rows of sample data.

2. Create a blank form.

3. Add a grid to your form and change its ColumnCount property to 1.

4. Add a command button to your form, and place the following code in its
Click event:

THISFORM.Grid1.Column1.ControlSource = "last"

5. Add the following code to the Init event of your form:

USE TEST IN 256
THISFORM.Grid1.RecordSource = "test"

6. Run the form, and click the command button.

The GP fault occurs with details similar to the following information:

VFP caused an invalid page fault in
module KERNEL32.DLL at 0137:bff858c0.
Registers:
EAX=7fd89e61 CS=0137 EIP=bff858c0 EFLGS=00010202
EBX=009dfe28 SS=013f ESP=008e0000 EBP=008e03bc
ECX=00000000 DS=013f ESI=815958c0 FS=3be7
EDX=c001ebf0 ES=013f EDI=815a8f08 GS=0000
Bytes at CS:EIP:
55 a1 78 c2 fb bf 8b ec 83 ec 70 8b 08 53 56 89
Stack dump:
ffecbad7 008e0030 008e0014 0000000e
00000004 c0000005 00000000 00000000
7fd89e61 00000002 00000000 7fd89e61
0001001f 00000000 00000000 00000000

Additional reference words: 3.00 VFoxWin
KBCategory: kbtool kbprb
KBSubcategory: FxtoolFormdes
=============================================================================
Copyright Microsoft Corporation 1996.
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould
Previous
Reply
Map
View

Click here to load this message in the networking platform