[RBASE-L] - Re: Datetime issue

[A. Razzak Memon]

At 01:50 PM 1/11/2014, Tom Hart wrote:

I don't know if this is unique to me but here goes. Somehow
in one of my databases(looking for answer) my time format is
changing from HH:MM AP to HH:MM:SS and creating a problem. I
have 2 different tables that use a datetime stamp and if it
is set to HH:MM:SS it says an invalid datetime value but
setting it to HH:MM AP it works fine. I have been working
on this particle database and somewhere have set the format
wrong and I will find it. I have never had this issue, does
anyone else have same results.  Like I said if all I do is
change from one to the other defines whether it works or not

Tom,

That is a typical symptom of importing/incorporating a table,
view, form, external form, label, report, etc., from another
database or source that overrides such settings while being
incorporated.

You can always make your database settings consistent by
simply enforcing the EXACT settings in your application
startup file regardless of multiple CFGs, etc.

Here's an example of application startup routine.

-- Sample Application Startup File
-- Set Default Settings
   SET QUOTES=NULL
   SET QUOTES='
   SET DELIMIT=NULL
   SET DELIMIT=','
   SET LINEEND=NULL
   SET LINEEND='^'
   SET SEMI=NULL
   SET SEMI=';'
   SET PLUS=NULL
   SET PLUS='+'
   SET SINGLE=NULL
   SET SINGLE='_'
   SET MANY=NULL
   SET MANY='%'
   SET IDQUOTES=NULL
   SET IDQUOTES='`'
   SET CURRENCY '$' PREF 2 B
   SET DATE FORMAT MM/DD/YYYY
   SET DATE SEQUENCE MMDDYY
   SET DATE YEAR 30
   SET DATE CENTURY 19
   SET TIME FORMAT HH:MM AP
   SET TIME SEQUENCE HHMM
   CONNECT dbname IDENTIFIED BY user password
   -- Enforce Database/Application Settings
   SET QUOTES=NULL
   SET QUOTES='
   SET DELIMIT=NULL
   SET DELIMIT=','
   SET LINEEND=NULL
   SET LINEEND='^'
   SET SEMI=NULL
   SET SEMI=';'
   SET PLUS=NULL
   SET PLUS='+'
   SET SINGLE=NULL
   SET SINGLE='_'
   SET MANY=NULL
   SET MANY='%'
   SET IDQUOTES=NULL
   SET IDQUOTES='`'
   SET CURRENCY '$' PREF 2 B
   SET DATE FORMAT MM/DD/YYYY
   SET DATE SEQUENCE MMDDYY
   SET DATE YEAR 30
   SET DATE CENTURY 19
   SET TIME FORMAT HH:MM AP
   SET TIME SEQUENCE HHMM
   SET NULL ' '
   SET ZERO ON
   SET WALKMENU ON
   -- Do what you have to do here
   RETURN

This technique will ALWAYS provide you with consistent
results. No surprises.

Feel free to update and incorporate as you see fit.

Very Best R:egards,

Razzak.

www.rbase.com
www.facebook.com/rbase
--
31 years of continuous innovation!
16 Years of R:BASE Technologies, Inc. making R:BASE what it is today!
--