Recent content by MrMoo

I have worked since I was young and have always had money in my pocket and the best memories I have are ones that didn't take money, sharing a laugh and a beer with my cousin or holding my brothers first kid in my arms. Those things have no cost/no monetary value and those things make me happy...

Look into R-Index. It will return the position from the right of the index of the string (in this case ".") you are searching for, then use substring to capture what's before and after it.

If you're customizing a report and need the information from scratch why not just write the query on your own, should take you no time at all.

Check out the mnd_det table it allows you to see who can run a menu (mnd_nbr, mnd_canrun). Might have to see which group an individual is in when comparing to this menu, check usr_mstr for the user you are searching for (usr_name) and their group (usr_group). Hope this helps a bit

Yeah I thought it odd he would say college instead of professor or something similar but took it to mean that's how they do things at his school, could be he meant colleague but if it was my colleague I'd have to smack them upside the head for the one variable request :) Oh I am not saying 'use...

I think this was an academic exercise, he even states that, to see if the students understand the concept of recursion and can implement it properly, but perhaps the teacher wanted to see if the students would use recursion on their own on something small like reversing an individuals name...

How big of a character string did you try? I am assuming this is because each run of the function rev calls itself so if you have a 400 character string it calls itself 400 times, which I think would explain why you are exceeding the nested block limits.

Ahh good ol recursion. Would you need a case for an empty string as well or would this program just return when it encountered that situation?

Wouldn't you have to escape the " so that it knows to place it in you input otherwise two adjacent "'s would be interpreted as an empty string? I am not sure what the escape is, maybe someone else would be able to help you on that, but you could try \".

You're right, I just tested it and it returns the same results. I knew there were probably better, cleaner ways of doing it I just created something that I knew would work and didn't spend anytime trying to improve it. So Kenny like Tamhas said it should be the following: for each table...

Hi Kenny, I think you could get the results you're looking for with the following: for each table Break By Art By Clr By Type By Date Desc By Time Desc if first-of(Art) then if first-of(Clr) then if first-of(Type) then Display Art Clr Type Date Time Value...

1) By is the equivalent of Order By I believe 2 & 3) I would assume from your result sets that Progress does a case insensitive sort. space then numbers then characters

I think there would still be music and hopefully my friends without money, those things cost nothing really. You can make music with anything, a couple of pots, an old jug, a washing board and if your friends bail when ya have no money well I don't think I want those friends. Also if the...

Well you could eat and wear money but they would not really be functional in either regard. Money is a means to an end but the end itself is what makes you happy. Think about watching football/hockey with your buddies when you're poorer and have a small tv and live in a cheap apartment you are...

So the facilities/things make you happy, and money is just a means to that happiness. So money by itself doesn't make you happy.