I can select specific other fields but always fails on Date. Good luck and if you find a way to extract your data, please post backthere have been others previously that have wanted to do this as well. Students Click Here Join Us! Red Flag This Post Please let us know here why this post is inappropriate. Register now while it’s still free! The Tek-Tips staff will check this out and take appropriate action. Click Here to join Tek-Tips and talk with other members!
|Date Added:||10 November 2016|
|File Size:||47.73 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Click Here to join Tek-Tips and talk with other members! There is a potential of over sites that he wants to buy topspeed odbc licenses for.
Added a bit more just to show whats possible. I also found a “TPS reader” that allows me to see some of the structure of some of the files The Topspeed ODBC has a problem with dates topspeev if you have set up the data source to identify date fields.
The time now is Thank you for topspeed odbc keep Tek-Tips Forums free from inappropriate posts. Close topspeed odbc window and log in.
TopSpeed ODBC Driver – questions – ClarionHub
All times are GMT There are a lot better development tools and platforms available. It’s easy to join and it’s free. Register now while it’s still free! I found TPS ODBC Driver but i have to shell out bucks for a tool that I might never use again and for a tool that Im not sure will work if only they offer free trial version on topspeed odbc program Hi, Topspeed odbc should do the trick Thanks a lot, lvdm.
Originally Posted topspeed odbc MikeC. I have tried different variations trying topspeedd get the date but no go. You can get a bit of data out by printing topspeed odbc the Generic Text driver supplied with windows It is better to query using the integer value of the dates and have a function to convert a Clarion Date to an Access date.
Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Topspeed ODBC and SQL query – SoftVelocity: Clarion solutions – Tek-Tips
Register Help Remember Me? The topspeed odbc string will most likely vary considerably between platforms I imagine.
Students Click Here Join Us! Good luck and if you find a way topspeed odbc extract your data, please post backthere have been others previously that have wanted to do this as well.
You have given me the solution to a problem which has topspeed odbc me from using Topspeed ODBC effectively for a long time. Results 1 to 6 of 6. Are these functions standard ODBC functions?
Thanks Guys, I’m passing topspeed odbc info to my boss in hopes that he doesn’t sink a lot of money into topspeed. Topspeed odbc becomes and issue when I am trying to manipulate some dates. Although it is not going tosppeed work, the proper syntax for the query is to enclose the date in single quotes in the yyyy-mm-dd format e.
Red Topspeed odbc This Post Please let us know here why this post is inappropriate. I topspeed odbc the error “invalid operand”. Clarion stores the date as the no of days since Dec 28, e.
Bookmarks Bookmarks Facebook Digg Google del. It’s not what you look at that matters, it’s what you see. I topspeed odbc looked at the Scalar Functions for Access. The Tek-Tips staff will check this out and take appropriate action.