Carlos Guzmán Álvarez wrote:
Hello:
Thanks. I just wanted to mention that it is with version 1.7.0.1 of
the provider.
Can you send a sample of the table that is giving you the problem ??
The script to create the table is attached, and below is an insert
statement with the current data. Thanks for your help!
INSERT INTO USERPREFERENCES
(USERID,LOGINNAME,FIRSTNAME,LASTNAME,NICKNAME,EMAILADDRESS,DATEOFBIRTH,PROMPTONEXIT,GENDER,CURRENTSCREENID,CURRENTTRACKID,DESKTOPOBJECTIVEID,DESKTOPROTATESPEED,STARTTIME,ENDTIME,MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,SATURDAY,SUNDAY,IMMEDIATEMIN,IMMEDIATEMAX,SHORTTERMMIN,SHORTTERMMAX,INTERMEDIATETERMMIN,INTERMEDIATETERMMAX,LONGTERMMIN,LONGTERMMAX,LIFETIMEMIN,LIFETIMEMAX,PRETARGETDATEDAYS,REMINDERDISPLAYDELAY,REMINDERSNOOZEDURATION,INSPIRATIONMIN,INSPIRATIONMAX,SPELLCHECK)
VALUES
(3,'KABAK\AKABAK','Amanda','Kabak','Pandax','[EMAIL PROTECTED]','19-APR-1975
00:00:00',0,'F',65,11,NULL,133,'7:00:00 AM','6:00:00
PM',1,1,1,1,1,1,1,0.3,0.7,4,5,5.5,7,12.5,15,26,30,3,209,6,2,4,1);
/******************************************************************************/
/**** Generated by IBExpert 1/29/2006 1:23:45 PM ****/
/******************************************************************************/
SET SQL DIALECT 3;
SET NAMES NONE;
/******************************************************************************/
/**** Tables ****/
/******************************************************************************/
CREATE GENERATOR GEN_USERPREFERENCES_ID;
CREATE TABLE USERPREFERENCES (
USERID SMALLINT NOT NULL,
LOGINNAME VARCHAR(50),
FIRSTNAME VARCHAR(50),
LASTNAME VARCHAR(50),
NICKNAME VARCHAR(100),
EMAILADDRESS VARCHAR(250),
DATEOFBIRTH TIMESTAMP,
PROMPTONEXIT SMALLINT DEFAULT 1 NOT NULL,
GENDER CHAR(1),
CURRENTSCREENID INTEGER,
CURRENTTRACKID INTEGER,
DESKTOPOBJECTIVEID INTEGER,
DESKTOPROTATESPEED INTEGER DEFAULT 5 NOT NULL,
STARTTIME TIME DEFAULT '8:00' NOT NULL,
ENDTIME TIME DEFAULT '17:00' NOT NULL,
MONDAY SMALLINT DEFAULT 1 NOT NULL,
TUESDAY SMALLINT DEFAULT 1 NOT NULL,
WEDNESDAY SMALLINT DEFAULT 1 NOT NULL,
THURSDAY SMALLINT DEFAULT 1 NOT NULL,
FRIDAY SMALLINT DEFAULT 1 NOT NULL,
SATURDAY SMALLINT DEFAULT 1 NOT NULL,
SUNDAY SMALLINT DEFAULT 1 NOT NULL,
IMMEDIATEMIN FLOAT DEFAULT .1,
IMMEDIATEMAX FLOAT DEFAULT .5,
SHORTTERMMIN FLOAT DEFAULT 1,
SHORTTERMMAX FLOAT DEFAULT 3,
INTERMEDIATETERMMIN FLOAT DEFAULT 2,
INTERMEDIATETERMMAX SMALLINT DEFAULT 5,
LONGTERMMIN FLOAT DEFAULT 5,
LONGTERMMAX FLOAT DEFAULT 10,
LIFETIMEMIN FLOAT DEFAULT 7,
LIFETIMEMAX FLOAT DEFAULT 15,
PRETARGETDATEDAYS SMALLINT DEFAULT 3,
REMINDERDISPLAYDELAY INTEGER DEFAULT 30,
REMINDERSNOOZEDURATION INTEGER DEFAULT 10 NOT NULL,
INSPIRATIONMIN INTEGER DEFAULT 1,
INSPIRATIONMAX INTEGER DEFAULT 4,
SPELLCHECK SMALLINT DEFAULT 1 NOT NULL
);
/******************************************************************************/
/**** Primary Keys ****/
/******************************************************************************/
ALTER TABLE USERPREFERENCES ADD CONSTRAINT PK_USERPREFERENCES PRIMARY KEY
(USERID)
USING INDEX IX_USERID;
/******************************************************************************/
/**** Foreign Keys ****/
/******************************************************************************/
ALTER TABLE USERPREFERENCES ADD CONSTRAINT FK_USERPREFERENCES_OBJECTIVEID
FOREIGN KEY (DESKTOPOBJECTIVEID) REFERENCES OBJECTIVEDATA (OBJECTIVEID);
ALTER TABLE USERPREFERENCES ADD CONSTRAINT FK_USERPREFERENCES_SCREENID FOREIGN
KEY (CURRENTSCREENID) REFERENCES MDSCREENINFO (SCREENID);
ALTER TABLE USERPREFERENCES ADD CONSTRAINT FK_USERPREFERENCES_TRACKID FOREIGN
KEY (CURRENTTRACKID) REFERENCES MDLISTOBJECTIVETRACK (OBJECTIVETRACKID);
/******************************************************************************/
/**** Triggers ****/
/******************************************************************************/
SET TERM ^ ;
/******************************************************************************/
/**** Triggers for tables ****/
/******************************************************************************/
/* Trigger: USERPREFERENCES_ID */
CREATE TRIGGER USERPREFERENCES_ID FOR USERPREFERENCES
ACTIVE BEFORE INSERT POSITION 0
AS
begin
/* Trigger text */
if ( (new.USERID is null) or (new.USERID = 0) )
then new.USERID = gen_id(GEN_USERPREFERENCES_ID, 1);
end
^
SET TERM ; ^
/******************************************************************************/
/**** Descriptions ****/
/******************************************************************************/
DESCRIBE TABLE USERPREFERENCES
'Stores user-specific preference information';
/******************************************************************************/
/**** Descriptions ****/
/******************************************************************************/
DESCRIBE TRIGGER USERPREFERENCES_ID
'Creates new ID for userpreferences table';
/* Fields descriptions */
DESCRIBE FIELD USERID TABLE USERPREFERENCES
'Unique identifier for each user';
DESCRIBE FIELD LOGINNAME TABLE USERPREFERENCES
'The login name of the user (includes domain if applicable)';
DESCRIBE FIELD FIRSTNAME TABLE USERPREFERENCES
'User''s first name';
DESCRIBE FIELD LASTNAME TABLE USERPREFERENCES
'User''s last name';
DESCRIBE FIELD NICKNAME TABLE USERPREFERENCES
'User''s nickname';
DESCRIBE FIELD EMAILADDRESS TABLE USERPREFERENCES
'User''s email address';
DESCRIBE FIELD DATEOFBIRTH TABLE USERPREFERENCES
'User''s date of birth';
DESCRIBE FIELD PROMPTONEXIT TABLE USERPREFERENCES
'Indicates if user wants the application to prompt on exit';
DESCRIBE FIELD CURRENTSCREENID TABLE USERPREFERENCES
'Indicates if the user is in the middle of a wizard sequence';
DESCRIBE FIELD CURRENTTRACKID TABLE USERPREFERENCES
'If the user is in the middle of a wizard sequence, indicates the track of that
sequence';
DESCRIBE FIELD DESKTOPOBJECTIVEID TABLE USERPREFERENCES
'If the user has selected to freeze the desktop countdown timer, this is the
objective to display';
DESCRIBE FIELD DESKTOPROTATESPEED TABLE USERPREFERENCES
'number of minutes between changes of displayed objectives on countdown timer';
/******************************************************************************/
/**** Privileges ****/
/******************************************************************************/
/* Privileges of procedures */
GRANT SELECT ON USERPREFERENCES TO PROCEDURE SPCOMPARISONMOSTIMPORTANTSELECT;
