General information
Category:
Forms & Form designer
Thanks,
pointed me in the right direction.
CREATE SQL VIEW "lvSCHOOLS" AS;
SELECT code_a.ccodedesc as cschooldesc, code_b.ccodedesc as cschoolcntry,;
SCHOOLS.cmajor, DTOC(SCHOOLS.daward) as cdaward, ......
DTOC is based on the underlying data in the table and does not consistently return the same length? Not sure but removing this field ended the problem so im fairly sure you were correct. I would probably have ensure i was geting a correct result or SPACE(10) in an IIF statement to force this to work..
Mike
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only