Hi Members,

I tried to insert some values in to a tale in MS access. But I keep getting the message "Expected semi-colon (;) at the end of sql statement"

Here is the query I tried inserting

INSERT INTO dynamic_values VALUES(1,'test','test') WHERE not exists (SELECT 1 from dynamic_values WHERE agreement_id = 1 and dynamic_label = 'test' and dynamic_value = 'test' )

My scenario is that the table must not allow duplicate values to be inserted into the table.

 Kindly suggest on this.

Thanks

Did you try to add semi-colon like

INSERT INTO dynamic_values VALUES(1,'test','test') WHERE not exists (SELECT 1 from dynamic_values WHERE agreement_id = 1 and dynamic_label = 'test' and dynamic_value = 'test' ) ;

No luck :(

still I get same error "Missing semicolon (;) at the end of sql statement"

SELECT 1 FROM dynamic_values? Try this:

INSERT INTO dynamic_values VALUES(1,'test','test') WHERE not exists (SELECT * from dynamic_values WHERE agreement_id = 1 and dynamic_label = 'test' and dynamic_value = 'test' )

Hi,

I've even tried of this, SELECT * FROM <tableName>.

I just want to idealize the performence.

Whwt I try to do in this query is that, I wan t to restrict the data to be inserted into the table if <they alreay exists> for the condition I mentioned.

Can you suggest a way I could achive this!

Thanks,

If you try

IF NOT EXISTS(SELECT * FROM TABLE)

INSERT INTO TABLE (column) VALUES(value)

It will works.