Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
? in INSERT-SQL
Message
De
14/02/2006 02:42:06
 
 
À
14/02/2006 02:30:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Divers
Thread ID:
01095826
Message ID:
01096073
Vues:
18
>This is a standard local view definition (actually, I've got it from View Designer window)
>
>
>SELECT Accesslog.id, Accesslog.userid, Accesslog.computerid,;
>  Accesslog.logindatetime, Accesslog.logoutdatetime;
> FROM appdata!AccessLog;
> WHERE  Accesslog.userid = ?vpUserId
>
>
>So it definately supports ? in Selects.
>
>My guess would be VFPT has added ? to SELECTS because they need them in views. Given the fact View Designer cannot be used to construct an INSERT or an UPDATE view, they didn't need ? for those, hence ? is not supported anywere beside SELECTss. However, I think ? should be supported.

Which is exactly what I wrote i message#1095839. To me this makes perfectly sense, but I also agree that the VFPT should add the same syntax option to Insert and Update, to be consistent. Which reminds me of one of my other long time wishes, namely that they make Where and For interchangable in scopes. I don't know how many times I have written Browse where something in stead of Browse for something. The VFPT's answer to my request? "Will this sell more copies of VFP?"....

>Maybe a new entry in WishList for Sedna? :)
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform