Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Non VFP keywords in WHERE clause
Message
From
14/04/2004 15:20:57
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
 
To
14/04/2004 10:24:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00894713
Message ID:
00894911
Views:
11
Hi
The problem with SPT is that you have little control over what structure VFP make for resulting cursor.
BLOB columns are General type, numeric are 5 digits wider, al decimals are controlled by SET DECIMALS.
I'm sure that are others (I use very often disconnected offline processing).


>You can use SQL Pass Through instead.
>
>
>>Hi all
>>Regarding remote views....
>>Exists some trick other than creating view programatically to specify "non standard" WHERE clauses?
>>More specific, I can include STARTING WITH, CONTAINING, SOME, ANY, etc., keywords in where clause for Firebird server, but, there is no way of doing this in view designer.
>>
>>Thanks.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform