>SELECT Data.ImageId, Data.Coments, Data.Kit, Data.Date, Data.Field2,;
> Data.Nomber, Pictures.ID, Pictures.Image;
> FROM ;
> Data Data ;
> INNER JOIN pictures Pictures ;
> ON INT(VAL(Data.imageid)) = Pictures.ID;
> WHERE Data.Nomber LIKE ( ?cnomber )
>
>DBSetProp(ThisView,"View","SendUpdates",.T.)
>DBSetProp(ThisView,"View","BatchUpdateCount",1)
>DBSetProp(ThisView,"View","CompareMemo",.T.)
>DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
>DBSetProp(ThisView,"View","FetchMemo",.T.)
>DBSetProp(ThisView,"View","FetchSize",100)
>DBSetProp(ThisView,"View","MaxRecords",-1)
>DBSetProp(ThisView,"View","Prepared",.F.)
>DBSetProp(ThisView,"View","ShareConnection",.F.)
>DBSetProp(ThisView,"View","AllowSimultaneousFetch",.F.)
>DBSetProp(ThisView,"View","UpdateType",1)
>DBSetProp(ThisView,"View","UseMemoSize",255)
>DBSetProp(ThisView,"View","Tables","Data,pictures")
>DBSetProp(ThisView,"View","WhereType",3)
>
>DBSetProp(ThisView+".imageid","Field","DataType","C(50)")
>DBSetProp(ThisView+".imageid","Field","UpdateName","Data.ImageId")
>DBSetProp(ThisView+".imageid","Field","KeyField",.F.)
>DBSetProp(ThisView+".imageid","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".coments","Field","DataType","M")
>DBSetProp(ThisView+".coments","Field","UpdateName","Data.Coments")
>DBSetProp(ThisView+".coments","Field","KeyField",.T.)
>DBSetProp(ThisView+".coments","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".kit","Field","DataType","C(50)")
>DBSetProp(ThisView+".kit","Field","UpdateName","Data.Kit")
>DBSetProp(ThisView+".kit","Field","KeyField",.F.)
>DBSetProp(ThisView+".kit","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".date","Field","DataType","C(50)")
>DBSetProp(ThisView+".date","Field","UpdateName","Data.Date")
>DBSetProp(ThisView+".date","Field","KeyField",.F.)
>DBSetProp(ThisView+".date","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".field2","Field","DataType","C(50)")
>DBSetProp(ThisView+".field2","Field","UpdateName","Data.Field2")
>DBSetProp(ThisView+".field2","Field","KeyField",.F.)
>DBSetProp(ThisView+".field2","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".nomber","Field","DataType","M")
>DBSetProp(ThisView+".nomber","Field","UpdateName","Data.Nomber")
>DBSetProp(ThisView+".nomber","Field","KeyField",.T.)
>DBSetProp(ThisView+".nomber","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".id","Field","DataType","I")
>DBSetProp(ThisView+".id","Field","UpdateName","pictures.ID")
>DBSetProp(ThisView+".id","Field","KeyField",.T.)
>DBSetProp(ThisView+".id","Field","Updatable",.T.)
>
>DBSetProp(ThisView+".image","Field","DataType","W")
>DBSetProp(ThisView+".image","Field","UpdateName","pictures.Image")
>DBSetProp(ThisView+".image","Field","KeyField",.F.)
>DBSetProp(ThisView+".image","Field","Updatable",.T.)