Viewing 15 posts - 2,296 through 2,310 (of 6,216 total)
April 11, 2003 at 9:51 am
I agree with Antares - normalize fully, then see how it works. More often than not, it works well!
Andy
April 11, 2003 at 6:46 am
April 11, 2003 at 6:44 am
Use either Exec() or sp_executesql, the latter is usually preferred because SQL will try to cache the query plan. In either case the string executed run's with the callers permissions....
April 10, 2003 at 5:41 pm
Good idea to run MDAC 2.6 or higher, and to use OLEDB instead of ODBC. Regardless, the prompt should show up only if you force it, or the connection isn't...
April 10, 2003 at 3:25 pm
Good comment.
I prefer to delete (unless you have the location thing going on) rather have to filter the deletes out (I know, use a view, but that assumes everyone remembers...
April 10, 2003 at 3:22 pm
Seems like a good idea. Don't know on the search, Brian implemented, will have to get him to check.
Andy
April 10, 2003 at 6:03 am
Let's be patient everyone! Somehow we'll figure out what we mean, or what we meant to mean. Know what I mean?
Andy
April 9, 2003 at 11:43 am
I moved a server from 6.5 to 7.0 to 2K, never had your issue...luckily! Sorry that doesn't help much.
Andy
April 9, 2003 at 8:21 am
I tried to iterate a couple different ways, column object was only one that worked. Weird. As far as the GPF, you're running VB6 SP5? I can see where going...
April 9, 2003 at 5:13 am
Its still a collection of column objects. Code below works. Dont know if it will help you. Tried using the "2" objects to see if that makes a difference, if...
April 8, 2003 at 7:20 pm
Image generally used. MS has a utility called BII, part of the resource kit, that you can use for bulk load. Most data access with blobs(image)is done via ADO and...
April 8, 2003 at 5:49 pm
I just put compiled and ran your code, no GPF. I'll have to work on your other idea more.
Dim oserver As SQLDMO.SQLServer
'create standard server object first
Set oserver = New SQLDMO.SQLServer
With...
April 8, 2003 at 4:17 pm
Not a botttom line answer, but the standard MS line is that unless you provide the order by, you're not guaranteed any particular sort. Group by's used to return sorted...
April 8, 2003 at 12:53 pm
Not a good plan for a production box, normally while they step through they are in a transaction, could cause a lot of blocking.
Andy
April 8, 2003 at 9:32 am
Viewing 15 posts - 2,296 through 2,310 (of 6,216 total)