Recent content by kindred

It's odd that you can't just call the function for a scalor return value. I would of thought the connection-string in Ole DB (or ODBC) would dictate the user for the calling function.

Is there a way to call a function without prefixing it with the database and/or owner name? Example... fn_myfunction under the Sample Database Currently I call it as followed... Update mytable Set myfield = Sample.dbo.fn_myfunction(123) I'd like to call it like this... Update mytable Set...

Except... I can accept the 48 seconds in query analyzer, but why does setting the CommandTimeout property to 10 minutes have no effect (I know it doesn't take this long)?

I keep getting a "Timeout expired" error when trying to run an update on 350,000 records using ADO.Net. Below is the code I'm using.... Dim ConnectionString As String ConnectionString = "Data Source=""sac-sql-001"";Initial Catalog=""Main"";Persist Security Info=""False"";Workstation...

Hi, There's a very inexpensive reporting tool that will view the data and also allow you to export to pdf. The costs for either the std or professional version are very low. The product is ActiveReports by DataDynamics. http://www.datadynamics.com Stephen

Another option is to loop through APrinters() array to see if it exists. Stephen

You need to start reading up on Office and Excel Automation. Also check out the help files for VBA under Excel. Stephen

Also in my opinion... 1. Yes i believe MS will support it long-term, during one stage in the beta phase of Visual Studio .Net you could write foxpro code (non-visual) and step through any of the vs langauages all in one debugger. Which also allowed you to directly imbed foxpro code in another...

It isnt possible with direct foxpro commands, like the one you mentioned, but you may be able to by creating a foxpro report and saving(exporting?) it to excel, it might do what your aksing. The other alternative would be to access Excel via ActiveX and create the excel sheet, populate it and...

I understand this is sort of off topic, but I'm having a difficult time getting the answer to this. Normally under VB 6 i would use Unload Me to unload a form or a class within itsself. Unfortunately I can't do this any longer under VB 6. Would anyone happen to know the VB .Net equiv. of...

Sorry for the repost, but i really need an answer to this. Under VB .Net how do I unload a class within itsself. For example: Previously in VB6: It was simple as Unload Me and it would destroy the class itsself. Any thoughts on this would be greatly appreciated. Thanks, Stephen

Another alternative is to create a text file called config.fpw, include the line SCREEN = OFF and add this in your project. When it's compiled, the foxpro screen should never appear as well. The advantage to this is that you wont need to include additional parameters in the shortcut and the...

Under VB .Net how do I unload a class within itsself. For example: Previously in VB6: It was simple as Unload Me and it would destroy the class itsself. Any thoughts on this would be greatly appreciated. Thanks, Stephen

Would any of you happen to know of a decent PGP ActiveX? Thanks, Stephen

Oops, i should have looked a little closer. I removed the offending .prg file and it compiled fine. Thanks.