Zugg Software :: View topic - Problem with item database triggers *NEW QUESTION*

Novice Joined: 11 Aug 2003 Posts: 34 Location: USA

OK, I found out the problem... the only thing wrong now is that it is still adding duplicate records... this is my current IF statement, but i don't think its working because the %find function i think only works for string lists, not db vars (which is what @newrecord is)... How would I fix this?:

#VAR itemDoesExist %find( %item( @newrecord, 1), All)
#IF (@itemDoesExist = "") {
#WIN Chat Item does not exist, adding!
#WIN Chat @newrecord
#NEW All @newrecord
}

At the moment it seems like the itemDoesExist variable is always being ""... even if the item does exist

MASTER Joined: 28 Nov 2000 Posts: 4817 Location: USA

%item is a list function. If @newrecord is a database variable, use a database function, such as %db. Assuming the first column of your database is Name:
#VAR itemDoesExist %find( %db( @newrecord, Name), All)
#IF (@itemDoesExist = "") {
#WIN Chat Item does not exist, adding!
#WIN Chat @newrecord
#NEW All @newrecord
}

Novice Joined: 11 Aug 2003 Posts: 34 Location: USA

Thanks a ton LightBulb! Your help is always appreciated!