I have a view in my data environment called lv_status_tbl. This view is based on a table called status_tbl. My grid has recordsource 'lv_status_tbl and recordsourcetype is 'Alias'. When I requery my grid I keep getting errors that 'Alias is not found'. The following is the code I use:

for i = 1 to 2
....
....

		IF cItem=='ITCFIELDS'
			INSERT INTO status_tbl (DESCPT) VALUES ('ITCFIELDS record '+TRANSFORM(z)+' updated') 		
			REQUERY('lv_status_tbl')
		ELSE
			INSERT INTO status_tbl (DESCPT) VALUES ('UDFIELDS record '+TRANSFORM(z)+' updated') 		
			REQUERY('lv_status_tbl')
		ENDIF
		.grd.refresh()

Has anyone else run into this before.

Thank
Nick Patel