Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do you tie a Grid to a cursor?
Message
De
24/10/2007 16:57:46
 
 
À
24/10/2007 16:19:42
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Divers
Thread ID:
01263332
Message ID:
01263342
Vues:
17
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform