Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seconds()
Message
De
11/02/2019 06:58:19
 
 
À
11/02/2019 06:30:47
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01666213
Message ID:
01666254
Vues:
73
Thanks sir for help.
Group mean only BATCH not Date

You applied command on where date change
But I need it on change.

Sir you applied codes on my previous table
Here is new table which I posted in previous post like this
CREATE CURSOR Cetin(id n(2),date t,batch n(4),nSeconds n(6))
INSERT INTO Cetin values(1,{^2019-02-08 01:25:28 AM},1,	0)
INSERT INTO Cetin values(2,{^2019-02-08 01:25:29 AM},1,	0)
INSERT INTO Cetin values(3,{^2019-02-08 01:25:55 AM},1,	0)
INSERT INTO Cetin values(4,{^2019-02-09 02:28:29 AM},2,	0)
INSERT INTO Cetin values(5,{^2019-02-09 02:50:18 AM},2,	0)
INSERT INTO Cetin values(6,{^2019-02-09 08:59:17 PM},2,	0)
INSERT INTO Cetin values(7,{^2019-02-09 10:25:39 PM},2,	0)
INSERT INTO Cetin values(8,{^2019-02-12 03:05:19 AM},5,	0)
I added id and batch field in this.

Please see nSeconds is equal to 0 where new batch comes



Thans sir
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform