Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Assigning the cursor data into a grid.
Message
From
01/04/2003 10:20:45
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
01/04/2003 09:42:39
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00772383
Message ID:
00772409
Views:
5
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform