![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Incident Reports » Incident Reports Addressed for Version 2.03 » View Incident Report |
![]() |
Reported By: Richard Harding Reported On: 7/22/2010 For: Version 2.03 Build 17 |
CREATE TABLE "ClientEpisode" ( "ID" INTEGER GENERATED BY DEFAULT AS IDENTITY (START WITH 281, INCREMENT BY 1) NOT NULL, "ClientID" INTEGER NOT NULL, "EpisodeDate" TIMESTAMP NOT NULL, <more stuff> CONSTRAINT "cePrimaryKey" PRIMARY KEY ("ID") ) CREATE INDEX "ceClientDateIND" ON "ClientEpisode" ("ClientID", "EpisodeDate" DESC) CREATE INDEX "ceClientIND" ON "ClientEpisode" ("ClientID", "EpisodeDate") SELECT * FROM ClientEpisode ORDER BY ClientID, EpisodeDate ASC SELECT * FROM ClientEpisode ORDER BY ClientID, EpisodeDate DESC
This web page was last updated on Wednesday, May 11, 2022 at 07:57 AM | Privacy Policy![]() © 2022 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |