Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display data in a grid
Message
 
To
14/03/2002 23:26:37
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00633175
Message ID:
00633254
Views:
20
Hi,

You might perform a browse of the cursor just to make sure your SQL is catching more than one record. If it is, you might scroll up the grid to make sure the other records are not hidding above the container. If they are, you may need to go to the first record in the cursor, maybe lock screen and then refresh the grid and set focus to grid and then release lock on screen.

Also, programmically put the "" in the grid's records source property and then put the cursor name into the grid's record source property. This is two separate steps. Also, make sure the grid is set to work with cursor instead of alias. Can't remember what property you use to do this but maybe its the gird's record source type. Also, you might try using alias as the gird's record source type as the cursor should have an alias as assigned by the SQL. When working with grids I almost always use a table alias and use SQL for reports. You can use the display structure command to see what alias foxpro is assigning to you cursor.
Leland F. Jackson, CPA
Software - Master (TM)
smvfp@mail.smvfp.com
Software Master TM
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform