RE: Re: what is ODBC 37000 error ??

2000-05-17 Thread joeug
What Sql server version are you using? Are you overiding any Constraint violations? Primary key, foreign key etc Doing all the looping, i guess would slow down the transaction and might fail. If you are searching through large junks of data and have parameters for this, it would be apt to do

RE: Re: what is ODBC 37000 error ??

2000-05-17 Thread vincy
hi Joe, Im using CF 4.0 enterprise server. And not overriding any constraint violations. The first part of the code searches for the parent categories, then searches for child categories. Then totals all the items for sale in each category so on ... -- So, these are the very

RE: Re: what is ODBC 37000 error ??

2000-05-17 Thread Joseph Eugene
Message-- From: vincy [EMAIL PROTECTED] To: [EMAIL PROTECTED], [EMAIL PROTECTED] Sent: May 17, 2000 1:34:15 PM GMT Subject: RE: Re: what is ODBC 37000 error ?? hi Joe, Im using CF 4.0 enterprise server. And not overriding any constraint violations. The first part of the code searches