Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
... and then I fell off my chair.
Message
From
03/10/2001 11:58:31
 
 
To
03/10/2001 09:48:52
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00563467
Message ID:
00563678
Views:
16
Cetin,

>Pascal,
>Works right in VFP5.0. 2 things I can think of :
>1) There is another value same as deleted one and not deleted.
>2) set deleted is off for session (scoped to current session)
>Cetin

It seems we have a different version VFP5.0. Mine is VFP5.0a. I can easily reproduce this problem on my machine :

set deleted on
select mytable
delete all
select * from mytable && result is fine : empty cursor
select max(myfield) from mytable && bad result : single line cursor with a value

I don't believe I'm doing something wrong or overlook something, do I ?

Pascal.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform