Re: Iif() and StructKeyExist()

2003-02-23 Thread Jann VanOver
On 2/20/03 1:17 PM, Aidan Whitehall [EMAIL PROTECTED] wrote: I've got an array of structures and am looping through them and writing several queries on the fly. However, I can't hit on just the right combination of quotation marks to stop it throwing an error. Does anyone know how to write

RE: Iif() and StructKeyExist()

2003-02-22 Thread Aidan Whitehall
I don't think you can use IIF in this case as IIF has a habit of evaluating both results regardless of whether it resolves to true or false. Even if proximity doesn't exist, it will still evaluate values[i][proximity]. Yeah, that's how it's starting to look. Well, thanks for the

RE: Iif() and StructKeyExist()

2003-02-21 Thread David Collie (itndac)
dont have time to test, but would it not need to something like this??? #Iif(not StructKeyExists(values[i], proximity), DE(null), DE(values[i][proximity])))# You would then need to check the value and decide whether quotes would work Could be wrong... my 2 secs worth -Original

RE: Iif() and StructKeyExist()

2003-02-21 Thread mark brinkworth
I don't think you can use IIF in this case as IIF has a habit of evaluating both results regardless of whether it resolves to true or false. Even if proximity doesn't exist, it will still evaluate values[i][proximity]. Cheers I've got an array of structures and am looping through them and