Recent content by rpenridge

Thanks but unfortunately that only labels the column - it doesn't actually change the field name.

Hi All, Am simply trying to rename a column in an sql query in Progress 9.2 (from the tracks):- The following query:- select pt_part as part from pt_mstr. ...gives me:- ** Invalid datatype -- sample types are: char, integer, date, logical (222) And this query:- select pt_part, 1 as...

Hi All, I need to corrupt some data for demo purposes and need a way to replace the real customer number with a random customer number from my customer table. Sounds simple enough but... What is the best way to return a random row from a table? I need this to be quick! There is a lot...

Hi All, We are currently getting quite a few log entries along the lines of the following: 09:02:23 Usr 7: Field 15 from so_mstr record (recid 7867712) was missing from FIELDS phrase. (3782) Does anyone have any idea as to how I can track down what is causing this error. According...

Hi All, To speed up a delete process I would like to do something along the lines of: output to myFile. put v_salesOrderNumber skip skip skip skip. output close. input from myFile. run salesOrderScreen.p input from terminal. This piece of code would be called repetitively with a...

One other thing to note... if you have two files in a directory rob.1 and rob.11 the command: ls -l | grep 'rob1' would return: -rwx------ 1 rpenridg users 9880 Mar 1 12:57 rob.1 -rwx------ 1 rpenridg users 10169 Mar 1 12:36 rob.11 To make sure that you only...

Hi Rob, I just took a look at their website then (http://www.walkaboutyourdata.co.uk). It looks like quite a useful product. Has anyone out there had any experience using it? Rob

Hi All, OK, at the risk of being torn to pieces by all the progress veterans out there I have a bit of a bone to pick... I am in the process of writing a report requiring many different levels of sub-totals and totals and am horrified at the lengths I have to go to to achieve this...

Hi All, I have only ever used progress in a UNIX environment and was wondering what sort of benefits you get from the Progress IDE in windows. Does it make life a lot simpler (speed up code/screen development etc...)? Can you browse through tables in MS-Access style - that kind of thing? Rob

It's been a _very_ long day... what am I doing wrong with the following code?: def temp-table tt field f as decimal format "zzzz9.99" field g as decimal. create tt. assign f = 999.00 g = 1. for each tt break by g: accumulate f (sub-total by g). end. display...

Hi All, I can't figure out the correct format to get my decimals to display the way I want them to... any ideas? value display 999.00 999 999.50 999.5 999.55 999.55 Thanks Rob

I take it the speedscript needs to be processed server-side like ASP? How does this affect what web servers you can use? How is the web speed server installed exactly? rob

Hi All, MFGPRO 85e, HP-UX machine. I am trying to CIM to 25.5.1 - General Ledger Budget Maintenance. My CIM runs without any errors but upon going back to browse through it, no changes have been made. :bawl1: Can anyone explain why this might be happening? I have tried many...

Hi, I'm talking about preprocessor directives, eg.... &scoped-define str pt_part for each pt_mstr no-lock by {&str} : display {&str} . It is a dud posting though because I have managed to figure it out in the meantime (although I was too slow and wasn't in time to delete this...

yeah - i have read on other posts that v9 has dynamic queries that let you do that, but i am running v8.3 with no chance of upgrading to v9 for quite some time... is there any way to do this without using dynamic queries? rob