INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Posting a date-field using SQL

Posting a date-field using SQL

(OP)
Hi all,

I'm new to 4D. I was assigned the job of creating a Windows tool to get/post some data from the DB using the Windows ODBC-driver (Simba-based). Alpha and Integer fields are no problem, but I can't seem to find the correct date format to put in my SQL query.

Any ideas on that? I tried the following formats:
- 01-01-01
- 01-01-2001
- 1-1-01
- 1-1-2001
And all of the before but with this behind it:
- 0:00
- 0:00AM
And all of the before but separated by "/" instead of "-".

It just won't accept the date! :(

RE: Posting a date-field using SQL

(OP)
Nevermind, allready figured it out!

RE: Posting a date-field using SQL

hope you stick around this forum because it sounds like you know a lot more than i do... and im about to get stuck into a 4d database in the next few weeks!

www.agonyonline.co.uk
free, anonymous advice provided by the whole world

RE: Posting a date-field using SQL

Hi,

Can you tell me where you obtained Windows ODBC-driver (Simba-based).

thanks

RE: Posting a date-field using SQL

How did you get the ODBC driver to work?  I am stumped.  I downloaded the 6.8 driver off of the 4D website, then installed it on a client...no problem.  Creating a DSN is a cinch until the connection test.  It fails every time.

I am running an older (yet, supported by ODBC) version of 4D server.  One is 6.0.5 and the other is 6.0.6.  All is running in a Windows environment.

Any ideas?  I have run out.

Thanks,
Bill
(aka Linguinut; Ling, for short)

Linguinut
------------------
Bill Cunnien
ConBrio Consulting

RE: Posting a date-field using SQL

When you create a file DSN, did you go to the advanced tab and edit the Driver string?  Also make sure you do not test the connection the first time you create it.  It is described in the documentation here:  

http://www.4d.com/docs/CMU/CMU79920.HTM

RE: Posting a date-field using SQL

17 days have passed since the post...I have gotten past all of the ODBC setup problems.  Bottom line:  the new drivers DO NOT work with the old 4D versions.

In the end, I still had to perform a table-by-table export.  ODBC (at least the 6.0.x version) would not read the BLOB fields in the database.  Big negative!  So, I exported everything to a flat, text file.  The delimiters were a tilde (record) and a pipe (field), then I had to play a little with the export wizards in SQL Server 2000 to make it run smoothly.

I have imported all of the tables for one application and am currently creating the forms/code to replace 4D.  It is all being done in ASP.NET.  So far, so good.  Hope to have both applications transferred over by the end of the year.

Thanks for your reply.  Nice to know someone else actually reads this forum.

Linguinut
------------------
Bill Cunnien
ConBrio Consulting

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close