>Hi,
>
>I converted my VFP data using Sedna Upsizing Wizard to SQL Server 2012. The data is all there and when I accessed using remote view I was able to view the data and do all searches. When I created a new main record it was created on the server. The problem is when I search for it in my app It says it's NOT FOUND!
>
>I then created a child record on data I already converted and that record was able to be read BUT when I searched for it, it also was not found!
>
>Any clues to why the newly created record on SQL Server exists but is not able to be found on my app?
>
>
>Thanks, You all have been great helping me through this conversion.
>
>Bill
PMFJI, looks like you are doing your search on remote views which are not "refreshed"? (Check Requery). For example you might have a remote view for "Customers" but do a direct insert into that by not using the RV (maybe SPT) or via another language from somewhere else, then your remote view would not be aware of that record until you requery it (it doesn't work like chatty fox tables):
Requery('myCustomersViewAlias')