Renew your subscription today. Some additional ODBC resouces: Thanks a lot, lvdm. There are a lot better development tools and platforms available. Clarion stores the date as the no of days since Dec 28, e. And we hope you’ll join us! Added a bit more just to show whats possible.
|Date Added:||3 October 2005|
|File Size:||50.41 Mb|
|Operating Systems:||Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X|
|Price:||Free* [*Free Regsitration Required]|
I get the error “invalid operand”. Any ideas on the reality of such an undertaking?
SoftVelocity Topspeed ODBC Read-Only Driver
And we hope you’ll join us! Is it possible that the need for elevation stems from the folder being pointed to by the DSN for the.
You have given me the solution to a problem which has limited me from clarrion Topspeed ODBC effectively for a long time.
Promoting, selling, recruiting, coursework and thesis posting is forbidden. I have tried different variations trying to get the date but no go. If you build database applications then Clarion was built for you.
Needed to do modulus calculation on a value and had to abandon it as MOD is not supported and casting any part of an expression to integer seems to cast everything to integer. 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.
Renew your subscription today.
The Tek-Tips staff will check this out and take appropriate action. Mine worked fine without any UAC elevation maybe it matters where you install the browser. This becomes and issue when I am trying to manipulate some dates.
Topspeed ODBC and SQL query – SoftVelocity: Clarion solutions – Tek-Tips
Here is another site with a bit more info ODBC. Register now while it’s still free! Visual designers, beautiful themes and FREE support.
I have looked at the Scalar Functions for Access. Got my answer – Found a site which lists all the scalar functions.
Click Here to join Tek-Tips and talk with other members! Some additional ODBC resouces: 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.
Designed from the ground up with one focus — getting ultra-reliable database apps built faster than any other tool on the market. Clarion apps are powering businesses in every vertical market in every corner of the globe.
Used by solo developers, small teams, large corporations, government agencies, and within the military. The Clarion community of developers from around the world, along with our own developers and support staff, provide FREE support in the Clarion forums. 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 ofbc community anywhere Clarion is a language that supports both procedure and object oriented programming, making it very flexible.
Syntax error are pretty much all the same and give you little or no information about where and what the problem is. The new AppBroker free to distribute lets you quickly deliver your application as an H5-Bootstrap web app, you can toppspeed some introductory video tutorials here.
I changed the properties of the executable to allow this.
TopSpeed ODBC Driver Version | Clarion Developer Tools
Topspefd for all your help Paul. Thanks JShankar, I had a feeling this was the case. Weekly live webinars where you can learn new techniques from other Clarion developers from around the world. Close this window and log in. Touch-enabled without writing code.
Added a bit more just to show whats possible.