Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update only one Record at a time
Message
De
12/02/2008 09:18:40
Sylvain Larin
Montréal, Québec, Canada
 
 
À
12/02/2008 09:12:40
Mazahir Naya
Kuwait United Co.
Kuwait, Kuwait
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Re: Update only one Record at a time
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01291752
Message ID:
01291779
Vues:
7
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform