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!

  • Congratulations TouchToneTommy 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: *

  • Users: wsjames
  • Content: Threads
  • Order by date
  1. wsjames

    Accessing VFP 9.0 Flat Tables

    I have a VFP 9.0 app using flat tables. Previous versions of MS SQL Server were able to accessing (open/query) the VFP tables. Are there any known reasons SQL Server 2016 (SP2) cannot access the same flat tables? I'm told SQL Server 2016 (SP2) does not offer VFP ODBC driver???
  2. wsjames

    Insert - SQL Command

    Made a modification to a routine I use to transfer records from one table ("statdtpt") to another ("arcdtpt"). I then, delete redundant records from "statdtpt". I recently opted to use the code below to rid the use of "SCATTER" - which by the way worked fine. It would be simple enough to go...
  3. wsjames

    VFP Client (file sharing) Limitation?

    Our [VFP 9.0 ] application runs within a company that operates 24/7. During normal work hours, well over 100 users interface with our app. The number of users decline during weekend and night hours; management/engineering/admin staff work normal hours. The application’s responsiveness comes...
  4. wsjames

    Charting with SimpleChart

    Is it posible to have a bar and line plot within the same chart?
  5. wsjames

    OLEdrop Grid w/ComboBox

    [Using VFP9] Form deactivates (will not re-activate) when clicking on combobox item, and then drag/drop from listbox to grid. For testing purposes, I created a simple form. Adding a listbox, grid, and combo box. After populating the controls with differing tables, I am able to drag/drop...
  6. wsjames

    ShortCut (menu) Timeout

    Is it possible [in VFP9] to progamatically timeout a shortcut menu? I would like to timeout [close] the shortcut if activated, but not used/closed within xSeconds.
  7. wsjames

    Win 16 subsystem has insufficient resources to continue running.

    Customer is running FP2.6 app. Was running fine till roughly 07-15-2009. Where upon they began to experience the error, 'Win 16 subsystem has insufficient resources to continue running. Click OK to close your applications and restart your machine.' Customer running XP, plenty of memory on...
  8. wsjames

    General Field NOMODIFY Problem

    I am using VFP9 and would like to Scroll or Page through multiple pages [combination of pictures and text] of a General field. Is it possible to do this while also preventing modification(s) to the field? I'd like the customer to scroll through a readonly General field.
  9. wsjames

    Auto Form Release

    I am using VFP9.0 and attempting to automatically release a Form when there is no user input (keyboard or mouse) over a period of time. The form(s) have various objects (listboxes, textfields, etc). - I've placed a Timer on the Form and enabled the form's KeyPreview property. -...
  10. wsjames

    Is MSWord Document Open

    I have an application that launches an MSWord.doc. Pending the user, the document(s) are opened readonly or read/write. Is it possible [within VFP 9.0] to determine if the MSWord.doc is already opened by another user. I don't believe the [GetFileAttribute] function offers this option. [My...
  11. wsjames

    Grabbing Date/Time from Remote Data Source

    Is it possible via an ODBC connection to grab the current date/time from the remote data source? We are using a VFP 9.0 app and would like to validate date/time synchronization.
  12. wsjames

    MS Word 2003 AutoText (Auto Update)

    We are attempting to [upon opening MS Word] automatically update/refresh an AutoText field [FileName]. The file name of the document changes to reflect the latest revision number. We would like to display [FileName] via an AutoText field, but have been unsucessful at automatically...
  13. wsjames

    To SP2 or not to SP2

    I just upgraded from VFP 6 to 9. I've been reading the posts regarding SP1 and SP2. Based on the posts, I am unable to determine which service pack to install. Please advise.
  14. wsjames

    Modify/Append General - Opening Word Read Only

    Is it possible to open a word.doc readonly using modify general. Thus far, in my attempts the NOMODIFY/NOEDIT option doesn't seem to work. I opted to use the Append/Modify General approach due to my inability to launch (within my app) Word from various workstations. Seems Foxpro 2.6 needs to...
  15. wsjames

    SQLEXEC(): Inserting Multiple Records From an External Table

    I have multiple records (from an external query) that I would like insert into a database using the SQLEXEC() function. I have successfully connected to a server and am able to insert single records without a problem. But, have not figured out how to pass-through and ultimately insert multiple...
  16. wsjames

    Label Designer - Stretch with Overflow option

    I am attempting to create a label within the VFP 6.0 label designer module. I would like to have a field wrap "stretch with overflow". However, the "Stretch..." option is disabled. Is this option not available within the Label Designer?
  17. wsjames

    Label Designer / "Stretch with overflow" Option

    I am attempting to create a label within the VFP 6.0 lable designer module. I would like to have a field wrap "stretch with overflow". However, the "Stretch..." option is disabled. Is this option not available within the Label Designer?
  18. wsjames

    Unable to Exit "RUN cmd.exe /C time /t"

    In an attempt to grab DOS time, I've used the "Run cmd.ext /C /t" command. Unfortunately, I have been unable to programmatically exit the (DOS) window it creates. The command apppears to interupt the FP2.6 interface until the DOS window is closed (manually).
  19. wsjames

    Microsoft's DST OS Patch

    Will Microsoft's daylight savings OS patch have any effect or impact on FP2.6 or it's applications - assuming the application resides in an area affected by DST?
  20. wsjames

    Export Memo Field to Excel

    I have a table with a memo field. I would like to convert the table to an XLS format. When using the 'Export To' or 'Copy To' commands, all fields except the memo field is converted. Upon opening the new table from within Excel, I see that the memo field is not included. Is there a way to...

Part and Inventory Search

Back
Top