>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