You searched for the word(s): 2
-
I can't because the outer implicit transaction definition will cause the inner transaction to be rolled back.
-
Yes, I thought of that but the problem is that the field already exists in online database and I cannot change it to a number field. If this is the only way to do it, then I will have to add a new field to the database. There is no way to create a formula to look at the field and convert it to a number?
thanks!
-
its always the darn cat; I thought something looked amiss, that is working, thank you! next question is There are about 10 Check boxes is there formula to add to what we have now so that it will start a new line in the Rich Text Box,
Also and less important than the above is there a way to make the text box default to using bullets?
-
You are missing the concat:
concat(substring-after(now(), "T"), " ", userName(), DAY_TEXT_1.0)
-
Actually, I think Anuma meant that if the field in your database is smaller than the amount of characters typed into the field on the form, the form information will be truncated on submission to the database. I don't know of any character length restrictions, unless you set one on a control, via its properties or data validation....
-
Here is what I am trying to use but I know I am doing something wrong with the syntax. Sorry I am just learning all of this.
substring-after(now(), "T"), " ", userName(), DAY_TEXT_1.0
What I am wanting to see is when a user checks the box I get Time (MILITARY) Username What ever was in the text box ...
-
You can workaround the rollback by adding a begin transaction/commit transaction to your query command or the stored procedure.
-
You could change your initial textbox (with the value of FL, GA or PR) to a drop down list. Your 'Display' text could be FL, GA or PR, and your 'Value' could be the corresponding number that is correct for that field...Then when the user selects 'FL' the actual field value would be 1 and you'd be able to filter with ...
-
-
Yes this is true, thanks Anuma.
Also remember as Anuma has displayed above, feel free to use " " or " _ " or any variation similar to Excel formuals to seperate the fields as much as you want.