Not another Bass Guitar playing FileMaker developer !! Sorry - we don't have a website for "Major Groove" yet...

Russ

i have a calc field like this:

numcalc (result=number): TextToNum(textfield).

if i write a 5 into textfield, 5 appears in numcalc. if i write letters, numcalc stays empty, except, and this is the weird part: when i write the letters f or n, it evaluates to 0, and if i write the letters t or y, it evaluates to 1. what the hell is going on? supposedly, non-numeric info in a number field is ignored.

These are booleans !

t = true = 1

f = false = 0

n = no = 0

y = yes = 1

Is it just me, or would The Booleans be a cool name for a rock band?

And the name of The Booleans first single is....

True or False!

Who can come up with the rest of the album!!

[ April 05, 2002, 05:27 AM: Message edited by: Andy Gaunt ]

thanks guys! i'm a music producer - i'll think about casting an act called the booleans. until then, i'll rewrite my calcfield ;-)

Booleans' second single: "The Zen Answer"

Think about that one.

Count me into band! As producer (more than 1 400 000 single album sale, all together sold over 2 millions) and as drummer

I'm sure the Booleans have included a cover version of SuperTramp's "Logical" on their first alblum.

Perhaps they could also re-do Elvis' "Caught In a Trap" as "Stuck in a Loop"...

Russ

Then There's...

code:

---

Is It True (The Eagles)

True Believers (Hunters and Collectors)

Can't Not (Alanis Morissette)

True (Spandau Ballet)

If Not For You (Bob Dylan)

When All Else Fails (John Farnham)

Tried To Be True (Indigo Girls)

Somebody Else (Glen Frey)

Logical (Supertramp)

Say It Isn't True (Jackson Browne)

Russ

[ April 05, 2002, 11:06 PM: Message edited by: Russell Baker ]

ah, so now we know why girls are never true:

Name (TextField)

cResult (CalcField result=text).

write 'girl' into text field and it stays empty. you can even make it into a repeater, or return-delimited bigger field, enter babe, woman, chick, whatever, it's never true!! it's even worse if you enter 'niece'.

Try "yenta." You'll see why you should always take a yenta's advice.

Well, since this has turned into a musical free-for-all, I have to plug my current band:

www.kathywalker.com

Next single = If that’s The Case

And it goes on:

Just a Related love affair

My heart IsEmpty(Without U)

Your Case IsValid

Since you Left(me)

I’m no longer Right(withoutU)

The Position(you got me in)

It’s a Random chance

Substitute(My Heart)

You drive me crazy with your PMT

Is this the Sum(Of our love)

ok, since this topic has gotten way out of hand anyway, i'll plug my filemaker joke for music lovers:

http://www.rootsolutions.de/downloads/StMartin.sit (a 7K stuffit archive with a FP3 file)- enjoy!