Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Click Method in a Grid
Message
From
06/08/2001 19:09:59
 
 
To
06/08/2001 19:00:59
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00540439
Message ID:
00540457
Views:
17
>Hi Nancy:
>
>Thank you for your response. I implemented your idea and got a VFP message saying:
>
>"Expression is not valid ouside of WITH/ENDWITH"

Er. Okay, probably means you have a syntax error in the line. *g* Probably a .Something that should be before the endwith. Or a .Something that shouldn't have the dot. IAC, I really didn't mean to distract you from the real issue.

>
>The reason I was redefining the captions for the grid was that when I did the Select statement to repopulate the grid, the field heading were displayed in lowercase as identified in the field name of the table's structure.

Right just more reason to think it's the problem with the recordsource.

Set the .RecordSource to ""
Do the Query.
Reset the .RecordSource.

What you do if you redo the select is you've close the table the grid is using, so it revers to a blank one. Then you reselect and it will be filled in with all it's defaults. default captions, textboxes, etc.
Previous
Reply
Map
View

Click here to load this message in the networking platform