View Complete Post
I have a computed column specified for a division, how can i avoid having the 0 division error? Is there a way to create an if statement so if the divisor of my formula is 0 I want the value to be 0...
Thanks for your help
After looking for a driver to open legacy dbf drivers to connect, the next level trouble a have is this one:
first, i can retrieve the data but when trying to filter by a parameter (somesc columns) i get an error.
The error says about the database can't determine some blah blah!
The error is a columm tha is formated ( 1234 ) about 8 space, fixed. The values in the query appears like that. I resolve this by Trimming Ltrim(ColumnName) and i get this (1234).
Now in SqlExpress, how can i filter by the new Trimmed Expression? (This is a primary key that the DBF use)
SELECT column1, column2, column3TABLE FoxProDB
SELECT Ltrim(column1) as NewExp, column2, column3TABLE FoxProDBWhere NewExpre = @NewExpres -Error-
I have a multiple text box in a list
Appreciate all the help!
So i was trying to use a calculated column that added 7 days to the start date of a calendar item. The calculated column worked fine because i checked with several tests. Then i tried using the Column as the End Time in the Time Interval Setting in the Calendar View. This broke Sharepoint. Not the normal graceful error im using to seeing from Sharepoint but the Server Error Page when a dump happens in a ASP page. I havent enabled the full error page because i assume its not like i can fix it, i dont have the source code.
Does anyone else experience this? If so is it a known problem and being worked on?