Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Problem
Message
From
21/01/2003 11:53:37
Marcus Hüneke
Heidelberger Druckmaschinen
Wiesloch, Germany
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00743708
Message ID:
00743799
Views:
8
Thank you for your quick answer.
I've tried everything. My grid uses an alias (if I use "table" as RecordSourcetype my incremental search doesn't work).
I have two tables, one with the whole data and one with the data out of a SQL query. If I change the recordsource from one to the other table my grid looks fine. But the keypressed event out of the grid's text segment doesn't work any more.
I've tried all "workarounds" out of the FAQ document, but nothing works (even the BeforeRowColChange "trick".
My last try was (

thisform.gridrefreshing =.T.
WITH thisform.grid1
.RecordSource = ""
ENDWITH
sql_stat = "select * from tabelle where substr(upper(matnr),1,len(alltrim(thisform.text1.value)))" +;
"= alltrim(upper(thisform.text1.value)) into table c:\dummyhier"
&sql_stat
SELE dummyhier
WITH thisform.grid1
.RecordSource = "dummyhier"
ENDWITH
thisform.grid1.refresh
thisform.gridrefreshing = .F.


***************************************************************
the grids "BeforeRowColChange" contains
IF PEMstatus(thisform,"GridRefreshing",5) and thisform.gridrefreshing
NODEFAULT
RETURN
ENDIF

// Marcus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform