Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Assigning the cursor data into a grid.
Message
De
01/04/2003 10:20:45
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
01/04/2003 09:42:39
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00772383
Message ID:
00772409
Vues:
6
>lcSource = "SELECT cn_no, cn_desc FROM chgnotce ;
>WHERE chgnotce.project_no = projno ;
>AND chgnotce.workpkg_no = workpkgno ;
>AND DELETED() = .f. ;
>ORDER BY project_no, workpkg_no ;
>into cursor lcSource"
>
>Could you please tell me how i can assign the two columns data from cursor lcsource into a grid. which is grid1 which has two columns both text boxes.
>
>
>Thank you very much.

with myGrid
.RecordSource = ""
.RecordSourceType = 4 && SQL
.RecordSource = lcSource
endwith

PS: Break the lcSource into smaller literals and use something different from lcSource for cursor name.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform