Search results for query: *

Hello! I haven't been here in a while and I'm still relatively new to Clarion (5.0) so please bare with me (again). Usually when I have to deal with JOINed files, I set them in the Files option of a Procedure for things like Browse. But now I have a Window Procedure with Embed code to...

Hi, guys! Is there a "public domain" .app/.exe available that maybe prompts for a TPS file (or the TPS file name is passed on in as a parameter when running the EXE) and opens then automatically dumps all of the fields and records out to a delimited TXT or CSV file? It would be nice if TopScan...

I have numerous TPS files that I want to convert to Tables in a SQL Server 2008 Database. We have Clarion 5.0, and after much seaching, I was able to find and download TopScan v5.5 which has the Export option. I am able to create TXT files and manually Import them into SQL. However, the Table...

Okay, this one has me banging my head on the table... again (see attachment). I have a PROJECT.TPS table with about 80 records that had a field called EstimatedWeekHours (Decimal). In running the APP/EXE, the field data is visable in the Update Project screen. However, I recently added...

I can't believe I'm having such a hard time getting this to work! It's SO much easier in dBase/FoxPro!! (ok, I feel better now) I need to take what a user enters in a field (Company) and look it up to see if it already exists so I can stop them from entering duplicates (numerous ones already...

Hi, guys... remember, new to Clarion (5) here... I have a Source Procedure I'm using in the Action of a Button where I use "Call a Procedure" and specify the name. I also need to somehow call that same Procedure from Embedded Source code. I don't think I can use the CALL command because the...

In the Window Formatter (Clarion 5.x), I'm trying to insert a new Tab between two others. When I use Control, Tab, it always adds the new Tab at the end of the others no matter where I click. After adding a new Tab, I don't see how I can move it over (to the left) between two others. I also...

My boss wants a "Quick Add" Screen to create a new Sales Prospect record. Basically, he want to be able to start to type, say a Company Name, into a single-line field and have the field actively look up records in the Company table as he types each character and fill the field with the first...

Hello, again! I have a table with your standard Update window and procedure that works fine. When a new record is created, the ID field is incremented by one in the new record automatically. Now I have some Embedded code trying to create a new record manually in the same table...

Nevermind... as a guess, I added an "= 1" after the right bracket and it worked!

First, just to let you know, I'm a very intermediate Clarion 5 user. I've been modifying existing code of an old application and trying to create a new Sales module off of the existing application. So I understand the very basics and certainly am not an advanced user. I'm trying to copy...

I need to be able to check and see if a TPS file has been modified yet in the current date. Is there a way to pull the file's current date?

I have a table in a Browse window that I need to be able to show all records and have two options to filter out records by a specific code (Employee Type: Current, Former or both). I added the Employee Type and all variable fields to the Hot Fields list so the Browse window does refresh...

I have a Browse list that has 3 tabs and defaults to a key sort by Last Name in the first tab. In this single Browse list, I have 2 columns that are calculating the number of days until their Birthday and Anniversary from the "Format an element of the browse queue" Embed. I need to be able to...

It's been almost 2 months since I last compiled an EXE or DLL from our Clarion 5 system yet we're have problems with corrupted TPS files: Error: ( ()) attempting to access a record from the FILENAME file. Returning to previous window. The corruptions seem to happen randomly and affect around...

Hello, again! Recently, I created some new Browse windows involving only a main table with one related table off of it. My developer environment consists of a Windows XP Mode in my Windows 7 PC. Periodically, I copy the live TPS files down for fresh data to play with. When I pull up these...

Howdy, again! I know... it's been too long (haha). How can you abort an Insert procedure without it saving a new record? I have a form with an OK button. On the button, I have source code in an "Control Event Handling, before generated code - Accepted" Embed. In it, there is a condition...

I have a standard form where the user enter's a Contact's information. After the Last Name is entered, I'm using an Embed to look-up the First and Last Name in the Contact table to see if it exists, and if so, warn the user. I got everything to work except the last step of adding a new record...

I'm back at my standard Browse screen. Now I'm adding multiple Tabs to control sort order using Conditional Behavior. The Browse list contains fields from the primary file (A) and some from a number of related files (B and C). By default, I have the sort set to a Key from the A file. I...

Hi, ShankarJ! :) I have a pretty standard Browse window with the typical Insert, Change and Delete buttons. For some reason, now when the Insert button is pressed, the Update windows is now pre-populating the same field values from the selection in the Browse window instead of empty field...