Search results

If I have a rowid but don't know the table it relates to, is there any way to locate the record and then identify the table? Other than doing this: def var bh as handle. def var fnd as logi. def var rwid as rowid. rwid = <a valid rowid>. for each _file no-lock where...

Can someone tell me how to determine which index on a table is the Primary one by reading the meta-schema. Everything else I need is there e.g. _Index-Name, _Unique, _idx-num, etc but I can't for the life of me figure out where to fine the Primary indicator. Thanks in advance.

We have been experiencing rather lack lustre performance over the past year or so since upgrading our server. During some recent research on Progress Talk I noticed an article pointing out the running the DB in a Raid config is pretty much the worst thing you can do for performance and...

Hi all I have used the "for each _file , each _field of _file" to retrieve field names from dbs many times in the past but have now struck a small problem that has me scratching my head... The "for each _file" returns tables in the current working database only so the question is, if I have...

Hi all, we have been a Progress shop since Version 3 so are well versed in the ways of PSC. We have had a recent request to build a number crunching system that needs to cater for up to a 100,000,000,000 (yes 100 million) transactions per annum. Can't tell you anymore at this stage but let's...

Having been a Progress house since 1986 we are now wanting to offer internet access to our application. We have prototyped a portal using WebSpeed and sent it to a security consulting firm for review and penetration testing. Their findings indicate that WebSpeed fails on 5 our of the 10 key...

I need to extract the names of tables referenced in either .r or .p/.w code. Does anyone know how to do this in V9? Cheers

Hey Guys Has anyone developed an interface to Xignite data? I am specifically interested in their GlobalHistorical feed for close of day share prices. I need to build an interface but am a bit (read totally) lost on how to go about it... So I'm hoping that one of you good people out...

Hi all I need to send Hex parameters to a COM object method. An example is: XYChart(width,height,bgcolor) where bgcolor must be passed as Hex. Therefore Progress code could be something like: chChart:XYChart(200,200,&FF000000) Progress of course doesn't like the &FF000000 Can anyone...

Can anyone recommend a source code manager? I've had a quick look at SourceSafe but wondered if there was anything around that specifically works with Progress?

Hi I am having trouble releasing Excel from memory. The following works just fine; Excel is loaded and released from memory correctly: CREATE "Excel.Application" chExcel. chBook = chExcel:Workbooks:Add. chSheet = chBook:Sheets:Item("Sheet1"). chSheet:Activate. RELEASE OBJECT chSheet...

Hi All, Simple question I hope. I want to set SESSION:SUPPRESS-WARNINGS=YES as a default whenever I start the uib. Can someone remind me where I can do this without having to have it in a .p that fires off the shortcut? Cheers

Hi All Can anyone tell me how to trap an error returned from a COM object. For example: If "Sheet1" doesn't exist in chSheet = chBook:Sheets:Item("Sheet1") then we get an error dialog If "Sheet1" doesn't exist in chSheet = chBook:Sheets:Item("Sheet1") NO-ERROR then we don't get...

Hi All This should be an easy question... If I want to send the follow commands to Excel: With ActiveSheet.PageSetup .LeftHeader = "This is the left side" .CenterHeader = "This is center" Would I need to send as: chExcel:ActiveSheet:PageSetup:LeftHeader = "This is the left side"...

Hi I am building a 2d line chart in Excel 2007. Can anyone explain why the following code generates the message "an error occurred while accessing property/method 'line' - unknown name". chExcel:ActiveChart:SeriesCollection(1):Line:Color = 7. (I have also tried replacing the 7 with a...

Hi I have a window that holds 5 browsers all containing buffers of the same table but with different keys so each contains different records. The user needs to move records between browsers and at the moment I have a popup menu that allows them to choose which browser to move their selected...

Hi All I have a pdf template with fill-in fields that I am using PDFInclude to populate. Whilst all the fill-in fields are populated correctly in the finished pdf file, if I pass a € as part of one of these fields to PDFInclude it outputs a square black box. Obviously this is a character set...

Hi all I know this is in the documentation somewhere but I can't find it... Does anyone know the size limitation for an editor widget set to "large". I am copying and pasting from a large Word document and am getting a message advising I am exceeding the maximum available. No problem on...

Hi All Has anyone used this utility? I am running 9.1E under Windows XP Pro. It works brilliantly except when I try and attach an Excel spreadsheet. When trying to open the attached spreadsheet on receipt of the email I get a message saying '<file name> cannot be accessed. The file may be...

Hi All Something weird I thought I'd share and maybe get an answer to. I have many buttons in procedures that start other procedures. Quite often when I click one of these buttons, work in the window of whatever it was that was started, then close and return to the window with the button...