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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JICGreg

  1. JICGreg

    update sql table with foxpro with remote view, connectivtiy error

    Thank you all for your responses. I will go through the sql table and check the data structure as well as my foxpro data to try and locate the problem data. I'll post any additional questions. Greg
  2. JICGreg

    update sql table with foxpro with remote view, connectivtiy error

    I often update sql tables from foxpro using a remote view. The sql programmer takes over after that -- so fox is just used to get data into sql. I'm trying to do this with a new sql table and I am running into problems. I used the foxpro upsizing wizard to get the table created in sql. I...
  3. JICGreg

    Import Txt Data

    I'm importing from a txt file that is a data export from another program. It is a list of mutual funds. Three of the columns are Return3Year, Return5year, and Return10Year. 20,000 plus records. Now, if there is no data for a particular column the default export is to put a single hyphen in...
  4. JICGreg

    Using SqlExec To Update Sql Table

    Olaf: Your first interpretation was correct. I have data in foxpro, sql server is my backend database, and I'm trying to update sql server with the new data stored in foxpro. Thank you all for your response. Since I really did not want to follow Mike's suggestion (due to the number of...
  5. JICGreg

    Using SqlExec To Update Sql Table

    Historically, I have used tableupdate() to update foxpro data to sql. However, I am running up against the 2gb limit and from a prior post it was suggested to use sqlexec() instead of table update. Unfortunately, I have not found anything right on point and being new to this I was hoping for...
  6. JICGreg

    Sql Statement In Foxpro

    Thank you for your response: Dan: You are correct that is not what I intended. But at jrbbldr's recommendation, I added the code to test whether the connection and execution was successful. It was, so now I know I have a "good" string. I issued the brows command after sqlexec() and voila...
  7. JICGreg

    Sql Statement In Foxpro

    I have had foxpro and sql work together for a while now, but only in the very,very simplest of terms. I basically delete data in a sql table and add it back in using a foxpro view. I now have to query the sql table. I am trying to do this within a foxpro program. So here is what I have...
  8. JICGreg

    Task Scheduler Server 2008 R2 And Foxpro

    I actually have foxpro installed on the server
  9. JICGreg

    Task Scheduler Server 2008 R2 And Foxpro

    I recently migrated my foxpro scheduled tasks from a server 2003 box to a server 2008 r2 box. I have not been able to get the foxpro-related scheduled tasks to execute on the new box at all (although non-foxpro related tasks execute correctly). I duplicated the scheduled task structure that I...
  10. JICGreg

    Foxpro Startup

    Mike: That was it! _screen.WindowState = 2 restored everything. Once again, thank you very much for your assistance and persistence with this issue. Greg
  11. JICGreg

    Foxpro Startup

    Mike: I have to leave for a business trip, but I will vpn and try your suggestions. I will get to this as quickly as possible. Thanks for your help. Greg
  12. JICGreg

    Foxpro Startup

    Mike: It is your first description, the command box floating on top of my windows desktop with nothing else visible. If I type in modify project <<projectname>>, I believe the command executes, just because it takes a little while for the cursor to come back -- although I cannot see anything...
  13. JICGreg

    Foxpro Startup

    First, thank you all for your suggestions. Unfortunately, none of them worked. So, I decided to simply unintall and then re-install the program. To my surprise, after the re-installation, the exact same problem kept occurring. I did not reboot my machine after uninstalling. Any other...
  14. JICGreg

    Foxpro Startup

    Thanks for the response. I was able to type set sysmenu on in the command line, but nothing happened -- even after restarting foxpro.
  15. JICGreg

    Foxpro Startup

    I have done something but I do not know what and hopefully someone can help me. When I start foxpro the only thing that opens is my command window. No "regular" window (that includes the file/edit/view) menue and no task pane manager. How can I get these back. Thanks for any input Greg
See more

Part and Inventory Search

Back
Top