Search results for query: *

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

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

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

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

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

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

...So here is what I have: store "returns" to sql_source_table store "ABCD" to ticker lnconn = "sqlconnect("JICData",.T.) STORE "SELECT FROM * " + sql_source_table + " where ticker = " + "'" + ticker + "'" TO table_SELECT sqlexec(lnconn,table_select) What I think I'm sending to sql is...

I actually have foxpro installed on the server

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

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

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

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

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

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

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

I need to pull some data from sql and place the results into Word. I believe Word has the ability to execute custom database queries. Never even come close to attempting this and do not even know if it is possible. My research has led me to the {Database} field code which looks promising...

I have been using remote view to update data from foxpro to sql. My sql database has grown large (just under 2gb) and nearly 700,000 records. I'm now having trouble updating the sql program with the process I have been using for over six months. I'm wondering if there could be some sort of...

The create database command does not automatically add a database to a project. The only help I have been able to find says talks about adding the database manually to the project. Can the database be added via code to the project? How? Thanks

Thank you for your counsel. Your suggestions fixed the problem.

I'm receiving an error message that my dbc is too large. The help feature says it cannot be over 2gb, and according to windows explorer it is (explorer says the file is 2.097gb). This is part of a project that is run on a monthly basis and has been running fine up until this month. I have...