Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sorting data in grid
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00322441
Message ID:
00323165
Views:
29
I have the view in my data envirnoment (data environment contains a view called lv_dposcr and a table called person_tbl) and it seems like it opens the view automatically, where can I define my index tags in data environment. I tried it in my form (frm_dposcr) init proceed as follows

&& frm_dposcr.init
with thisform
lparameters a, b, c && a = dpo name, startdate, enddate
.a = a
.b = b
.c = c
.grd.readonly = .t.
lc_dpo = .a
lc_fdate = .b
lc_tdate = .c
index on my_c tag p_lname
requery('lv_dposcr')
.refresh()
.grd.refresh()
endwith

When I go to run my program it keeps saying "p_lname already exists, overwrite it?" (I think this is because my view is based on my person_tbl. person_tbl is also in my data enviroment). I am not sure where to create the tags if my view is going to open automatically in data environment. My grid is linked to the view so I cannot leave the view out of my data environment otherwise I get errors that my grid cannot find lv_dposcr. Any suggestions. Thanks for answering back.

Nick Patel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform