Recent content by davewelsh

I saw in the FAQ that you can use something like exec sp_spaceused <tablename> But I don't know how to use that with ASP/ADO.

My hosting company has a quota in place for my MS SQL server (SQL Server 2000 I think). I wanted to write a script in ASP that would determine how much space is currently being used in my database so I could tell if I need to buy more storage or clear some rows. Are there any SQL commands that...

The best I could do so far was to handle the updating event of my QueryDataset and throw an exception if I didn't want the post to go through. I'm not sure if there is a better way to do it though. The reason I want to do this is because of the way I handle the navigation with the...

I have a QueryDataset that needs to be validated before it's committed to the database. The province field must match up with the country field. I started using a QueryResolver and it worked great. I could call resolverResponse.skip() to cancel the commit and prompt the user for changes. But...

I guess maybe what I'm looking for is a way to diplay an ActiveX control on my report, such as the Adobe Illustrator one.

Hi Ramani. It's not a problem with resizing images. I can do that all I want. The original graphic is in Illustrator. I opened the .ai file in Photoshop as a 600 dpi images (looks nice) and saved it as a bmp. When I added it to my Foxpro report, it took up the whole page. So then I opened...

I want to put our company's logo on some reports, but it's not looking too good. The logo was made in Illustrator so it's a vector image (should be great for scaling). In order to include it on the reports, I converted it to a bitmap at 600 dpi (the resolution of our printer). Unfortunately...

Silly me. I'll just Hide() the main form.

Thanks. That gives me a place to start. The only thing now, is that the first form (the one I don't want anyone to see in the taskbar, alt-tab menu, etc.) has a border around it. The size is still 0, 0, but it has a blue border with a small title bar. I set ControlBox = False and that shrunk it...

I don't want my main form to show in the taskbar. I want to run a NotifyIcon off of it and then use a second form for my main user interaction. When the form is set to ShowInTaskbar = False, you get a different icon in the &quot;alt-tab menu (what's this called?)&quot;. I wanted my own icon to...

Thanks everyone. I got it to work just before leaving work yesterday. I didn't do the RegSvcs, but I did RegAsm. Then in FoxPro I was getting the error that it couldn't find the dll (error 0x801-somthing) even though I had the dll in the GAC. After rebooting it worked fine. Although, it might...

Ok... After rebooting it all works well.

This is supposed to mean that the COM client can't find the DLL. I have both put the assembly in the global assembly cache AND copied the DLL to the client's directory, but I still get the error.

Thanks. I read a few pages on CCW AND RCW. My aaembly is now in the GAC and it's registered for COM. Now my VFP 6.0 app recognizes the DLL but when I call CreateObject I get OLE error code 0x80131522: Unknown COM status code. To simplify things, my .Net code is now just this...

I want to create a DLL in VB .Net and use it in a COM program (VFP 6.0, actually). I don't really know where to start. I've read through the MSDN library on the subject but, I can't figure it out. Can someone give an example of a VB.Net or C# DLL that can be used by COM? Also what special steps...