Search results for query: *

Hi Wade, I have an utility program that dumps the selected columns into a Comma or Tab limited file that works on Topspeed/Clarion files. It allows you save the selections and load it the next time for extracting data. It it not yet programmed to look for the selections file in the command line...

Hi Karl, I do not use translation in my applications, but the help would be first place to start. As you can see from the help below, it is fairly simple. I am not sure if there are templates for translation but there are 3rd party products like BoTran...

Hi! You cannot BROWSE a CSV file as it does not support certain statements like PREVIOUS(). This has been rectified in the latest version of Clarion 8 but if you are using an older version, you only choice is to read the CSV file into a local Queue or In-Memory (IMDD) file and browse that. IMDD...

Hi! You need to use the SLEEP Windows API for that. In the Global MAP: MODULE('WinAPI') sjSleep(UNSIGNED xMilliSeconds),PASCAL,NAME('SLEEP') END Usage: sjSleep(100) ! sleep for 0.01 secs Regards

Hi Eduardo, You need the program manifest setup to run the program as Administrator to update certain registry trees. This is possible with Clarion 7 and later. If this is an one time update, I would suggest to use the installation program to do that. Or, use a different registry tree or...

Hi! It should be myGroup:field1 or BGRP.field1 and not BGRP:myGroup:field1. and use EVALUATE() i.e. message(EVALUATE(BGRP.field1)) Regards

Hi! Have you tried installing C6 in another folder and testing that? Could be b'cos of corrupted DLLs. Regards

Hi! Create a dummy hidden window with a RTF Text Control or a hidden RTF Text Control in your existing window, assign the memo column to it, use the GetText function and search for your string. Regards

Hi! Which version of Clarion are you talking about? What SP2 or SP3 are you talking about - Windows? If so, what version of windows? Regards

Hi Charlie, Some info on calling Google Earth :: Depends on what you want to do - the following post will show it is easy to map something like a customer address. .............................. Putting yourself (or anyone) on the map is a one liner! In a clarion program use in conjunction...

Hi! Instead of this, why don't you create an ALIAS of the table in the dictionary and use the Alias table to find your previous value & calculate? Regards

Hi! Check the GetText function of the RTFTextBoxObject in the help. Regards

Hi! If you are having a Child Browse for the Child Table range limited by the Parent, set the Child browse to FILE LOADED and then the RECORDS(<BrowseQueue>) will give you the number of Child rows. Regards

Hi! The Windows API approach :: Inside the Global MAP: MODULE('WinAPI') sjGetLastInputInfo(*LastInputInfo),BYTE,PASCAL,RAW,NAME('GetLastInputInfo') sjGetTickCount(),LONG,PASCAL,NAME('GetTickCount') END Data Section of FRAME: LastUserInput...

Hi! With TIMER(), how do you determine that no keyboard & mouse activity has not taken place? Regards

Hi! Read on the IDLE() command in the Help. The other way is to use the windows API. Regards

Hi! Without trying to open or access the table, it is difficult to find if it is use. But the below code will work to find out if some other user has the file already open. OPEN(<Table>, 12H) IF ERRORCODE() = 05 ! Access Denied !open by another user ELSIF ERRORCODE() !some other error...

Hi! Are you using the ABC or Clarion template? If ABC, <BrowseObject>.ResetFromBuffer() will help. Assuming COD:ID is the primary key column in the CODES table that is being displayed in the Browse, you can : COD:ID = <value> Access:CODES.Fetch(<PrimaryKey>)...

Hi! Even though IF ERROR() will work, IF ERRORCODE() is the more optimized way since ERRORCODE() is a integer number and ERROR() is a string. Regards

Hi! To create a relationship to the same table in the dictionary, create a ALIAS for the Table (Shift-Insert should work). For example, if CUSTOMER is the tables, create an Alias of Customer called CUSTOMERPARENTS and then relate the Primary keys of both these tables. Regards