Here is another site with a bit more info ODBC. Used by solo developers, small teams, large corporations, government agencies, and within the military. 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. Any ideas on the reality of such an undertaking? The Topspeed ODBC has a problem with dates especially if you have set up the data source to identify date fields. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden. I changed the properties of the executable to allow this.
|Date Added:||22 August 2013|
|File Size:||9.67 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
Some additional ODBC resouces: Signup for the weekly Friday live webinars, or watch any of the recorded sessions here.
Join your peers on the Internet’s largest technical computer professional community. Most of the system functions do not seem to be supported by the TPS driver or I have not figured out the syntax for sftvelocity
SoftVelocity Topspeed ODBC (Read-Only) Driver – Should I Remove It?
Got my spftvelocity – Found a site which lists all the scalar functions. I can select specific other fields but always fails on Date. The new AppBroker free to distribute lets you quickly deliver your application as an H5-Bootstrap web app, you can see some introductory video tutorials here.
Clarion stores the date as the no of days since Dec 28, e. Renew your subscription today H5 is code complete and many Clarion developers are deploying their existing apps, and building new apps that take advantage of the H5 stack.
You do deserve a Star. Hi, This should do the trick Download, Install and Run: The Database Browser has been a huge help for me. Designed from the ground up with one focus — getting ultra-reliable database apps built faster than any other tool on the market.
Weekly live webinars where you can learn new techniques from topapeed Clarion developers from around the world. You have given me the solution to a problem which has limited me from using Topspeed ODBC effectively for a long time. I have tried different variations trying to get the date but no go.
SoftVelocity Topspeed ODBC Read-Only Driver
October 9thwe are sending it out to all Clarion devs with a current subscription. If you build database applications then Clarion was built for you. It’s easy to join and it’s free.
Thanks Guys, I’m passing this info to my boss in hopes that he doesn’t sink a lot of money into topspeed. Syntax error are pretty much all the same and give you little or no information about where and what the problem is. I For example I do something like this: I changed the properties of the executable to allow this.
Although it is not going to work, the proper syntax for the query is to enclose the date in single quotes in the yyyy-mm-dd format e. Please remember to renew your subscription before the end of October. Here is another site with a bit more info ODBC. Advanced Code Generator engine Templates that have been field tested over two decades Connect with any data source; SQL or ISAM Clean and elegant language Best developer community anywhere Clarion is a language that supports both procedure and object oriented programming, making it very flexible.
By joining you are opting in to receive e-mail. The Clarion community of developers from around the world, along with our own developers and support staff, provide FREE support in the Clarion forums. The Database Browser people were kind enough to fix that right away for me and also fixed a problem where you would get a syntax error if your SQL statement spanned multiple lines and you were not on line 1 when you hit F4 to execute the query – couple of other ODBC browser I tried also seem to have this problem.
Clarion apps are powering businesses in every vertical market in every corner of the globe. Dates in filters need to be formatted correctly for the ODBC driver: Promoting, selling, recruiting, coursework and thesis posting is forbidden. Clarion 11 gold release ships out today!