Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Build Grid after a select statement.
Message
From
21/04/2000 00:36:20
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Build Grid after a select statement.
Miscellaneous
Thread ID:
00362128
Message ID:
00362128
Views:
56
Hi all,

I have a form with some options and then based in a select statement i want to populate a grid, but i get an error,

select * ;
from jbfic!familias A ;
left outer join jbfic!familiascli B ;
on b.c_codcli = lcCli ;
and a.c_codigo = b.c_codigo ;
order by a.c_codigo ;
into cursor cursor1

ThisForm.Grid1.recordsource="cursor1"
ThisForm.Grid1.columncount=4
thisform.Grid1.column1.width=55
thisform.Grid1.column2.width=125
thisform.Grid1.column3.width=45
thisform.Grid1.column4.width=45

thisform.Grid1.column1.text1.controlsource = c_codigo_a
thisform.Grid1.column2.text1.controlsource = c_descri ----> ERROR:The data source for this object must be a variable reference. And then ignores the above 2 lines.
thisform.Grid1.column3.text1.controlsource = n_desc1
thisform.Grid1.column4.text1.controlsource = n_desc2
THISFORM.GRID1.REFRESH()

I have 6 fields in cursor1 but i only need to show 4. My Cursor1 have c_codigo_a,c_descri,c_codigo_b,c_codcli,n_desc1,n_desc2.

Thank's in Advance.

João Batista
Next
Reply
Map
View

Click here to load this message in the networking platform