How to keep ado.AddNew() from causing a select *

[dan seeman]

Every time I call ado.AddNew() a select * from Table is generated.

This is a large table and the unqualified select * statement causes my add operation to get progressively slower as the table size grows.

How do I keep AddNew from generating the select * statement?

My db is sql server 2005.

My client code is in python, through ado.

[ck9663]

This is more of a Python question, than a SQL Server question. Try posting this in Python forum.

Good Luck!!!

~~ CK

[NeoPa]

I'll move this to Python for you, but you may want to consider explaining the situation more clearly. Where is the SELECT * created? In a variable? In a table? In your living room? I expect whoever chooses to try and help will need decent information if they're to be of any use to you.