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
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
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
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
4 matches
Mail list logo