I figured it out Cetin, when I requery it gave me then info I needed. Thanks for all your help

Nick Patel


>>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