General information
Category:
Coding, syntax & commands
Hi all!
I'm getting an error which I can't figure out why...thus it's hard to debug ;^). I've used two SQL commands to create two views. I'm using the second one as a source for a report. I thought all was fine, but when I try to use the second view, rvmajorap2, I'm getting the following message:
"Base table fields have been changed and no longer match view fields. View field properties cannot be set (Error 1542)"
I don't recall any changes to the base table, so I'm a bit stumped. I checked the structure of the tables and things look compatible.
Any ideas??
Below is the SQL commands I'm using to create the two views.
*!* Create Major App report view #2 (get maucode name)
CREATE SQL VIEW rvmajorap2 AS SELECT *, ;
allcodes.dispval AS usedby;
FROM rvmajorap1 ;
LEFT JOIN allcodes ON rvmajorap1.maucode = allcodes.codeno ;
ORDER BY sysname
*!* Create Major App report view #1 (get matcode name)
CREATE SQL VIEW rvmajorap1 AS SELECT *, ;
allcodes.dispval AS support;
FROM majorapp ;
LEFT JOIN allcodes ON majorapp.matcode = allcodes.codeno ;
WHERE majorapp.acode = ?caid
Many thanks as always!
Mandy
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