Search results

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...

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

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

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...

Pre-Processor Question Hi All, I want to build a for each loop that let's the user choose the field order of the break by statement. How can I do this? I thought about using the pre-processor to do it but can't get it to work... if choice = "Product Line" then do: &scoped-define str...

Hi All, What does the & symbol do and how do I use it? I can't find any documentation for it in the manuals and it's too hard a symbol to search for threads on. Thanks Rob

Hi All, I need to simulate sending the END-ERROR key in a bulk load program. The key is bound to the F4 (or PF4?) key, or CTRL-E also works for me. According to my calculations: F4 is 304 in DECIMAL and 460 in OCTAL PF4 is 404 in DECIMAL and 624 in OCTAL CTRL-E is 5 in DECIMAL and...

Hi all, I have an SQL statement that I am trying to translate into progress. Can anyone help? select lad_site as ttlad_site, lad_loc as ttlad_loc, lad_part as ttlad_part, lad_lot as ttlad_lot, lad_ref as ttlad_ref, sum(lad_qty_all) as...

Hi All, I was wondering if anyone knows if it is possible to use SQL insert to populate a temp table. I have tried but keep getting the error: ** Table ttLad1 does not exist or cannot be accessed. (962) Sample Code: /******* define temp-table ttTemp field tt-a like source.a...