Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. finsys

    Comparing VFP9 datetime to SQL2008r2 datetime

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

    Cannot Connect to SQL Server 2008 Express FromVFP 9 Program (exe)

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

    Trying to add a timer component/control to a Windows Service project

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

    How can I make the form's size unchangeable

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

    New look website

    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! :)
  6. finsys

    Problem using RegSetValueEx writing REG_DWORD's

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

    Problem using RegSetValueEx writing REG_DWORD's

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

    Speed up SQL queries with your mouse!

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

    Speed up SQL queries with your mouse!

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

    CreateObject Problem (Word XP)

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

    Integrating VFP and DTS

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

    Integrating VFP and DTS

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

    Integrating VFP and 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...
  14. finsys

    Integrating VFP and DTS

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

    Integrating VFP and DTS

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

    Integrating VFP and DTS

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

    Simple problem, but annoying....

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

    toolbars and forms... active control

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

    toolbars and forms... active control

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

    Database containers, tables, and appending to them

    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.

Part and Inventory Search

Back
Top