>If I insert a value into a view, then try to find the value from the view by selecting to an array, the value doesn't appear. The array returns back empty. I know the insert was successful because when I go and look at the table, the data is there. I'm I doing something wrong here?
>
>

>cursorsetprop('sendupdates', .T.,'lv_veh')	
>Insert into lv_veh(v_no) value (alltrim(.txtv_no))
>tableupdate(.t., .t., 'lv_veh')
>vno = alltrim(.txtV_no.value)
>select lv_veh.v_id FROM lv_veh WHERE ALLTRIM(lv_veh.v_no) == ALLTRIM(vno)   into array a__gen2

>
>Thanks
>Nick Patel

Nick,
There is .txtv_no and .txtv_no.value in code. Very rarely I saw you could have a property and object with same name but not even sure how to replicate.

Would this work right ?

Insert into lv_veh(v_no) values (.txtv_no.value)
tableupdate(.t., .t., 'lv_veh')
vno = .txtV_no.value
select lv_veh.v_id ;
  FROM lv_veh ;
  WHERE lv_veh.v_no == m.vno ;
  into array a__gen2
if _Tally > 0
 wait window 'Worked '+trans(a_gen2)
endif

PS: You don't need alltrim unless it's for left trimming.
Cetin