Recent content by JNeave

Hi, I have a Kodak CX4210 camera. Connecting it to XP, it uses the XP Windows Image Aquisition 2 Drivers to connect. But the camera does not support the command DeleteAllImages. And this appears to be the only way to delete images programatically from WIA Automation in VB6. Does anybody know...

Hi, I'm trying to find out how to monitor the progress of a long (several hours at worst) INSERT query. The (Test) Query INSERT INTO TEST (bob) SELECT CaseID FROM Cases The problem Command.Execute( , , adAyncExcexute) The VB thread continues fine, but the FetchProgress event does not fire...

Sounds like an FAQ to me... Thankfully our JET days are long gone. Just not quite long enough yet. Ta, J.

Yes, that SP would do it and it contains it's own proof that it will work as well. This will be usefull for critical situations. However for more mundane situations, to prevent the creating of many SPs we have this working situation. We think. I've only tried it once. A Resordset is opened as...

Hi, We develop multi user data access systems based on VB6, ADO(2.6), OLE DB provider for SQL Server and SQL Server 2000 Here is the situation. A recordset holding a single record is opened client side and the connection to the database is tempClosed, no locks are held. The operator then...

Yep, we solved it with that too after much trial & error coding [curse][curse][curse][curse][curse] Ta, Jim.

Well, according to the true Execution plan in Query analyzer, the udf generated table is used on the bottom half of a nested loop join, even though that is a fairly bad decision. If I could get a clustered index on the udf table or temp table, it would use one of those good joins, not hash, not...

Temporary tables which can't be used in UDFs right? I tried that first and it complained. :( Ta, Jim.

I can create PKs and Unique Clustered and Non-clustered indexes on multi line udf's But I'd like to create a non-unique clustered index for the table that is returned as it is then joined to several other tables. I can't do: CREATE CLUSTERED INDEX ON tblOut (ColumnName) it throw invalid use...

What do you need all 2100 parameters for? Creating a where clause? Tell us more about the sproc and we might think of a better way of doing this. Jim.

Hi, We screwed up (actually Alex did) Our All-In-One Wonder Database building/upgrading tool has gone a bit rogue and has created every NVARCHAR column with the DEFAULT contraint of (N'#BLANK#') due to a bug. But nobody noticed and one of the clients is live ¬¬; Does anybody know where that...

That's with any printer driver we use, although they are both HP Laserjets... Yes, generally we find that fonts that are cut off when viewing the report at <200% print out fine. This has always been our rule of thumb and I design the reports at 200%. But in the last report I designed some of...

Hurray! Thanks! I shall read these forthwith. :) You do all your queries in QA? Don't you find it time consumig typing table and field names? Not to mention remembering them all, I could never do that. &quot;Statistics IO and Time&quot; I don;t understand what you meant by that though. Just...

Yeah, tell me about it... ¬¬ But we've beaten 7 into something pretty damn decent now that we've lobotomised most of it's 'features' I was hoping not that support has stopped, somebody had written a definitive DLL/EXE list for crystal7.... I've read a guide about the definitions of the DLLs...

Ah, but that stil doesn't get round the problem of the text not scaling correctly with the Zoom factor, does it? As I said, the report looks fine at 200% and awful at 100% and somwhere in the middle when printing. Is getting that right all just trial and error? Or is there a certain zoom I...