Hi:

I have a program where I generate a number of views for a database named PSS. I'm having a problem with the following view when I use version #1. The table that I'm including in the view in version #1 exists and I see no problem with it.

When I issue the following sequence of commands, I get an error

'View definition has changed'.  

When I rerun the program with version #2, the problem goes away. What gives?


Thanks,

Yossi

SQL Definitions:


Version #1:

*!*	CREATE SQL VIEW "lv_actdels" ;
*!*		AS SELECT lm_flcode, SUM(lm_hddelvf) AS totdels, MAX( lm_dlvdat ) AS lastdel, ;
*!*		NVL(ad_qty, 0) AS adjqty ;
*!*		FROM it!lotmast LEFT OUTER JOIN it!adjdels ;
*!*		ON lotmast.lm_flcode = adjdels.ad_flcode ;
*!*		WHERE lm_flcode IN ( SELECT fm_flcode FROM lv_flklist ) ;
*!*		GROUP BY lm_flcode ;
*!*		ORDER BY lm_flcode

Version #2:

CREATE SQL VIEW "lv_actdels" ;
	AS SELECT lm_flcode, SUM(lm_hddelvf) AS totdels, MAX( lm_dlvdat ) AS lastdel ;
	FROM it!lotmast ;
	WHERE lm_flcode IN ( SELECT fm_flcode FROM lv_flklist ) ;
	GROUP BY lm_flcode ;
	ORDER BY lm_flcode


Commands that generate the error when version #1 is used:

CD \agp
OPEN DATABASE data\it
OPEN DATABASE data\pss
USE pss!lv_actdels NODATA IN 0
REQUERY()