# \#tps **URL:** https://clarionhub.com/tag/tps/155.md [Latest](https://clarionhub.com/latest.md) · [Categories](https://clarionhub.com/categories.md) · [Tags](https://clarionhub.com/tags.md) --- ## [TPS Repair: recovering damaged TPS files and migrating data after Error 47](https://clarionhub.com/t/tps-repair-recovering-damaged-tps-files-and-migrating-data-after-error-47/9379)
**Author:** [@CarlosGtrz](https://clarionhub.com/u/CarlosGtrz)\ **Replies:** 0\ **Last updated:** [September 20, 2026, 6:41pm UTC](https://clarionhub.com/t/tps-repair-recovering-damaged-tps-files-and-migrating-data-after-error-47/9379 "2026-09-20T18:41:38Z")
Some of you may remember the post about the TPS parser class that came out of a corrupted file at a customer site, and the .NET reader and CLI that followed. For the last few months, that work has quietly turned into a f… --- ## [Renumber my records](https://clarionhub.com/t/renumber-my-records/9311)
**Author:** [@Tonymarshall](https://clarionhub.com/u/Tonymarshall)\ **Replies:** 4\ **Last updated:** [August 21, 2026, 1:26am UTC](https://clarionhub.com/t/renumber-my-records/9311 "2026-08-21T01:26:41Z")
Hi I developed a Clarion application a while ago using clarion templates. (TPS) I had no autonumbering on my records. Now I am using a later application that autonumbers my records. the problem is that the autonumber … --- ## [Suspected indexing problems TPS file after table reconfigure and index rebuild](https://clarionhub.com/t/suspected-indexing-problems-tps-file-after-table-reconfigure-and-index-rebuild/9293)
**Author:** [@mjkuhn](https://clarionhub.com/u/mjkuhn)\ **Replies:** 18\ **Last updated:** [August 20, 2026, 11:30pm UTC](https://clarionhub.com/t/suspected-indexing-problems-tps-file-after-table-reconfigure-and-index-rebuild/9293 "2026-08-20T23:30:52Z")
Environment: Windows Server 2022 with Widows 11 WS’s. Clarion 9 exe, 20 dll’s, and 3 dozen or so tables. In the last 26 years I have done this same thing dozens of times. Add some fields to a table, rebuild the table, ch… --- ## [Filter and Order a TPS table on AutoGuid by most Recent Date in code](https://clarionhub.com/t/filter-and-order-a-tps-table-on-autoguid-by-most-recent-date-in-code/9278)
**Author:** [@rjolda](https://clarionhub.com/u/rjolda)\ **Replies:** 5\ **Last updated:** [August 5, 2026, 11:28am UTC](https://clarionhub.com/t/filter-and-order-a-tps-table-on-autoguid-by-most-recent-date-in-code/9278 "2026-08-05T11:28:06Z")
Hi, I have a TPS table which is keyed on AutoGuid. In the table is a ServiceDate ( long). On a browse, I filter it by AutoGuid and sort it descending on Service Date so that the most recent are at the top. So, what I… --- ## [An AI agent skill, a cross-platform CLI tool, and a C# class for working with TPS files](https://clarionhub.com/t/an-ai-agent-skill-a-cross-platform-cli-tool-and-a-c-class-for-working-with-tps-files/9250)
**Author:** [@CarlosGtrz](https://clarionhub.com/u/CarlosGtrz)\ **Replies:** 0\ **Last updated:** [July 23, 2026, 10:02pm UTC](https://clarionhub.com/t/an-ai-agent-skill-a-cross-platform-cli-tool-and-a-c-class-for-working-with-tps-files/9250 "2026-07-23T22:02:14Z")
GitHub - TpsReader. TpsReader for .NET TpsReader is a simple, read-only .NET library for opening TopSpeed (.TPS) files and reading their tables and records. TpsReader.Tool supplies the tps command for schema discovery… --- ## [A Clarion TPS Parser Class Born from a Corrupted File, a Java Utility, and an AI Coding Agent](https://clarionhub.com/t/a-clarion-tps-parser-class-born-from-a-corrupted-file-a-java-utility-and-an-ai-coding-agent/9113)
**Author:** [@CarlosGtrz](https://clarionhub.com/u/CarlosGtrz)\ **Replies:** 12\ **Last updated:** [July 23, 2026, 9:52pm UTC](https://clarionhub.com/t/a-clarion-tps-parser-class-born-from-a-corrupted-file-a-java-utility-and-an-ai-coding-agent/9113 "2026-07-23T21:52:56Z")
A few days ago, a user reported that a Clarion application was hanging when opening a window that reads a TPS file containing data and thumbnail images stored as BLOBs. As expected, the TPS file was corrupted. I tried e… --- ## [Is there a tool to copy data from one Topspeed file to another?](https://clarionhub.com/t/is-there-a-tool-to-copy-data-from-one-topspeed-file-to-another/9212)
**Author:** [@ThaDaSoft](https://clarionhub.com/u/ThaDaSoft)\ **Replies:** 6\ **Last updated:** [July 7, 2026, 7:29pm UTC](https://clarionhub.com/t/is-there-a-tool-to-copy-data-from-one-topspeed-file-to-another/9212 "2026-07-07T19:29:48Z")
Currently I’ve got two versions of an application, one had a temporary key added, sadly due to this, the data file cannot be opened in the other version due to the file version being changed - is there a Topspeed tool wh… --- ## [Invalid table declaration\[27\] Error opening TPS File](https://clarionhub.com/t/invalid-table-declaration-27-error-opening-tps-file/9126)
**Author:** [@Ankit\_Purohit](https://clarionhub.com/u/Ankit_Purohit)\ **Replies:** 6\ **Last updated:** [May 25, 2026, 12:30pm UTC](https://clarionhub.com/t/invalid-table-declaration-27-error-opening-tps-file/9126 "2026-05-25T12:30:39Z")
I defined a table inside dictionary. When i’m trying to use it in my app getting below error. How to resolve this ? --- ## [Sample TPS Files](https://clarionhub.com/t/sample-tps-files/9108)
**Author:** [@E.Mike](https://clarionhub.com/u/E.Mike)\ **Replies:** 16\ **Last updated:** [May 20, 2026, 8:19am UTC](https://clarionhub.com/t/sample-tps-files/9108 "2026-05-20T08:19:35Z")
Hello. I am working on adding Clarion support to our ETL Software: Advanced ETL Processor and I was wondering if someone can provide us with some sample files we can use for testing, so far I was not able to find som… --- ## [Size (number of characters ) of record in TPS table - for SQL conversion](https://clarionhub.com/t/size-number-of-characters-of-record-in-tps-table-for-sql-conversion/9041)
**Author:** [@rjolda](https://clarionhub.com/u/rjolda)\ **Replies:** 4\ **Last updated:** [April 16, 2026, 1:13am UTC](https://clarionhub.com/t/size-number-of-characters-of-record-in-tps-table-for-sql-conversion/9041 "2026-04-16T01:13:44Z")
Hi, Getting ready to convert TPS to MSSQL. MSSQL has a record length of 8K chars. I want to see the lengths of my records in my TPS files to see what length they are. No blobs. So, question is what is the easiest way… --- ## [Cannot Open multi-table superfile files with Topscan from Clarion 11](https://clarionhub.com/t/cannot-open-multi-table-superfile-files-with-topscan-from-clarion-11/9005)
**Author:** [@tgulden](https://clarionhub.com/u/tgulden)\ **Replies:** 7\ **Last updated:** [March 25, 2026, 3:41am UTC](https://clarionhub.com/t/cannot-open-multi-table-superfile-files-with-topscan-from-clarion-11/9005 "2026-03-25T03:41:35Z")
The name of the table is Beslag. No problems running the app with this table, nor opening in the DCT Explorer. Any idea to solve this? Using Clarion 11. And next time, this is the name of the table: Trond --- ## [Why can't a TopSpeed file store the € Euro symbol?](https://clarionhub.com/t/why-cant-a-topspeed-file-store-the-euro-symbol/8989)
**Author:** [@ThaDaSoft](https://clarionhub.com/u/ThaDaSoft)\ **Replies:** 15\ **Last updated:** [March 22, 2026, 9:06pm UTC](https://clarionhub.com/t/why-cant-a-topspeed-file-store-the-euro-symbol/8989 "2026-03-22T21:06:07Z")
I just noticed, that my application is unable to store the euro symbol € - I even tried with TopScan, it’s just replaced with a \_ - any idea why that is? How can I fix this? Or do I have to build in logic to save it diff… --- ## [Clarion EXE and TPS Files on Linux or WINE](https://clarionhub.com/t/clarion-exe-and-tps-files-on-linux-or-wine/8911)
**Author:** [@MSegnari](https://clarionhub.com/u/MSegnari)\ **Replies:** 5\ **Last updated:** [January 31, 2026, 10:26pm UTC](https://clarionhub.com/t/clarion-exe-and-tps-files-on-linux-or-wine/8911 "2026-01-31T22:26:14Z")
Curious if anyone has deployed an EXE on Linux or a Windows Emulator such as WINE. The program accesses primarily TPS files, and a few MSSQL tables. The IT manager that wants to try this configuration is also concerned… --- ## [Clarion requires a File Name not entered in the Dictionary](https://clarionhub.com/t/clarion-requires-a-file-name-not-entered-in-the-dictionary/8905)
**Author:** [@Werner](https://clarionhub.com/u/Werner)\ **Replies:** 3\ **Last updated:** [January 16, 2026, 8:46pm UTC](https://clarionhub.com/t/clarion-requires-a-file-name-not-entered-in-the-dictionary/8905 "2026-01-16T20:46:09Z")
I am using clarion 11. I am developing a very simple addressbook application with a company file/table and a contactperson file/table. Fileformat tps. The company file is labelled tblContact with the prefx Con. And the … --- ## [Generically Remove or Rename a specific TPS Table in a Superfile](https://clarionhub.com/t/generically-remove-or-rename-a-specific-tps-table-in-a-superfile/8887)
**Author:** [@jslarve](https://clarionhub.com/u/jslarve)\ **Replies:** 10\ **Last updated:** [January 6, 2026, 7:10pm UTC](https://clarionhub.com/t/generically-remove-or-rename-a-specific-tps-table-in-a-superfile/8887 "2026-01-06T19:10:23Z")
When you do a REMOVE(TpsSuperFileTable), the RTL/Driver doesn’t need to know the the table structure. This is an example commandline (not console, but could be) app for removing a table from a tps file. TPS Table Remove… --- ## [TPS TryInsert Access Denied](https://clarionhub.com/t/tps-tryinsert-access-denied/8851)
**Author:** [@greenslk](https://clarionhub.com/u/greenslk)\ **Replies:** 5\ **Last updated:** [December 12, 2025, 4:43pm UTC](https://clarionhub.com/t/tps-tryinsert-access-denied/8851 "2025-12-12T16:43:04Z")
Using a process template reading an SQLite2 table and writing to TPS (C:\\Users\\Public\\Documents\\myApp\\data\\v3DailyMetrics.tps) fails with Access Denied The open is successful but the TryInsert throws an error |\*\*\* dbSt… --- ## [jFiles SaveFile sorting by a key](https://clarionhub.com/t/jfiles-savefile-sorting-by-a-key/8761)
**Author:** [@henkouwejan](https://clarionhub.com/u/henkouwejan)\ **Replies:** 2\ **Last updated:** [November 6, 2025, 6:45pm UTC](https://clarionhub.com/t/jfiles-savefile-sorting-by-a-key/8761 "2025-11-06T18:45:46Z")
Hi all, I'm using jFiles to export a TPS file to JSON. This process is sequential. I'm wondering if it's possible to do this by a key. Add a line somewhere in the code like SET(PRE:MyKey,PRE:MyKey) Suggestions are welc… --- ## [Error: (Unable to frame transaction (48)) attempting to frame the transaction and LogoutTimeout on TPS driver](https://clarionhub.com/t/error-unable-to-frame-transaction-48-attempting-to-frame-the-transaction-and-logouttimeout-on-tps-driver/8743)
**Author:** [@greg](https://clarionhub.com/u/greg)\ **Replies:** 6\ **Last updated:** [November 1, 2025, 10:14am UTC](https://clarionhub.com/t/error-unable-to-frame-transaction-48-attempting-to-frame-the-transaction-and-logouttimeout-on-tps-driver/8743 "2025-11-01T10:14:21Z")
I ocasionally get this error when updating records in one location where the database is the largest. I gather this could be due to using Logout in transaction frame with TopSpeed database driver. Looking at Abfile.clw … --- ## [Win11 : Where's my C:\\ProgramData\\ TPS file folder?](https://clarionhub.com/t/win11-wheres-my-c-programdata-tps-file-folder/8668)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 6\ **Last updated:** [October 7, 2025, 1:34pm UTC](https://clarionhub.com/t/win11-wheres-my-c-programdata-tps-file-folder/8668 "2025-10-07T13:34:22Z")
Debugview is showing the app is using C:\\ProgramData\\MyApp\\ folder to store the tps files in, yet the folder doesnt exist in File Explorer. Is there some sort of folder redirection taking place that I'm not aware of? T… --- ## [Strange TPS Lockup](https://clarionhub.com/t/strange-tps-lockup/8625)
**Author:** [@jslarve](https://clarionhub.com/u/jslarve)\ **Replies:** 14\ **Last updated:** [September 23, 2025, 1:43am UTC](https://clarionhub.com/t/strange-tps-lockup/8625 "2025-09-23T01:43:43Z")
In all of my years of toiling over TPS files, I have never seen a situation such as this. We have an application that uses TPS with superfiles as its current file format. The file is basically just a vehicle to get the … --- ## [TPS Auto Increments - Any speed advantage using Descending Key order?](https://clarionhub.com/t/tps-auto-increments-any-speed-advantage-using-descending-key-order/8601)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 5\ **Last updated:** [September 14, 2025, 7:01pm UTC](https://clarionhub.com/t/tps-auto-increments-any-speed-advantage-using-descending-key-order/8601 "2025-09-14T19:01:58Z")
If there is going to hundreds of thousands of records if not millions of records in a TPS file, and the ABC filemanager is used to do the auto incrementing, is there any advantage is using a Descending order on the AutoI… --- ## [Topscan 11/12 Navigation Button?](https://clarionhub.com/t/topscan-11-12-navigation-button/8599)
**Author:** [@Zdpl0a](https://clarionhub.com/u/Zdpl0a)\ **Replies:** 2\ **Last updated:** [September 14, 2025, 1:10am UTC](https://clarionhub.com/t/topscan-11-12-navigation-button/8599 "2025-09-14T01:10:14Z")
I am finally moving one app that accesses archives. About 400,000 records with child records and associated images. Opening TPS files with Topscan, I don't see the navigation buttons or an option to toggle them \<\< \< = \> … --- ## [How to import CSV into Clarion 11 TopSpeed file without writing code](https://clarionhub.com/t/how-to-import-csv-into-clarion-11-topspeed-file-without-writing-code/3942)
**Author:** [@Waldo](https://clarionhub.com/u/Waldo)\ **Replies:** 28\ **Last updated:** [September 12, 2025, 2:45am UTC](https://clarionhub.com/t/how-to-import-csv-into-clarion-11-topspeed-file-without-writing-code/3942 "2025-09-12T02:45:51Z")
how to import CSV, TXT into Clarion 11, you would think this would be a procedure in place to do that outside the dictionary I am back to clarion and new to version 11, I can not find a simple way to manipulate simple d… --- ## [Using Set(Key,Key) to only get assigned values](https://clarionhub.com/t/using-set-key-key-to-only-get-assigned-values/8560)
**Author:** [@Johan\_de\_Klerk](https://clarionhub.com/u/Johan_de_Klerk)\ **Replies:** 25\ **Last updated:** [September 11, 2025, 2:22am UTC](https://clarionhub.com/t/using-set-key-key-to-only-get-assigned-values/8560 "2025-09-11T02:22:37Z")
Hi everyone, Let me try and explain the scenario. I have a Queue with a number of records (MyQueue, PRE(MQ)). Then a TPS file with main records (MyMainFile, PRE(MMF)). Then a TPS file with records that have a value i… --- ## [VIEW speed? TPS using a Filter on Primary Key](https://clarionhub.com/t/view-speed-tps-using-a-filter-on-primary-key/8427)
**Author:** [@johan\_rademan](https://clarionhub.com/u/johan_rademan)\ **Replies:** 6\ **Last updated:** [August 2, 2025, 1:37pm UTC](https://clarionhub.com/t/view-speed-tps-using-a-filter-on-primary-key/8427 "2025-08-02T13:37:28Z")
Hi, Trying to solve some speed issues, using TPS I enabled the driver trace to debug the following VIEW code The "next(ThisView)" generates a next in the driver trace for every record in the file. Using upper or not… --- ## [Monitor TPS File Keys Building](https://clarionhub.com/t/monitor-tps-file-keys-building/8381)
**Author:** [@jwabet](https://clarionhub.com/u/jwabet)\ **Replies:** 6\ **Last updated:** [July 17, 2025, 3:18pm UTC](https://clarionhub.com/t/monitor-tps-file-keys-building/8381 "2025-07-17T15:18:13Z")
Hi, How do you handle the BUILDing task With this code, i can't see what it was done if any. Any guidance please? Thank you. ?count{PROP:RangeHigh} = Records(Source) TheYearJan1 = DATE(1, 1, Year(today()) … --- ## [Speeding up batch deletion in Clarion (5M TPS records)](https://clarionhub.com/t/speeding-up-batch-deletion-in-clarion-5m-tps-records/8361)
**Author:** [@jwabet](https://clarionhub.com/u/jwabet)\ **Replies:** 18\ **Last updated:** [July 12, 2025, 1:29am UTC](https://clarionhub.com/t/speeding-up-batch-deletion-in-clarion-5m-tps-records/8361 "2025-07-12T01:29:27Z")
Hi everyone, i have a simple application to process two local TPS files (~5 million records each, 5 keys per file). I need to delete records based on a condition. The application contains only this single procedure. H… --- ## [LOGOUT - Unable to log transaction error](https://clarionhub.com/t/logout-unable-to-log-transaction-error/8348)
**Author:** [@PurpleEdge2214](https://clarionhub.com/u/PurpleEdge2214)\ **Replies:** 8\ **Last updated:** [July 3, 2025, 12:39pm UTC](https://clarionhub.com/t/logout-unable-to-log-transaction-error/8348 "2025-07-03T12:39:08Z")
Using Clarion 6.3, I'm trying to LOGOUT a single 80Mb TPS file, running locally and I'm getting the 'Unable to logout transaction' error. I'm not getting the error on another smaller version of the file. Does anyone kno… --- ## [Remove a key from the dictionary causes the tps file to error](https://clarionhub.com/t/remove-a-key-from-the-dictionary-causes-the-tps-file-to-error/8124)
**Author:** [@ThaDaSoft](https://clarionhub.com/u/ThaDaSoft)\ **Replies:** 2\ **Last updated:** [April 25, 2025, 2:29pm UTC](https://clarionhub.com/t/remove-a-key-from-the-dictionary-causes-the-tps-file-to-error/8124 "2025-04-25T14:29:01Z")
I had a key in my Dictionary, I no longer need it, so I removed it, but now I can no longer load my datafile - is there a way to fix this? --- ## [Migrate Clarion 5 to Clarion 9](https://clarionhub.com/t/migrate-clarion-5-to-clarion-9/8034)
**Author:** [@ThalesSilveirs](https://clarionhub.com/u/ThalesSilveirs)\ **Replies:** 10\ **Last updated:** [April 8, 2025, 3:02am UTC](https://clarionhub.com/t/migrate-clarion-5-to-clarion-9/8034 "2025-04-08T03:02:11Z")
I would like to know how I can proceed in this case. We have legacy software, but we are already reaching the limit of Clarion 5, as it uses TPS, and we would like to use Clarion 9. Any tips? It is not possible to do thi… [Next page](https://clarionhub.com/tag/tps/155.md?match_all_tags=true&page=1&tags%5B%5D=tps)