Search results

You will see great benefits if you add an index with Cid, Div, LoanNumber, BudgetID assuming every check in your where clause is an equality match Hope that helps :)

An inequality match in a where clause will cause progress to do a whole index scan (regardless of whether the use-index phrase is used) should be expressed as a range match to use an index for each Parts where Parts.Partno < "" or Parts.Partno > "" and Parts.Prod_code...

You are correct, I am a Progress lover, but i'm not the naive single language programmer you take me for. I have experience in Assembly, C, C++, Pascal, Fortran, VB, Delphi, Java and c#.net. Of all of these languages, Progress is the most stable, the most natural to program in and has by far the...

pmsl. you've obviously never tried to write a large sized application using SQL server or oracle then have you

Personally I find writing code against oracle or sql server awful. SQL is soooo clunky and awkward to use compared to a proper 4GL

On the other hand, its a good job Progress would let you do this or else you wouldnt have been able to write your "VB app where the triggers were to be by-passed by your application". Sounds like your all singing, all dancing centralised control would be a bit restrictive in this situation. In a...

Ok, my implementation is a little more cumbersome, but imagine a list like "Customer,CustomerID,CustomerName,CustomerNotes" Try removing Customer from that list with your method ;) Now, imagine JulieT's example extended a bit...

That wont work if the entry you want to replace is last in the list here is a generalised function FUNCTION RemoveItemFromList RETURNS CHARACTER (pc-list AS CHARACTER, pc-removeitem AS CHARACTER, pc-delimiter AS CHARACTER): DEFINE VARIABLE li-pos AS INTEGER NO-UNDO...

True, but as your field is a decimal, I am presuming that you have some records that have a decimal portion

->>,>>9.99 is the default format mask for a decimal field and is how table.kontonr has been defined in the database. This is why tt-tmpmahn.kontonr has this format mask when you define it LIKE table.kontonr. You need to override the format mask with one that can cope with the data in your...

Yeah, Excel will do that :rolleyes: tries to determine data types for the columns. Once the file is loaded, you will need to get a com handle to the column and change the datatype or.... this is a longshot.... Stick quotes round the date and put a space at the front or back. hopefully...

In report builder, specify the join where clause and the type of join (inner, etc..) e.g. (Based on Sports2000) Master Table: Customer Add a new inner join to Order with the field cust-num Then, in the filter you pass to report builder specify the where clause you want (the join you...

You specify the inner join within the "joins" screen in the "database" menu within report builder itself. then in the filter, you specify the where caluse you require

Sorry, OLE is SLooooooooOOOOOW :tear: You could try doing something like...... Export your data as a csv. Invoke an instance of Excel, read in the csv file then do any manipulation you need to do, ie formatting, formula's etc.... This will probably give you a lot more speed HTH

You need a "provision" licence to develop applications on one machine with local databases. If you want to host the databases on a server(which you almost certainly will need to in a production environment), you will also need an "enterprise db" licence. You will also need "client networking"...

In the instance that works, you are using the BUFFER-FIELD method of a BUFFER. In the second case, you are using the BUFFER-FIELD attribute of a BROWSE. They are not the same

Yeah, i'd delete them when the program exits Look in the progress help (Start | Programs | Progress | Help) <- Or under whatever structure you have installed it in on the Index tab, use the search to find the item "BROWSE widget" On this help page, there is a section called...

Noticed another thread you started. From the field names, I think I've used the application you're talking about. Agreed, it is crap :(

Well, that told me :blush:

Pure genius! That will have me laughing for ages, cheers BCM: I dont think anyone here really cares what you do. You clearly know better than us, good luck to you pal. One thing though....once you've finished your mega app, why dont you tot up how much it cost you to write, then go to the...