Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seconds()
Message
From
11/02/2019 06:58:19
 
 
To
11/02/2019 06:30:47
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 10
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01666213
Message ID:
01666254
Views:
72
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform