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