Insert statement

[Bell1991]

I have an insert statement and when i go to run it i get the following message:

You are about to append 1 row(s).. Once you click yes, you can't use the undo command to reverse the changes. Are you sure you want to append the selected rows?

I have never gotten this message before?

If i go in manually into the table and type in the values in the insert statement - it goes in fine...

any ideas?

 

[fredericofonseca]

search this forum for that message as it was replied on last week.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Bell1991]

Thanks

If you are referring to thread701-1057236 - this does not address my problem..

I am manually typing in an insert statement and getting that error..

 

[PHV]

I am manually typing in an insert statement
Can you elaborate please ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[fredericofonseca]

Then if it is not check your options settings.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[Bell1991]

I click on queries ->new->design view->then right click and select SQL View and type:

Insert into tblName (column1, column2) values (1, '2')

when i go to run the query - i get the message above.

 

[fredericofonseca]

As I said check your options settings. (You will need to search for the correct tab)

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com