Search results for query: *

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...

Hi there, We are in teh process of toying with DTS to control a schedule of VFP programs. We need to know if the VFP app has run succesfully or not (as opposed to crashing) so we built a small test app that you can click OK or Cancel on a messagebox and the app closes with a RETURN 1 or RETURN...

Mike, it does happen in Win98!! There is a Win98 PC 2 rows away from me that does the very same thing. It was the only PC in our Dept that did it (until mine started), but it's not my PC and generally not used often so no one has bothered to investigate. Now the good news is I've fixed it...

Just popped back to update my answer and Chris has beaten me to it. The object reference method will work better. If your form is already loaded and you are calling a requery on it from the toolbar, the activate event on the form won't trigger. My sample will only work if you load the form after...

In the form's activate event: thisform.command1.setfocus Where command1 is the button you want to receive the focus.

Are you using VFP7? If so have you applied SP1? I found a bug in VFP7 whereby if you opened a table using an alias e.g. USE mytable ALIAS mytable1 IN 0 VFP7 wouldn't recognise the alias name properly. SP1 fixed this.