Recent content by campagnolo1

Greetings everyone, I'm stuck on a project that has me turning in circles and I need some help. I have created a small windows form project in VS2010 using C#. The form has a datagrid which is tied to a VFP table. The table has no primary key and I can't add one (the table was given to me and I...

Craig, thank you for your reply. I actually don't need the SQL data. All the VFP data gets used and then put into a SQL table. So all that would need to happen is to get the VFP data, clear the SQL table and put the VFP data into the SQL table. Since I'm still fairly new to all this, do you...

Greetings, I've been working on a project for a while where I call an exe from a code-behind in a web page. This works all fine and dandy, but I would like to try and put the code directly into the code-behind page, not having to rely on the exe and VFP. Following is the code from the VFP exe...

Olaf, great suggestions! Tried the following: protected void Page_Init(object sender, EventArgs e) { OleDbConnection oConn = new OleDbConnection("provider=VFPOLEDB.1; data source='F:\\TIW\\KOKAC'"); oConn.Open(); OleDbCommand oCom = new...

Olaf, I actually made a mistake yesterday by forgetting to recompile the VFP exe. So as I was testing your code manually it worked, but when I ran the web project it was still running the old code when calling the exe. Close All Set Exclusive Off Use F:\TIW\KOKAC\immaster In 0 Set TABLEVALIDATE...

Olaf, sorry it has taken me a while to get back to you. I had some work that needed to get done urgently and didn't get a chance to look at your post until today. So I set up my script the way you suggested and added the ID field to the SQL table. But once I ran the script and then the report I...

Okay guys, I think I'm going to have to let the VFP approach settle in a little over the weekend, my head is starting to spin! Now the SQL code works nicely and is quite fast, but I discovered an issue that I wanted to bring to your attention to see if you have an idea what could be done...

Mike, how would I go about just deleting the records and appending? I appreciate your help and I'm trying to understand both ways, yours and Olaf's. I think ultimately I'm hoping to go with the SQL solution, but I also would like to get the VFP solution just so I have options. And I can't say...

Mike and Olaf, great explanations and very useful information! I never posted the full code, otherwise you would have seen that I'm opening all needed tables non-exclusive: Close All Set Exclusive Off Use F:\TIW\KOKAC\immaster In 0 Set TABLEVALIDATE To 0 Use F:\TIW\KOKAC\imstock In 0 Set...

So, I've been looking at the tutorial for configuring the OLE DB datasource, unfortunately without success. I set up two datasources, one OLE DB and one ODBC, and configured the report to use them (one at a time of course). Both times I ran the report and then tried to run the VFP exe, both...

Mike, is this what you are talking about? How to configure an OLE DB driver Chris

Mike, We would like to move away from the xBase connector since we are trying to use DataLink Viewer 2008 and Crystal Reports Viewer 2008 which gives you a Database Connection Error when using xBase. The way you have described it in your post is actually the way we've had it for a few years...

Good morning gentlemen, Mike, currently everything (accounting and manufacturing software) is using FoxPro dbf free table directories. We are creating custom tables for a few of our Crystal reports that would otherwise either not be able to run or would take forever to run. I'm now in the...

Olaf, thanks for the clarification on the BULK INSERT. I indeed go through multiple cursors because of different joins. If you want I can post the full code for you and maybe (most certainly [smile]) it could be improved. I tried your tableupdate() function but I'm getting a "Too many...

Mike, you mentioned I have read about this but I can't find where or how to change the properties of the OLE DB driver. Where would that be? Olaf, working on your suggestions right now. Chris