Re: VB 6 ADO vs Microsoft Query Analyzer
From: Val Mazur (group51a_at_hotmail.com)
Date: 04/27/04
- Previous message: Val Mazur: "Re: SQL Server Scema"
- In reply to: Maurice Boers: "VB 6 ADO vs Microsoft Query Analyzer"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 26 Apr 2004 23:55:36 -0400
Hi,
You should be more specific. Do you get any error? If yes, then what kind
of. If this is not an error, then you should describe what is wrong
-- Val Mazur Microsoft MVP "Maurice Boers" <maurice@timbersoft.com> wrote in message news:e6%2310D%23KEHA.3052@TK2MSFTNGP12.phx.gbl... > Hello > > I have a sql update statement thats quite large with several "select > nests". > It generally takes an hour to run when I need to effect a lot of records. > > In VB6 using ADO, I issue the statement and sometimes the update doesn't > actually preform the write (I think when I get over a certain # of records > being updated). whereas the same statement (printed my string & > copy/pasted > in Microsoft Query Analyzer) functions just fine. > > Can anyone give me a hint on what ado setting may make VB preform like > query > analyzer > > (I could put my nests in temp tables, but I'm curoius what the difference > in > defaults are between the 2) > > Thanks > Maurice > > >
- Previous message: Val Mazur: "Re: SQL Server Scema"
- In reply to: Maurice Boers: "VB 6 ADO vs Microsoft Query Analyzer"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
