False 'invalid column name' error? Is there a cache to clear?

[myworkaccountforsql]

if i run this code

SELECT 'form' AS component, 'Add a user' AS title;
SELECT 'S3_number' as name;
SELECT 'EntryDate' as name;
Select 'Absence' as name;
select 'Notes' as name;

INSERT INTO [WeLP_web].[dbo].[Absence] (S3_number, EntryDate, Absence, Notes)
SELECT :S3_number, EntryDate, Absence, Notes
WHERE :S3_number IS NOT NULL AND EntryDate IS NOT NULL;

SELECT 'table' AS component, 'Users' AS title;
SELECT TOP (1000) [S3_number]
      ,[EntryDate]
      ,[Absence]
      ,[Notes]
      ,[UniqueID]
  FROM [WeLP_web].[dbo].[Absence]
  order by EntryDate DESC

I get this error

If I comment out the insert code

SELECT 'form' AS component, 'Add a user' AS title;
SELECT 'S3_number' as name;
SELECT 'EntryDate' as name;
Select 'Absence' as name;
select 'Notes' as name;

--INSERT INTO [WeLP_web].[dbo].[Absence] (S3_number, EntryDate, Absence, Notes)
--SELECT :S3_number, EntryDate, Absence, Notes
--WHERE :S3_number IS NOT NULL AND EntryDate IS NOT NULL;

SELECT 'table' AS component, 'Users' AS title;
SELECT TOP (1000) [S3_number]
      ,[EntryDate]
      ,[Absence]
      ,[Notes]
      ,[UniqueID]
  FROM [WeLP_web].[dbo].[Absence]
  order by EntryDate DESC

It shows data from the column fine in the 'list' thing

Running a similar insert comment just in SSMS works no problem

I had something similar in SSMS and the top suggestion in this thread https://stackoverflow.com/questions/7260487/sql-server-reports-invalid-column-name-but-the-column-is-present-and-the-quer fixed it be using a key combo to clear a cache. Is there something similar here? or am I doing something wrong?

[lovasoa]

You can stop and restart SQLPage

[Aesth]

Try it

INSERT INTO [WeLP_web].[dbo].[Absence] (S3_number, EntryDate, Absence, Notes)
SELECT :S3_number, :EntryDate, :Absence, :Notes
WHERE :S3_number IS NOT NULL AND :EntryDate IS NOT NULL;