Recent content by finsys

Stanley, did you ever sort this? A general suggestion for you - you should change the ENTRY_DATE field type in SQL from DATETIME2(7) to DATETIME2(0). There is no point storing 7 decimal places of milliseconds that will always be empty and VFP can never use. It will also reduce storage...

As this is a connection to SQL2008, then rather than setting the driver as {SQL Server}, you should use {SQL Server Native Client 10.0}. {SQL Server} is for SQL2000 and doesn't support a lot of the new data types in SQL2008 e.g. DATETIME2 will come through as a character field when using remote...

The timer components showing in the toolbox (both in the Component and All Windows Forms sections) are BOTH windows forms timers. This forms timer component doesn't work in a service, you need the system timer as Chip mentioned. You can add this to your tool box by right clicking on the toolbox...

As well as setting the border style, I also set the max/min height and width to the same value as the forms actual height and width. This stops people double clicking on the title bar and maximising the form.

Mike wrote: "Maybe it's my imagination, but it seems a bit faster now as well" Haven't popped in for a while, so this is the first time I've seent he revamped site. I definately noticed a huge speed increase over the old version. Superb work guys! :)

Sorry, spotted some unclear text.... When I say "silly numbers", I am expecting 0x00000001 as the DWORD value, but I'm getting a huge number like 0x5f000031. Even wirting out 0 comes back as 0x5f470030 instead of 0x00000000.

I'm currently adapating one of our programs so that rather than printing to hardcopy, some reports will be saved as PDF documents. I have succesfully used RegSetValueEx in ADVAPI32.DLL to write out the string value (type REG_SZ in the registry) of the document name prior to PDF'ing, but I also...

Hi chaps, This isn't in a program! I'm browsing the remote view after clicking on the Browse button in the project manager! No code or events running. In case you're wondering why I'd be mad/stupid enought to do that, it was so I could run some code against it once all the records had been...

Yes, you read it right. If you have a remote view to SQL server and it's taking a long time to retrieve the records, you can speed it up with your mouse!! I noticed this whilst retriving 1m records in a view (VFP7 and SQL2k). It was pulling back 100 records every 0.5s (the speed the status bar...

Does it work ok on older versions of Office? I use the same line of code as part of automated mailmerges in one of my apps. When I moved it onto an XP machine from Win98 (both using Office 97) I had to change bits of the Word automation due to subtle changes that M$ had introduced. unfortunately...

Been doing some further research on this. It seems one term for this is an Exit Code, I've also found it referenced as ErrorLevel as you said Mike. "Each process in DOS / Windows returns an integer ExitCode to notify its parent process of the success / failure / other status upon termination...

I knew it could be done! [2thumbsup] It's a simple API call... DECLARE ExitProcess in Win32API ; INTEGER ExitCode IF MESSAGEBOX("Run successfully?",1)=1 WAIT WINDOW "Success" TIMEOUT 2 = ExitProcess (1) RETURN ELSE WAIT WINDOW "Failed" TIMEOUT 2 = ExitProcess (0) RETURN ENDIF DTS...

I don't see how any exe can not be made to return a value! DTS provides for checking return codes from a win32 app to allow a descision making mechanism for the DTS package if a process fails to execute properly. This to me says that somewhere somehow you can get an exe to return a value. I...

Mike, yes it's an exe. We already have a gaggle of batch processing VFP programs that are controlled by a VFP scheduler that we wrote. We're having some problems with it due to network issues, so want to move as much as we could to the server using DTS. Is there no way to make a VFP exe return...

Hi Brian, yes DTS as in SQL Server Data Transformation Services. The code is pretty much as described above! if messagebox("SUCCESS?",1)=1 return 1 else return 0 endif Either DTS is not picking up the return value from VFP, or VFP is not returning it properly in the first place. I...