Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you tie a Grid to a cursor?
Message
From
24/10/2007 16:57:46
 
 
To
24/10/2007 16:19:42
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Miscellaneous
Thread ID:
01263332
Message ID:
01263342
Views:
16
>I've used grids with tables and views (both local & remote) without any problem but now I want to create a grid that is tied to a cursor that I created on the fly with "CREATE CURSOR." I can't seem to make it work. I've name the cursor "Temp" and am selecting the datasourcetype/datasource as "Alias/Temp" and the columns all reference temp.column_names. I can select and BROWSE the grid and see the records but when I try and refresh the grid it just comes up blank. How do it tie the two together?
>
>Thanks,
>Robert

Hi Robert,

Tip;
After you create cursor, you make simple copy to hard disc
using copy to command. It will create free table on your hard disc.
After that you will be able to build grid using grid builder and
use it on your form without much hustle.
After you build grid with builder,
you remove free table added by builder to your form.DE
(if DE is what you use to open tables), and make sure cursor is available prior to grid init.
You can create cursor in load method of the form, or if form uses default datasession prior instantiating form.

Otherwise, as Cetin advised, you can set it all up at run time
column by column.

hth
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Previous
Reply
Map
View

Click here to load this message in the networking platform