Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grids and SPT
Message
From
04/12/1999 11:02:15
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Grids and SPT
Miscellaneous
Thread ID:
00298661
Message ID:
00298661
Views:
53
I'm probably missing something basic but....

I have a cursor build from an SQL Passthrough to a Oracle backend. I want to display the results of the sql in a grid. The grid's RecordSourceType is set to '1 - Alias' and the RecordSource to the name of the cursor. When I fetch the cursor (and verify that it has data) then run the form containing the grid, nothing shows in the grid.

If I change the RecordSourceType to '4 - SQL Statement' and the RecordSource to 'Select * from sqlresults into cursor gridcursor' the data appears in the grid (but is now read only). I'd rather not have the additional select statement and a couple of the columns need to be updateable.

Any Thoughts?

Thanks
Mark
Next
Reply
Map
View

Click here to load this message in the networking platform