sql server new users: Operand type clash: text is incompatible with float -- sql server new users

You're in the

sql server new users

group:

Operand type clash: text is incompatible with float

Nancy
3/29/2007 10:35:09 PM

sql server new users:

I have an error here I have never seen before. I am inserting probably
about 350 fields in a form and a similar form with about the same number
fields works just fine . .but this one throws the error in the subject line.

Of course the error line is on the command itself .. where should I start
looking in this massive form for the problem and what sort of problem am I
looking for?

Thanks!
Nancy

Re: Operand type clash: text is incompatible with float

Andrew J. Kelly
3/30/2007 12:00:00 AM

I assume the app is building an insert statement dynamically and then
executing it. If so you might want to run profiler and capture the Batch:
statement starting event so you can see what the actual insert statement
looks like. You can then copy that into QA and try to run it from there. You
will most likely get a better error message.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]

Re: Operand type clash: text is incompatible with float

Nancy
4/3/2007 4:35:46 PM

Thanks, Andrew .. I didn't check right away and didn't realize anyone
answered me. I was inserting a statement, but not using the code to pull
the ID of the newly inserted record back out for use in the statement ..
therefore .. the error.

All is well.

Thanks,
Nancy

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn