Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Update only one Record at a time
Message
From
12/02/2008 09:18:40
Sylvain Larin
Montréal, Quebec, Canada
 
 
To
12/02/2008 09:12:40
Mazahir Naya
Kuwait United Co.
Kuwait, Kuwait
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Update only one Record at a time
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01291752
Message ID:
01291779
Views:
6
If you have no other key to use:
UPDATE MyTable SET TimeOut = NewTimeOut WHERE Date = {^2008/01/01} AND TimeIn == "9:00 Am"
>this is the data i need to update Time-Out Field when i try with UPDATE SQL command it is updating both row.is there way to update only one row..?
>
>Date Time-in Time-out
>01/01/2008 9:00 Am 2:00 pm
>01/01/2008 4:00 pm 10:00pm
Previous
Reply
Map
View

Click here to load this message in the networking platform