David,

Thank you for taking the time to post these quirks.

Roderick

>Roderick,
>
>I am using version 2.0.27. I think this version is for vfp6? I think there is another version for vfp7 only?
>
>Anyway, in the version I am using, I have come across three things so far:
>
>1) (I just discovered this one today) For the view properties, if you specify a fetch size of -1 (which you can do programmatically), you get a vfp error - Property value is out of bounds. I am working with remote views, I don't know if this applies to local views.
>
>2)The interface for creating a new view, i.e. clicking the new button, does not work right if it is the first thing you do, i.e., that you don't open an existing view first.
>
>3) There is a button on the the field properties page 'fix update names' I think that it is designed to put a ! in the update name for local views, not sure. With a remote view, I'm not sure under what circumstances this will be true, but, there are times when the update name needs be prepended with dbo.
>I think this is when the update table has dbo. prepended to it also. Anyway, I have found that I have to go in and manually prepend the dbo. prefix, otherwise, I get an error at runtime - I think the error is - no tables property specified - use the tables property of the cursor - or similar.
>
>Other than these things it works great for me. I have advised Steve of these 3 things, so hopefully they will be addressed in version 3.
>
>HTH
>
>
>>Hello David,
>>
>>I like Mr. Sawyer's View Editor too, however I am interested in the quirks that you have uncovered. Can you post your discoveries please?
>>
>>Peace.
>>
>>Roderick
>>
>>>Rodolfo,
>>>
>>>I am using Stephen Sawyer's View Editor. It lets you type in the sql code directly, and has many other advantages over the native vfp view editor as well. Erik Moore also has a view editor and other view tools.
>>>
>>>You can get Stephen Sawyer's editor from:
>>>
>>>http://wwww.geeksandgurus.com
>>>
>>>I really like using it. It saves me a lot of time. If you elect to use it, let me know, there are a couple of little quirks that I can tell you about that might trip you up.
>>>
>>>
>>>>will be good idea that in Visual foxpro 8, in the View Designer, SQL View Window, the code should be Modifiable