Search results for query: *

There are a lot of things incompatible between the Clarion DAT file and the dBase DBF file i.e. like GROUPs, ARRAYs, etc. There is a freeware utility written in Clarion called XSCAN written by Vadim Berman which allows you to copy between files. You could check that out. The website is...

Got my answer - Found a site which lists all the scalar functions. http://www.houseoffusion.com/scalar/scalar.htm

Thanks a lot, lvdm. You have given me the solution to a problem which has limited me from using Topspeed ODBC effectively for a long time. You do deserve a Star. I did experiment and found out the {fn dayofyear(date)} returns the no of days from the beginning of the year, {fn dayofmonth(date)}...

Clarion is a RAD (Rapid Application Development) tool and has proven itself to deliver the goods. Like any other product, it has its pros and cons but the strength of Clarion is its approach to Application design and Source Generation. I personally have been using Clarion since it's DOS days...

TOPSCAN has an Export option (File --> Export) which allows you to export TPS files into a Text file (ASCII). Clarion 2.1 has a CCVT.exe which allows you to convert from Clarion to dBASE or Text file. XSCAN also has an option to copy data records between files which can be used to convert to a...

TOPSCAN works only with Topspeed files (*.TPS) - When you try to open a Clarion DAT file, it asks for a password because it cannot understand the header format. So maybe there is no password at all. You can open Clarion DAT files from the Database Browser within the Clarion Development...

Does both Tables have Primary (Unique) Keys and are the primary Key elements part of the browse display / Hot fields ? Since you have a Left Join does the Error appear only for those Trips without a Load? Have you traced the SQL generated using the SQL Profiler to see what is going wrong?

More information is required. What ActiveX? What type of Events? Where are you trying to check if the Event occured? Normally OLE controls have an event Controller procedure to help trap events. If you are a Clarion Magazine subscriber there are some good articles by Jim Kane on how to handle...

The Topspeed ODBC has a problem with dates especially if you have set up the data source to identify date fields. 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. Clarion stores the date as the no of days since Dec 28...

Yes, it is supposed to work. Why do you want to release the resource? Does is GPF b'cos you do no release it? OCX/OLE controls can be preset with the corresponding object by using the CREATE attribute OR dynamically set up by using the ?objectcontrol{prop:create} = 'objectnameORCLSID'. I have...

Did not understand your question fully but if you have referenced it with &= then a &= NULL would work. If you have NEWed it than a DISPOSE(...) will work. Anyway, the syntax for PROP:Release is ?object{Prop:release} = True.

Check ClarionShop.com for CLACOM Lite - It will do the job -Why don't you scan the web for Communication Libraries for Clarion - I do remember seeing a simple free communication library somewhere but cannot remember the site - Check the links in www.tomruby.com/clarion - it would be a good place...