[RBASE-L] - Re: Datetime issue

[TOM HART]

That is what I did different, I copied from your earlier post but somehow the 
set time format was HH:MM:SS, I have that resolved now.  Why does that affect 
the datetime stamp?
Tom Hart





________________________________
 From: A. Razzak Memon <raz...@rbase.com>
To: RBASE-L Mailing List <rbase-l@rbase.com> 
Sent: Saturday, January 11, 2014 2:17 PM
Subject: [RBASE-L] - Re: Datetime issue
 

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!
--