Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Odd Remote View Behaviour
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01622374
Message ID:
01622375
Vues:
57
>Have setup a Remote View to an Access Database with the following Code:
>
>
>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.)
>
>
>Whenever I attempt to Edit this View, I get a Syntax Error Message Box Dialog. After clicking OK I can run the View but it always comes up with an empty result set no matter what is entered for the View Parameter. Could this be an issue caused by the spaces in the Access Database?

Yes, could be, but first try replacing this:
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.

Regards.-
Fernando D. Bozzo
Madrid / Spain
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform