Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Problem
Message
 
To
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:
00743802
Views:
9
Could you send me your form and all related files (DBF, VCX, etc) so I could take a look?

>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
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform