>SELECT Universal_data."social security number", Universal_data."last name", Universal_data."first name" > FROM "Universal Data" Universal_data > WHERE Universal_data."last name" = ?vp_last > ORDER BY Universal_data."last name", Universal_data."first name" > >DBSetProp(ThisView,"View","SendUpdates",.F.) >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",CHR(34)+"Universal Data"+CHR(34)) >DBSetProp(ThisView,"View","WhereType",3) >DBSetProp(ThisView,"View","ParameterList","vp_last,'C'") > >DBSetProp(ThisView+".social_security_number","Field","DataType","C(50)") >DBSetProp(ThisView+".social_security_number","Field","UpdateName",CHR(34)+"Universal Data"+CHR(34)+"."+CHR(34)+"social security number"+CHR(34)) >DBSetProp(ThisView+".social_security_number","Field","KeyField",.F.) >DBSetProp(ThisView+".social_security_number","Field","Updatable",.T.) > >DBSetProp(ThisView+".last_name","Field","DataType","C(50)") >DBSetProp(ThisView+".last_name","Field","UpdateName",CHR(34)+"Universal Data"+CHR(34)+"."+CHR(34)+"last name"+CHR(34)) >DBSetProp(ThisView+".last_name","Field","KeyField",.F.) >DBSetProp(ThisView+".last_name","Field","Updatable",.T.) > >DBSetProp(ThisView+".first_name","Field","DataType","C(50)") >DBSetProp(ThisView+".first_name","Field","UpdateName",CHR(34)+"Universal Data"+CHR(34)+"."+CHR(34)+"first name"+CHR(34)) >DBSetProp(ThisView+".first_name","Field","KeyField",.F.) >DBSetProp(ThisView+".first_name","Field","Updatable",.T.) >>
CHR(34)+"Universal Data"+CHR(34)+"."+CHR(34)+"first name"+CHR(34)with this:
["Universal Data"."first name"]
And for the other fields do the same, to see what happens.