Just got this far. SELECT COUNT(*) FROM CLEAN_MILE_DUPES = 0. No error, it just went to the next line. This is on *my* machine! <going to go tear out my hair>



I want your code to work for...

I'm debugging right now, and of course it's working fine on my machine.

One of the other databases didn't have 0 records in the milestone table, it just had about 200,000 less records than it...

Here's my milestone table:

CREATE TABLE [CASE_MILESTONE_TEMP] (
[CASE_IDENTIFIER] [varchar] (10) NULL,
[DOCUMENT_TYPE] [varchar] (3) NULL ,
[DOCUMENT_NUMBER] [varchar] (3) NULL,...

I'm at a complete loss. The SQL above, and two other similar statements, work fine on my machine. Now, instead of just the one statement above giving me problems, all three are. They act as if...

It's not a connection object error. The first truncate works fine, the first insert doesn't insert anything into the CLEAN table, the second truncate works fine, then there's nothing to be inserted...

Hello,

I'm using VB6 and SQL Server 2000.

I've got a problem with an insert statement that seems to be randomly failing. Its job is to copy everything from one table into another, removing...

I found the solution:

http://www.experts-exchange.com/Web_Development/Web_Languages-Standards/ASP/Q_20809772.html

All you have to do is scroll all the way to the bottom of that page to see the...

I have SQL code in my VB6 project for select, insert, and truncate. For example:


strSQL = "SELECT CASE_IDENTIFIER" & vbCrLf _
& " ,DOCUMENT_TYPE" & vbCrLf _
& "...

http://vbnet.mvps.org/ is the best place for finding this kind of code. I found this:

http://vbnet.mvps.org/code/fileapi/createfile_inuse.htm

Hope that helps!