• Johan (unregistered) in reply to Piotr K

    Well this response just proves that you don't know the first thing about databases

  • david (unregistered) in reply to Iago
    Iago:
    No, you cannot write BASIC in a functional-programming style. It does not support higher-order functions. This means you simply cannot do FP in BASIC, period.

    :~) However, I have the advantage on you: I have seen a functional program written in BASIC. Like the man said: "any sufficiently complex software includes an implementation of a Lisp interpreter" That may seem like only a joke, but the humour lies in the truth: I have seen sufficiently complex software written in BASIC.

    In particular, the ability of BASIC to handle functions which take a function as an input, and output a function, ("higher level functions") is the basic requirement of a functional language. You just have to remember that in early BASIC a function is a line number.

    I'm often surprised at how limited people think BASIC was. It wasn't a joke: people wrote programs in BASIC.

  • Steve Carter (unregistered) in reply to bling

    And that, my friends, is why comment are good, mkay?

  • emjoi (unregistered)

    Okay, I've never done any programming in Oracle BASIC, so I might be wrong....

    Sometimes the programmer needs to catch the call to a built in function for debugging purposes. Put in a breakpoint, or some diagnostic console output text.

    So, you wrap a similarly named function around the original one, and do a bulk ctrl-H rename of all the calls to it in our program.

    In this case you can catch the input string, and what is returned. See if you are chopping up the string correctly.

  • Cloak (unregistered) in reply to Piotr K
    Piotr K:
    The real WTF it that they used stored procedures. Stored procedures are EVIL. PL/SQL is a very limited language in comparison with modern OO languages. It always ends up with having some part of business logic in Java/.NET application and some part in stored procedures which is a BAD THING. Performance of SP also often sucks if compared to dynamic SQL queries. Use SP only when really needed.

    You must be working with the worst DBAs on earth. SPs never suck and are definitely more performant than SQL on-the-fly. Simply tune your stuff! And you will always have Business Logic on the database side and if it's just the size of a table column. PL/SQL and T-SQL are not OO programming languages, they are there for the manipulation of data, something .NET or Java have not been designed for.

    But maybe you should first meet a decent database guy whou could explain you how to do things right.

Leave a comment on “No Thanks, I Prefer SUBString!”

Log In or post as a guest

Replying to comment #:

« Return to Article