Recent content by Skc

This error message about "Duplicate Index" appearing the 2nd time or even the 3rd time happens at the end of your procedure. I am not sure why, but it could be that the error is serious enough that Progress wants to inform you again when it exits the procedure. Or it could be a minor quirk...

In tyring to import a CSV file into Excel using Progress, I have found that Trailing negative numbers in the Csv file are imported and treated as Text by Excel rather than numbers. Excel's OpenText method has a param, which I had assumed to be the 13th param called "TrailingMinusNumbers" which...

Yes your code does work except that I think you missed out to put the "-" sign infront. This is definitely one option I can use - thank you. ASSIGN BCellValue = "-" + SUBSTRING(BCellValue,1,LENGTH(BCellValue) - 1) WHEN SUBSTRING(BCellValue,LENGTH(BCellValue),1) =...

My source file DOES have trailing minus sign. I have done a Google search and it is confirmed that Trailing minus sign is treated as a Text rather than numeric. Via Progress Com Object Viewer, "Workbooks:OpenText()" shows 13 parameters available which is upto FieldInfo and excludes...

Your code should work but it does not in my case. Because there is another problem - the negative numbers I have in the csv files are with TRAILING minus sign. After import these negatiive numbers seem not be recognised as negative numbers by Excel. Tried setting TrailingMinusNumbers which is...

Import csv into Excel 2007 - FieldInfo I am trying first time to open Excel (Excel 2007 Trial version) from Progress (OE10.1B) and to import a csv file into Excel. The file is delimited by semi-colon rather than comma. The current codes :- Def var ExAppl as com-handle. CREATE...

Does anyone know how to programatically dial-up to another computer, ( in order to do some processing) and then programatically disconnect from that computer when it is done? Thanks for any help.

Prompt-for is the high-level equivalent or combination of 3 commands: enable, wait-for, disable. Using prompt-for and even higher-level commands like SET or UPDATE has not stop me from coding and using UI triggers in relation with them. The only difference I can see is that in wait-for, you...

Would you be kind enough to explain why it is not a good idea? Or could you point to some documentation? I would be interested to know why and whether any recommended alternative is indeed better.

It's the other way round. SET can be replaced by PROMPT-FOR and ASSIGN. The Progress recommendation of replacing PROMPT-FOR with SET or UPDATE is NOT right.

Yes you are right that the only possible option is to replace the prompt-for with 3 commands: enable, wait-for and disable. But isn't it easier to use only a single prompt-for? It's sometimes not a straight-forward 3 for 1 replacement. There's a need to also take care to disable the...

Does anyone here use Prompt-for? I do. And I found to my dismay that it is listed on the Deprecated list of commands in Version 10.1A. :blue: The recommeded replacement commands of set/update aren't useable. Comments anyone?

Hullo Chris Thanks for replying. So the search tool is currently the same. Perhaps there could be some explanation on how to get great search result. Frankly, I don't know what you mean by Naturual language :blush:. And I am guessing that Boolean means you can use AND / OR and perhaps...

Search Tool I distinctly remember that the Search tool here was great. It returned very useful results, better results than the one at PEG. But recently it does not seem to return good results. Was there a change? The Seach tool avalable in the Paid subscription, would it return better results...

I am making use of the excellent feature whereby I can subscribe to threads that I am interested in. By default, ProgressTalk would notify me IMMEDIATELY via email of any reply to threads that I started or that I participate in. On top of that the email notification contains the content of...