Recent content by bendaluz2

  1. B

    multiple indexes

    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 :)
  2. B

    replace large amount of data

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

    Why Is Progress Still Here?

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

    Why Is Progress Still Here?

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

    URGENT!!!! Need some help with PROGRESS error!!!

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

    Why Is Progress Still Here?

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

    Delete an item in a comma separated list

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

    Delete an item in a comma separated list

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

    Display-Format in a Browse

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

    Display-Format in a Browse

    ->>,>>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...
  11. B

    Filling an Excel-Sheet with an dynamic browse

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

    _printrb.p and it`s RBFILTER

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

    _printrb.p and it`s RBFILTER

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

    Filling an Excel-Sheet with an dynamic browse

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

    Newbie needs some real basic information

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