VB 6 ADO vs Microsoft Query Analyzer
From: Maurice Boers (maurice_at_timbersoft.com)
Date: 04/26/04
- Next message: Greg Linwood: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Previous message: alphaCodeWarrior: "SQL Server Scema"
- Next in thread: Greg Linwood: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Reply: Greg Linwood: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Reply: Val Mazur: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 26 Apr 2004 15:51:02 -0700
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
- Next message: Greg Linwood: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Previous message: alphaCodeWarrior: "SQL Server Scema"
- Next in thread: Greg Linwood: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Reply: Greg Linwood: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Reply: Val Mazur: "Re: VB 6 ADO vs Microsoft Query Analyzer"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
