You are here:
Clarion/Questions Answered by Expert Drew Bourrut
| Subject | Date Asked |
| Clarion Engine stopped working | 3/26/2012 |
| Q: New user here. Just starting to learn Clarion. We are using v6 only because the vendor of the sw we ... A: Diane, I understood that you were getting the error but to the best of my knowledge that file is ... | |
| Clarion Engine stopped working | 3/25/2012 |
| Q: New user here. Just starting to learn Clarion. We are using v6 only because the vendor of the sw we ... A: Diane, You say you can't locate the wera9es file. I do not know what that files is. Plus I've ... | |
| Clarion password recovery for tps and clarion 6 enterprise training | 5/27/2011 |
| Q: My Questions are 2 in number, so here we go: first and foremost: a former friend of mine developed ... A: Second question first. I am not aware of any FREE Clarion training. Also keep in mind that the ... | |
| Unresolved External in clarion 6 to 7 conversion | 3/24/2011 |
| Q: I have just installed Clarion 7 on a new laptop running Windows 7-64bit and copied over my existing ... A: My first thought is to check you project and see that you have no C6 references in it. Beyond that, ... | |
| Program Stops Compiling and locks up | 3/15/2011 |
| Q: When I compile my program it will stop compiling and lock up the Clarion application. The last ... A: Now, its my turn to apologize. I answered this question right after you responded saying that you ... | |
| Program Stops Compiling and locks up | 3/15/2011 |
| Q: When I compile my program it will stop compiling and lock up the Clarion application. The last ... A: First, let me say that there is a quite observable delay at the making point while it appears ... | |
| Does Clarion 2.003 work fine on Windows 7 | 2/4/2011 |
| Q: We are still using Clarion 2.003 for developing our applications. The applications are running on XP ... A: I suspect that as long as you are creating 32-bit apps you will have no problem with them running ... | |
| opening clarion *tps files | 1/30/2011 |
| Q: I have a tps file that is password-protected and I have clarion 6 on windows xp pro. I open up the ... A: You're certainly not doing anything wrong. Either there is another dictionary for that file which, ... | |
| Drag and drop from Excel | 12/1/2010 |
| Q: Is it possible in Clarion 6 to open an excel spreadsheet in my Clarion app and drag a cell value ... A: There is a third-party tool from capesoft.com called Office Inside. Check it out. It provides ... | |
| Clarion 5 crash on windows 7 | 11/29/2010 |
| Q: all our softwares made with Clarion 5 crash when reducing forms or lists several times (keeping ... A: On your browses, check to see if your filter contains the word "True" or the word "False". If so, ... | |
| CW1.5 Compile in 32/64 bit | 11/22/2010 |
| Q: I am a retired self employed clarion developer that began back in the punched card days (1954). I ... A: Eldon, I too started in the punched card days but (1966) so I guess I'm the youngster<g>. Here is ... | |
| String Value to Global Variable | 11/20/2010 |
| Q: I have created an APP and am using the 3rd party TinMan Das_Security with it. I have no challenge ... A: There are various values that are available. When I need the login user's initials I use this: ... | |
| Clarion 2.1 printing error XP | 10/21/2010 |
| Q: I am using a Clarion 2.1 POS program and wish to use it in XP. Everything works fine until I try to ... A: I assume this is DOS Clarion 2.1. Is that true? Rather than a Clarion problem it sounds like a ... | |
| clarion ver.2 dos on windows 7 | 9/29/2010 |
| Q: yes still using clarion ver.2 for dos. under pressure to get the app to run on windows 7. how do i ... A: If you try to run on windows 7 32-bit I believe it should run. However, 64-bit windows 7 does not ... | |
| Claron Template Error cannot open file. No file is open for input | 8/27/2010 |
| Q: Responding to your question for this ... A: With the app open in the Clarion IDE click on the menu option application / properties. That will ... | |
| developed forms vs. dct changes | 8/16/2010 |
| Q: I am developing an information system w/ CLARION 5.5 EE. Previously and I have used Clarion in many ... A: Julio, Ok, now I understand. The simple answer is that is the way it works. Let's take a form as ... | |
| developed forms vs. dct changes | 8/15/2010 |
| Q: I am developing an information system w/ CLARION 5.5 EE. Previously and I have used Clarion in many ... A: Julio, I am not sure of the question you are asking. If you make a change to a table in the ... | |
| Error: Invalid Record Declaration (47) | 8/9/2010 |
| Q: I'm new to Clarion 5. I have an older system that I need to make modifications to. I'm trying to ... A: Wade, My first thought as I started to read was, "Ah, he didn't recompile the app." However, you ... | |
| Clarion 2.003 | 6/7/2010 |
| Q: I have 2.002 which is a 16 bit application. I know it will compile 32 bit apps. Is 2.003 also 16 bit ... A: All versions of Clarion up through 6.3 are 16-bit and produce 32-bit apps. And all versions will ... | |
| Convert Clarion Date field - stored as Long | 4/23/2010 |
| Q: I have a Customer using TopSpeed database - and Clarion as front end. This database is storing Date ... A: A Clarion standard date is the number of days that have elapsed since December 28, 1800. The range ... | |
| old clarion dos not enough memory to chain error message | 1/13/2010 |
| Q: I am running a clarion dos program over win xp. The program need chain.com file to run the exe file ... A: While files and buffers are important to running the programs the error you're getting I believe ... | |
| Windows 7 64 bit | 12/30/2009 |
| Q: How do I get Clarion4 programming software to run on my windows 7 operating system. I can not use ... A: The quick answer is you cannot. The Clarion4 programming environment is 16-bit and is not supported ... | |
| Date display incorect (Clarion 5) | 12/1/2009 |
| Q: I have a variable of type long and use a spin control to display it the default value is blank and ... A: Danie, Because you say that it displays something when it loses focus I wonder what would happen if ... | |
| Error (3): Path Not Found | 11/18/2009 |
| Q: I added a new column to several tables in a Clarion 5.5 application. The "Full Pathname" is not ... A: What is in the Full Pathname field in the table properties or a table in question? When you run an ... | |
| Creating password in clarion 2.1 | 10/24/2009 |
| Q: i've one question. After finish creating a program in clarion 2.1, i want to protect the program ... A: Create a .dat file with two fields of a userid and password and create your first procedure asking ... | |
| Clarion 2.1 can't create a report files. | 10/21/2009 |
| Q: After finish writing a software, i've try & print out the data to the file but not directly to the ... A: While I understand that you're writing in Clarion this does not seem to be a Clarion problem as the ... | |
| Clarion in SMS (short message service) | 8/9/2009 |
| Q: Drew I am Clarion programmer since Dos ver 2.1 , and now with ver 6.2, my problem is to write code ... A: Indra, One source is capesoft.com. They have excellent documentation. They have added an SMS class ... | |
| Clarion for Dos Help | 8/8/2009 |
| Q: I ma hoping that you can help me:I am using software developed with Clarion for Dos.I think it was ... A: I'm afraid I'm going to only be able to give you general answers here. The error message clearly ... | |
| Passing Array to COM function | 7/31/2009 |
| Q: I am able to pass string and short variables to COM(Interop) object. But when i pass arrays, it does ... A: I'm sorry for the delay in responding as I just saw your question. I have a lot of experience in a ... | |
| Read Only TPS files internal to Clarion APP | 7/30/2009 |
| Q: I've generally figured out Clarion on my own with a few exceptions, but I'm having a problem that's ... A: Tom, First, I suspect the problem is with the definitions in the dictionary in terms of how the ... | |
| Read Only TPS files internal to Clarion APP | 7/30/2009 |
| Q: I've generally figured out Clarion on my own with a few exceptions, but I'm having a problem that's ... A: Tom, First off I can definately help you. But first I need to better understand your situation. ... | |
| Msql Problem | 7/26/2009 |
| Q: I'm using Msql database for my application, it's a first time. And I have problems and need help. ... A: You don't say what version of Clarion you're using but I see nothing wrong with importing a table ... | |
| Maintenance of DOS Clarion Programs | 7/22/2009 |
| Q: We are in need of current help to make some changes to surety system written circa 1999 ... the ... A: Rod, I'm sorry for the delay in responding. That said, to steer you in the right direction I need ... | |
| Error (3): Path not found - Can't convert after changing key property | 7/7/2009 |
| Q: I'm working on an application in clarion 5.5. I needed to change external key property (not to ... A: I have a couple questions. First, are you saying you unchecked the box requiring a unique value? I ... | |
| Problem with Clarion index | 8/1/2008 |
| Q: We have a very old Clarion system that we have used successfully so far. We are an insurace agency. ... A: Unfortunately I am not in your area. However, I can help. Post a message in the newsgroup ... | |
| Clarion Topspeed | 7/18/2008 |
| Q: How can I connect to Topspeed tables from Oracle. I have Topspeed ODBC driver version 4. I have ... A: David, I'm embarassed to admit I know nothing about Clarion and SQL. So even though you don't want ... | |
| from CLARION to EXEL | 7/11/2008 |
| Q: Could You answer aI use CLARION4. Can I keep result of report in EXEL? And I cannot find file ... A: You will probably have to create a dictionary structure of type Basic and then create a procedure ... | |
| editing .cla files | 6/8/2008 |
| Q: I have a potential client who has a clarion application that she needs modified. Clarion is ... A: I assume this is a dos version of clarion. Typically in the directory where clarion is installed you ... | |
| need to export a temp .dat file into a .dat file | 5/8/2008 |
| Q: Clarion for Dos 2.1 point of sale program Softwear/Pos At times the program will give a run time ... A: I'm not clear on your question. You say that you want to export the data from one file into ... | |
| Internal error | 4/28/2008 |
| Q: what can you tell me about "Internal Error 04:CTLMAIN" runtime error message. this application was ... A: I no longer have Clarion 2 help files but I suspect you're correct that it is too many open files. ... | |
| Combine dictionaries in 2.0 | 4/14/2008 |
| Q: is there a way to combine 2 dictionary files into one and then use procedures defined in two ... A: Ok, when you have the two dictionaries combined into one then open one of the apps. Under menu ... | |
| Combine dictionaries in 2.0 | 4/13/2008 |
| Q: is there a way to combine 2 dictionary files into one and then use procedures defined in two ... A: The good news is I believe you can do exactly what you want to do. The bad news is that it has been ... | |
| Clarion error code | 1/30/2008 |
| Q: After installing clarion-based system on new Windows xp-based computer, i receive error message: ... A: Urmas, Just to be clear. If you open a dos window; navigate to the directory where the program in ... | |
| KO1,KO2,Ko3 ect | 12/9/2007 |
| Q: I found a utility that can convert *.DAT files but what are files with extention of K01 ,KO2 KO3 ... A: Glad I could help. Today's answer might be a little less helpful<BG>. The .Kxx files are the ... | |
| Export Clarion for Dos Data | 12/8/2007 |
| Q: Is it possible to export data from Clarion for Dos? I think it was Ver2.0 or around there.I do have ... A: The answer is yes if you have the dos clarion utilities. I believe the program was ccvt.exe. It ... | |
| Clarion 5 stability and performance issues | 11/29/2007 |
| Q: this may be a last gasp effor but, we are using a POS application that runs on Clarion 5. We ... A: No there should be no issue with that but... Probably this is a registry settings issue with ... | |
| Too Many Open FIles | 11/21/2007 |
| Q: I occasionally need to use an old Clarion 2.1 application. It runs fine under Windows 98, but under ... A: Sorry for the delay. I just saw your question. It seems obvious to me that you need the equivalent ... | |
| Convert DOS Clarion to Windows XP | 9/17/2007 |
| Q: I have client who is using a DOS Clarion application. It is running on an old Windows 95 PC. We ... A: Unfortunately I am not aware of anyone in OK (OH yes but not OK). So I do suggest that you leave a ... | |
| Convert DOS Clarion to Windows XP | 9/16/2007 |
| Q: I have client who is using a DOS Clarion application. It is running on an old Windows 95 PC. We ... A: Actually there is no way to directly convert a program from Clarion DOS to Clarion for Windows. ... | |
| 9/14/2007 | |
| Q: My email was wrong in question before this ANSWER: Since I answer only via this service it is not a ... A: Matti, Here is what I said. Matti, I understand your problem and I believe it is caused because ... | |
| Enter closing | 9/13/2007 |
| Q: My name is Matti Kukkola and I'm developing with Clarion 5.5. I have set code to form that check ... A: Matti, I understand your problem and I believe it is caused because you have the validation code on ... | |
| exporting TPS data to csv file | 8/1/2007 |
| Q: How can we export a TPS data to csv file (or flat file) using ASCII File Class? I want to create the ... A: In your dictionary define a file not as type ASCII but rather as type BASIC which is CSV. I would ... | |
| Updating an old Clarion 2.1 App | 7/29/2007 |
| Q: I'm very happy to have found this page, as it seems you may be able to help me. A friend of mine is ... A: Sadly without the source code there is nothing to be done. The extensions are as follows: .exe - ... | |
| Clarion Datafile Errors | 5/15/2007 |
| Q: Have seen several of your responses to Clarion related questions on different forums etc, and was ... A: Art, I have several thoughts but first. Nope, I don't know what version the dat files are. But, the ... | |
| Clarion DAT command line query | 5/10/2007 |
| Q: any recommendations for a DOS command line utility to perform SQL like queries against a Clarion DAT ... A: It's not the answer you want but unfortunately there is no such utility to the best of my knowledge. ... | |
| Any old documentation? | 5/8/2007 |
| Q: We have an old Clarion for Dos database that runs our invoicing and credit and collection programs. ... A: Rich, To start, typically a clarion application will have as the base source code a .app file which ... | |
| .tps file | 5/6/2007 |
| Q: I purchased a program from clarion in 2002 called NWORKS works, I have inadvertently deleted the ... A: There are a couple of problems here that won't make you happy. First, the Clarion development ... | |
| images | 5/4/2007 |
| Q: I would like to know if there is any way i can print our company logo on our receipt printers. We ... A: There was an add-on at one time called the Clarion Graphics LEM (Language Extension Module) which ... | |
| cw 2x | 4/27/2007 |
| Q: I just upgraded to winxp. I try to use cw 2x and gwt a error message of"unexpected dynafile" What is ... A: David, I'll give you some suggestions. However, I have a slight problem<g>. I haven't had Clarion 2 ... | |
| Clarion conversion | 4/14/2007 |
| Q: I have been giving the daunting task to convert all our MSDS files to a new web based HTML format. I ... A: I'm assuming that you have the Clarion development environment. In that case you can use Topscan.exe ... | |
| Message Box in clairon | 2/26/2007 |
| Q: I have MDI application.I am opening many windows in separate threads.I am dragging & dropping from ... A: You don't say what version of Clarion you are using. To the best of my knowledge drag and drop was ... | |
| Need to export old Clarion DAT file | 1/8/2007 |
| Q: CCVT was a bit confusing, but it finally worked. I had to convert the original DAT file to a newer ... A: The K## files are only useful in a Clarion application. This has two implications. One, to match the ... | |
| Migration from clarion5.5 to clarion 6.2 | 11/3/2006 |
| Q: I completely migrated a big software from clarion 5.5 to clarion 6.2.but now it is giving speed ... A: Are you using the ABC methods or legacy code? You noted that there are speed issues and then ... | |
| TPS file conversion | 8/29/2006 |
| Q: I have a one time requirement to convert approximately 30 TPS files to CVS or Excel format. This is ... A: Your question's answer depends on your answer to several questions. 1. Do you have the Clarion ... | |
| Converting Clarion Dos2.0 to Windows | 7/5/2006 |
| Q: Is there a utility available (like the one shipped with Cw V1.0 and 1.5) that will do basic ... A: There is currently no converter available to convert an application from DOS to Windows. While I ... | |
| File error | 6/29/2006 |
| Q: I am an IT consultant working with a client who has an old Clarion database application from around ... A: There are two tools that come with the Clarion environment. These are TPSFIX (for repairing) and ... | |
| Password protected files | 6/28/2006 |
| Q: We are currently changing application platforms and need to extract data from several .tps files. ... A: There is only one way to unlock password protected tps files and that is to know the password. The ... | |
| ccvt.exe | 6/20/2006 |
| Q: Can you call ccvt.exe to convert a Clarion 2.1 file from a command file or from a program? Where ... A: CCVT.EXE t=Clarion i=Elkem o=dbaseIII f=Elkem /v This will convert the the file ELKEM.DAT to ... | |
| exporting Clarion v.4 tables | 6/16/2006 |
| Q: The data files are .TPS. The "Convert File" is under to file menu. I have the following file types ... A: In that case, use the convert program and when it asks for source dictionary use the .DCT filename ... | |
| exporting Clarion v.4 tables | 6/16/2006 |
| Q: I know nothing about Clarion -- (Oracle DBA). My office has an old Clarion application that we are ... A: I'm happy to help. First, though, I need some information. What is the extension on the file? .DAT ... | |
| Conversion form Dos to Windows Programme | 5/6/2006 |
| Q: A sowtware designer designe my costing software with Clarion [Dos Version Unknown] and he has ... A: Unfortunately, there is no true conversion from Clarion for DOS to Clarion for Windows. If you have ... | |
| ccvt.exe help | 3/27/2006 |
| Q: I am using the ccvt.exe to try and open Clarion based .DAT files. When it offers me a choice for ... A: I just saw your comment. I think the answer is this. The old dos pgms worked with the 8.3 format of ... | |
| scrolling with running totals | 3/26/2006 |
| Q: I have a browse in standard edition v2.002 to which i have added a running total field. I am working ... A: Jeff, Creating a checkbook program is a great way to learn Clarion. I assume you are using Clarion ... | |
| ccvt.exe help | 3/26/2006 |
| Q: I am using the ccvt.exe to try and open Clarion based .DAT files. When it offers me a choice for ... A: I believe that while the file(s) in question have an extension of .DAT, they are probably not ... | |
| Can I export data from Clarion tps files without buying expensive tools? | 2/25/2006 |
| Q: I have several Clarion v6 tps files from which I need to extract the data, preferably in SQL dump ... A: Roger, There are several issues. Are the files copy protected or encrypted. If so, do you have the ... | |
| Basic Clarion v 2.0 | 2/8/2006 |
| Q: I've been around computers since '78, but absolutely no Clarion experience. Now I do IT work for ... A: Eddie, First I apologize for not responding sooner. Somehow I missed your message. There are a ... | |
| we need somebody with Clarion expertise | 1/11/2006 |
| Q: Are you still in the business? What are your rates? Would you be willing to work in Jackson, ... A: We've been in business since 1990. Our offices are in Long Island, NY and will stay there. We have ... | |
| Files conversion | 11/19/2004 |
| Q: I tried programming in Clarion 2 for Windows... Do you have solution for this problem: How to solve ... A: There have been many releases of Clarion since version 2. The current version is 6.1. However, I'll ... | |
| Calling Excel from Clarion | 10/5/2004 |
| Q: Drew I am sure C6 code will work. Sorry, let me explain the problem a bit more: I have made a CSV ... A: Rick, I just discovered that there was this msg from you since early October. I got a question from ... | |
| Calling Excel from Clarion | 10/4/2004 |
| Q: I am using C5EE. I am trying to open a text file in Excel that has delimited columns. Everything ... A: Rick, Your first line says you are using C5EE but after that you refer to excel. I'm confused. Are ... | |
| Applicaiton Speed | 9/24/2004 |
| Q: We have a programmer that converted his dos btrieve program to a windows version using Clarion. We ... A: The answer depends on which version of Clarion he was using. If used Clarion 6, I not sure of the ... | |
| Clarion Data Base Dict. Conver. | 8/16/2004 |
| Q: Man, I forgot to tell you I was using the Topspeed driver (TPS) on my last question to you. I also ... A: Ok, now I understand. Here is how I convert a file. To do this I never leave the dictionary. I add ... | |
| Again, Data Dictionary Data Base Conversion | 8/16/2004 |
| Q: Drew, I guess that was vague on my last question. I'm using Clarion 5b. Say I want to add a field ... A: I answered this in the question where you told me these were topspeed files. But just to be clear ... | |
| Conversion Utility in Dictionary | 8/16/2004 |
| Q: I haven't been programming with C5 for several years due to personal problems. But a friend asked ... A: A couple of questions from me. You say that you couldn't convert the database but you don't say ... | |
| Clarion Database Conversion | 7/26/2004 |
| Q: I have successfully converted all the files i needed. however, the dates in all the files are in ... A: Converting dates is an interesting exercise. Virtually all software stores dates as the number of ... | |
| Clarion Database Conversion | 7/15/2004 |
| Q: I tried the CCVT application and converted the DAT files in to DBFs successfully. However, some of ... A: If a file produces that error its either an indication that its not a Clarion file you're trying to ... | |
| Clarion Database Conversion | 7/13/2004 |
| Q: The only files that I see on the folder has the temporary file ($$$) extensions. Currently, reports ... A: Using Clarion Report Writer does not mean that you are using Clarion files. For example, The report ... | |
| Clarion Database Conversion | 7/13/2004 |
| Q: I am trying to convert a Clarion Database into MS access. I have never worked with CLarion before. ... A: First of all we need to establish the type of clarion database. Your data files will either have an ... | |
| ODBC import of .tps table with > 255 fields | 2/4/2003 |
| Q: I licensed the Clarion TopSpeed ODBC Driver and have had success in connecting to all but one of the ... A: Gil, I do have opinions and suggestions but I need a wee bit more information. Can I assume that ... | |
| Clarion Programming | 1/9/2003 |
| Q: I may have to run a small project to maintain a POS system (JDA's WinDSS), which is apparently ... A: I'm happy to help. First, Clarion as a language was first issued in about 1987. The best place to ... | |
| Clarion vs Alpha 5 | 10/18/2001 |
| Q: Drew: I tried using Clarion when it was DOS, and even went through one of their week long training ... A: Stephen, RAD: Rapid Applications Development I've used Clarion since 2.0 for DOS so I'm pretty ... | |
Drew Bourrut
Top Expert on this page
Expertise
As Clarion programmer since version 2.0 for DOS (1988), I am a consultant who specializes in Clarion programming. I have converted systems from DOS to Windows and have worked with every version of Clarion for Windows. My background has also included teaching database design, SQL programming, project management, and programming in a variety of languages from COBOL to PL/I. I have been a consultant since 1974 and a programmer since 1966.
Experience
Clarion allows me to write for a number of unrelated businesses. I've written applications that are accessible only via the web as well as communications applications and also large (more than 270 procedures) applications for service-oriented businesses.
©2012 About.com, a part of The New York Times Company. All rights reserved.