General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hello ,
I would like to have a cursor as result with for each minute of the day a registration value if there is no registration for that period then I will change to .null. value to 0.
ltend=datetime()
ltstart=ltend-7200
*the seconds are changed to zero.
CREATE CURSOR curDates (dDatetime T)
do while ltstart<=ltend
INSERT INTO curdates (dDateTime) VALUES (ltstart)
ltstart=ltstart+60
enddo
SELECT * FROM registrations right JOIN curdates ON Registrations.datetime=curdates.dDatetime ;
ORDER BY curdates.dDateTime into cursor ctest
With this SQL-command I don't get a result the value-field is empty for all the dDatetime-records ??
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only