I.T. Discussion Community!
-Collapse +Expand
DBA
Search DBA Group:

Advanced
-Collapse +Expand DBA Store
PRESTWOODSTORE

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyDBA, Databases, & Data BoardInterbase Topic   Print This     

Incompatibility with DATE type in Paradox and Crea

Incompatibility with DATE type in Paradox and Crea in Interbase topic (part of our DBA, Databases, & Data group).

Quick Search: Incompatibility   Paradox   Incompatibility DATE   Incompatibility DATE type   Paradox Crea  
rreiss
 (Inactive)
San Diego
I recently tried to create a new table using Corel Paradox 10. I chose INTERBASE (using the free Interbase 6 download)for the table type. One table was easily created, but a second table, where I chose DATE for the date field created an error, telling me that Interbase was using TIMESTAMP. Unfortunately, TIMESTAMP is not a choice on the field type dropdown dialogue. Going the otherway and using Interbase SQL, I could create a table with a DATE datetype, but Paradox wouldn't let me add it to the datamodel on a form. Any ideas how to get around this problem?
Would I still have the problem with the Corel Linux version and Interbase for FreeBSD/Linux? (I have Corel Office for Linux on order).
 Posted 17 years ago (Thread Starter)
Comment Quote
About rreiss -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5301, 1 replies
Thread Started 2/15/2002 5:34:00 AM
View Counter=2944
Last Reply Posted 11/18/2002 11:57:00 AM)
Location=San Diego  
Joined=17 years ago   MB Posts=2  
Most Recent Post
Scott Wehrly
Prestwood IT
 (Inactive)
Las Vegas, NV USA
We recently encountered this problem in a Paradox-to-InterBase conversion project, and found the problem to be related to the SQL dialect used by the BDE driver.



InterBase 6 supports dialect 1 - where only the TIMESTAMP field type is supported, and dialect 3 - where field types DATE and TIME have been added.



In order to get Paradox to use the dialect 3 in InterBase 6, you will need to add a key to the registry settings for the driver. In regedit, you will need to add a key under:

HKEY_LOCAL_MACHINE\SOFTWARE\Borland\Database Engine\Settings\Drivers\INTRBASE\DB OPEN\

with the following settings:

Key = SQLDIALECT
Value = "3"




You will then need to delete any existing aliases to InterBase 6 databases in the BDE Administrator (Paradox Alias Manager), and re-create them.



Once you have done this, the DATE field type in Paradox will match the DATE field type in InterBase.



One very important note:
While Paradox dates allow such things as 3 and 5 digit years - InterBase dates only support values between November 18, 1858 and January 1, 3000! I mention this, because it is possible to get a "data overflow" error on inserts from Paradox to InterBase where funky date values exist.
 Posted 17 years ago
Comment Quote
About Scott Wehrly -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #8338 (Level 1.1)  Reply to 5301
Thread Started 11/18/2002 11:57:00 AM
View Counter=2
Location=Las Vegas, NV USA 
Joined=17 years ago   MB Posts=442   KB Posts=19  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1264A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #5301 Counter
2944
Since 4/2/2008
Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech