Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Odd Remote View Behaviour
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Odd Remote View Behaviour
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:
01622374
Vues:
56
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?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform