dbx error 3604

[Dwight Crevelt]

What is a DBX error 3604
I get this from a sqlquery execution

D2007, MSSQL

I can't find a list of DBX error codes anywhere

[Bill Todd [TeamB]]

Post by Dwight Crevelt
What is a DBX error 3604
I get this from a sqlquery execution
D2007, MSSQL
I can't find a list of DBX error codes anywhere

What is the complete text of the error message?

Did you Google for the complete text of the error message?

[Dwight Crevelt]

yes, I've tried everywhere

DBX Error: Error Code: 3604

MSSQL has a 3604 error on an Insert with a duplicate key, BUT I am using a
Select

SELECT cds_card.CardNumber, cds_card.Player_ID as PLACCN,
cds_player.LastName as PLLNAME, cds_player.FirstName as PLFNAME,
tiered_rank_player.Rank_ID as PLLEVEL, tiered_rank_player.Template_ID FROM
(cds_card INNER JOIN cds_player ON cds_card.Player_ID =
cds_player.Player_ID) INNER JOIN tiered_rank_player ON cds_player.Player_ID
= tiered_rank_player.Player_ID WHERE ((cds_card.CardNumber= 'A505002452') )
AND ((tiered_rank_player.Template_ID)>0))

Post by Dwight Crevelt
What is a DBX error 3604
I get this from a sqlquery execution
D2007, MSSQL
I can't find a list of DBX error codes anywhere

What is the complete text of the error message?

Did you Google for the complete text of the error message?

[Bill Todd [TeamB]]

I have not been able to find anything either. If I have any success
I'll let you know.

[Dwight Crevelt]

I changed to a sqldataset component and changed to parameters
and got it to work.

I am guessing it is something like bad SQL format or unsupported function
type of error

Thanks for your help

"Bill Todd [TeamB]" <***@no.com> wrote in message news:47ae32a9$***@newsgroups.borland.com...
I have not been able to find anything either. If I have any success
I'll let you know.

[Steven Shaughnessy]

can you enable tracing and provide the output from the error in the trace?

Post by Dwight Crevelt
I changed to a sqldataset component and changed to parameters
and got it to work.
I am guessing it is something like bad SQL format or unsupported function
type of error
Thanks for your help
I have not been able to find anything either. If I have any success
I'll let you know.
--
Bill Todd (TeamB)

[Dwight Crevelt]

As listed in my last post I got past it by switching to a tsqldataset vs
tsqlquery

I have to tight a development schedule to chase it down now.

Thanks

"Steven Shaughnessy" <***@b.com> wrote in message news:47b287a4$***@newsgroups.borland.com...
can you enable tracing and provide the output from the error in the trace?

Post by Dwight Crevelt
I changed to a sqldataset component and changed to parameters
and got it to work.
I am guessing it is something like bad SQL format or unsupported function
type of error
Thanks for your help
I have not been able to find anything either. If I have any success
I'll let you know.
--
Bill Todd (TeamB)