Versions des environnements
Network:
Windows Server 2012 R2
>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
Hi Bill,
Is it possible your search is not finding it because the rules for equality vary in SQL from VFP, unless you are using a fully padded parameter value?
In VFP with set exact off (the default) with a 6 char field where the field holds the value abc
? mytable.myfield = "abc" && .T.
in sqlserver
where mytable.myfield = 'abc' && not found
hth,
Hank
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement