Search results for query: *

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.

I'm having trouble compiling my application as an .exe. Everytime i try and compile it, it gives back a "Compile error in file C:\myapp\myapp.app" even though i do specify a windows exe. Also note: When i compile in vfp 6.0 SP5, it works fine, but doesn't compile properly in vfp 7.0...

Would anyone happen to know how to create a recordset based on a range of records that I would define. This range would be based on the record number. Example: Say i have a table of 15,000 Records: we'll my recordsets would consist of: #1: 1 - 5,000 Records #2: 5,001 - 10,000 Records #3...

What exactly do you mean by manipulate the PDFs? If you mean zooming in and out and changing pages within a pdf, thats possible, but to actually modify the pdfs from outside of Adobe Acrobat using their activex is not possible. Adobe has never wanted to give public/easy access to their pdf SDK.

I've found the Adobe PDF ActiveX to be pretty limited. In your situation, since you want to view it from within vfp. Try using the Internet Explorer Control and viewing the PDF through IE (which in turn will display the PDF). This may give you better control over it. Stephen

How can i get a memo field grow and shrink when placed on a report? Doesn't seem possible within foxpro's report writer? Any suggestions or workarounds would be appreciated Thanks, Stephen