Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. wchestnut

    Manual JOIN

    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...
  2. wchestnut

    TPS to Text APP

    ShankarJ, not to rush you, but do you have an idea when the utility will be ready? :) If there's a way I can get it to do multiple files separately somehow without specifying a selections file in the command line (like keeping multiple copies in separate folders or something), then I'd take it...
  3. wchestnut

    TPS to Text APP

    uniglass, thanks, but I need to be able to schedule and run it as a batch file. ShankarJ, that would be AWESOME!
  4. wchestnut

    TPS to Text APP

    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...
  5. wchestnut

    Clarion 5 - Converting TPS to SQL Server

    Thanks, TuzMwaura, but I don't see anything on that web site. It doesn't look it has much content?
  6. wchestnut

    Clarion 5 - Converting TPS to SQL Server

    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...
  7. wchestnut

    Hiding Data

    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...
  8. wchestnut

    Search for Existing Record

    Interesting... okay, I'll try using that instead. I'm just surprised EOF didn't work, but then I don't think I had GET correctly. Thanks, ShankerJ!
  9. wchestnut

    Search for Existing Record

    IT WORKED!! Thank you very much!!
  10. wchestnut

    Search for Existing Record

    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...
  11. wchestnut

    Call a Source Procedure

    YES! Thanks, again!!
  12. wchestnut

    Call a Source Procedure

    Hmmm... slight problem. I need to be able to execute the Procedure in the same thread -- like having the "Initiate Thread" unchecked in an Action. According to the Help, if I leave Stack omitted, it defaults to 10,000. Is that possible?
  13. wchestnut

    Call a Source Procedure

    AWESOME! THANK YOU!
  14. wchestnut

    Call a Source Procedure

    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...
  15. wchestnut

    Tab Position

    Hmm.. F12 didn't do anything. I can bring up the Tab Properties window, but I only have General, Extra, Color, Help and Action tabs.
  16. wchestnut

    Tab Position

    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...
  17. wchestnut

    "Quick Add" Screen

    Yes, I think that will work for him. Thanks again, ShankarJ!
  18. wchestnut

    "Quick Add" Screen

    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...
  19. wchestnut

    Auto IDs

    Okay, here's the code I used: ============================================================================== ! Create New Prospect ! First, check if not flagged Selected or flagged Ignore IF CO:SalesProspectSelected = 0 OR CO:SalesProspectIgnore = 1 MESSAGE('"' & CLIP(CO:CompanyNameLong) &...
  20. wchestnut

    Auto IDs

    Hello, That code looks odd to me. I got 4 Syntax Errors when I compiled the program with those recommended changes. We have Clarion 5. Is that code only supported in a higher version?

Part and Inventory Search

Back
Top