Search results for query: *

Is there any easy way to upgrade clients from version 10.0.0 to version 10.0.1? Or is it required for us to do another remoteclient install to every computer 10.0.0 is installed on? We installed 10.0.0 on about 100 computers already and then some errors popped up, and we were told to use...

Figured it out... switched up the order of the case and it now works correctly using the > '' ... thanks! rtrim(house) + ' ' + rtrim(streetName) + case WHEN apt > '' THEN 'Apt ' + apt ELSE '' END

same, error validating the formula... it doesn't seem to like the "IS" , either... as soon as i change the apt field to just be nothing, like a space, a value is returned for my streetString field... but when it's null, the streetString field is <null> very peculiar...

Hmm, that gives me an "Error validating the formula for column streetString" ...

that did it... however, one more question... how do i specifiy a null case? for example: case apt when '' then '' when null then '' else 'Apt ' + rtrim(apt) END this doesn't work for some reason... the following formula returns a <null> value for the field, when the apt field is null...

I want to make a field be a formula, but I'm having trouble... basically I want to concatenate a bunch of fields to make one string so I don't have to do it programatically. I have an address table that separates streetname, house, apt, lot, etc... but not every house has an apt or lot, for...

Ah ok, and will the "select Key from inserted" work for when a value is updated as well? Or would I have two separate keys, one that says "select Key from inserted" and one that says "select Key from updated" depending on if I have it as the insert or the update trigger? Thanks for the quick...

A follow up... I'm confused how I can only have the trigger act on the row that was edited... Basically I need to have a "where key = <however i can refer to the row updated/added>", but i don't know how to tell it to do this. Here's the current trigger, that updates everything in the...

Aha, got it... set up a trigger to update those fields to current_timestamp and user on an insert or an update... thanks! Didn't know about triggers, they'll come in very handy...

Is there a way to make it so when a field is updated, the user's ID and a timestamp is put into the field? I tried just using current_timestamp and user in the formula field, but when viewing all the records all it does is return the current time and current user for all the records (which...