Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
? in INSERT-SQL
Message
From
14/02/2006 02:30:06
 
 
To
13/02/2006 15:48:05
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01095826
Message ID:
01096071
Views:
19
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.

Maybe a new entry in WishList for Sedna? :)
Grigore Dolghin
Class Software.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform