General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Setting up relation on index view
I'm not sure if I am going about this correctly, but what I am trying to do is create a relation between two views. What I have is a parent view called lv_veh (primary key is v_id, and I have a child view called lv_ser (foreign key is s_id). In DataEnvironment.Init I create the indexes. I'm not sure how to create a relation between lv_veh.v_id and lv_ser.s_id. Is it also ok to create two indexes on view in dataenvironment as shown below?
What I am after is when I move to different record in lv_veh, I what the child lv_ser records to display correct linked records in a grid. For example if lv_veh.v_id = 20, then I want all lv_ser to show me all records s_id = 20.
CURSORSETPROP('buffering',3,'lv_veh')
SELECT lv_veh
INDEX ON v_id TAG v_id
CURSORSETPROP('buffering',5,'lv_veh')
CURSORSETPROP('buffering',3,'lv_ser')
SELECT lv_ser
INDEX ON s_id TAG s_id
CURSORSETPROP('buffering',5,'lv_ser')
Thanks
Nick Patel
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only