Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
(SQL) REPLACE seem not right?
Message
From
04/10/2001 13:22:28
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00564147
Message ID:
00564299
Views:
14
>>
>>REPLACE auth.end WITH DATE(), ;
>>	auth.uplog WITH ALLTRIM(GETENV("USR")) FOR ;
>>	auth.organization = org.organization AND ;
>>	(auth.end > DATE() OR EMPTY(auth.end)) ;
>>	IN auth
>Maybe org table is at EOF?

Good point, but none of the suggestion worked (including other replies)... I did some other tests and found out something SERIOUS else is wrong! You wanta know what it is? Even after a cold reboot, this happens to ANY VFP tables (all of sudden now?):

USE table EXCLUSIVE
BROWSE
--do some manual changes, regardless character, numeric or logical (did each and all of those)
--hit Esc key
BROWSE
--changed record(s) are the same after the changes
--moved around the record pointer (while in the BROW or Command Window)
--all is well...
USE
USE table EXCLUSIVE
BROWSE
--the changes are NOT saved, it's back to square one

For a minute, I am thinking could it be the Novell mirror image or ... ??????? I did not modify the VFP default settings.

Chuck
Today is tomorrow's yesterday.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform