VFP crash the grid

[foxteam1]

Hi

with VFP9 SP1 , big trouble in a FORM:
in LOAD : open FILE1 with buffering mode 5
open FILE2 with a SET KEY TO cPubVar (link with FILE1), buffering mode 5 also

in the Form i have a GRID2, properties :
RecordSource with FILE2
RecordSourceType "Alias"

I add a data in the grid (INSERT INTO FILE2 VALUE (.....))
I make a click on the GRID2 ==> Visual foxpro 9 crash

Any idea,thanks

Frank

 

[dgrewe]

My favoriate trick for that is to create a temp table in the structure I need for the grid (TmpTable2)

Load or Init
Create TmpTable2
Uee TmpTable2 Exclu


in Lost Focus of control that would change the grid2
Select ..... to cursor TmpCursor
Select TmpTable2
Zap
Append from TmpCursor
thisform.grid2.refresh()
thisform.grid.setfocus()


David W. Grewe (Dave)

 

[Mike Lewis]

Frank,

You'll have to be more specific. What exactly happens when "Visual Foxpro 9 crash". What error message?

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[foxteam1]

Thanks

the message
Microsoft Visual FoxPro has encountered a problem and needs to close. We are sorry for the inconvenience.

i do this
add a data in the grid (INSERT INTO FILE2 VALUE (.....))
lauch a modal form ( dataenvironnement open/close file .F.) with 2 texts box.
I quit this form, click on the grid and VFP crash

 

[Mike Lewis]

Frank,

This sort of error is extremely difficult to track down. It doesn't happen because of anything you are doing wrong. It's more likely to be an internal problem within VFP.

The only thing I can suggest is that you start building the form again. Start with an empty form, and then add one bit at a time until it starts crashing again. That will at least help you narrow it down.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[DSummZZZ]

Frank,

You may want to start with a 'fresh' table too. If you've crashed it repeatedly, the table or index(es) could be trashed also.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[ilyad]

In addition you may want to delete (move) foxuser.dbf

Check also

http://fox.wikis.com/wc.dll?Wiki~C0000005ExError

and similar links in WiKi

 

[foxteam1]

Thanks all

I have tried to replace
open FILE2 with a SET KEY TO cPubVar (link with FILE1)
By
open FILE2 with a SET FILTER TO myFIELD=cPubVar
and it seems to be ok now but ugly !
I see that a grid with RecordSourceType="Alias" and RecorDSource as at table don't works wery well with empty data (with a Cursor RecordSource it's ok).

Frank