Hi, i have a Drop Down in a Notes DB witch fills the values from a view (code below).
Now the problem is that i need an alias, and this on has the wrong datatype.
@Text(@DbColumn(“”;“”:“”;“vProject”;1)) + “|” + @Text(@DbColumn(“”;“”:“”;“vProject”;2))
The label is a normal Text Field and the Values are a Integer Field.
If i select a value on the Drop Down and saves this, i get this message on the view:
“The data types of two matching results are incompatible”
I’m do converting on the view the integer field with this “@Text(ddValues)”.
The other prob is that if i select one value the Drop Down is going back to its initale state (first entry)!?
has anyone a tip form me?
thanks in advance
Volkan
Subject: RE: The Alias has the wrong Datatype…???
The message “The data types of two matching results are incompatible” means that the values read from the same view column have different datatypes. Probably, some of the view rows contain a number and some contain a string. There is no way you can successfully read this column using @DbColumn.
You will need to change the view design, or change the data in the documents, so that all the data in that column has the same type.
if i select one value the Drop Down is going back to its initale state (first entry)!?
This is because all the keyword values are the same (they all contain the text, “The data types of two matching results are incompatible”), so it shows you the first keyword text whose value matches the value currently in the field. Fix the other problem and this one will go away.
Subject: The Alias has the wrong Datatype…???
Try to convert to text directly in view instead of after @DbLookup. Column formula will be: @Text(field1)