writing to FMP from VB

[daverk]

I have managed to connect to an FMP db from a VB 5.0 program using ODBC. I can create a recordset and read the data. The question now is how do I write to it. I have the options set in the program to open the recordset to allow read/write but that apparently doesn't matter since as soon as I issue an Edit command I get an error indicating that the recordset is read only. What am I missing? Is there some setting in FMP that might be wrong?

As always all help will be appreciated.

Dave

[email protected]

[amccallum]

Hi Dave

Check out www.xsf.com . There ia a fair bit about connecting FMP to Microsoft applications and it has some VB code samples too.

quote:

---

Originally posted by daverk:

I have managed to connect to an FMP db from a VB 5.0 program using ODBC. I can create a recordset and read the data. The question now is how do I write to it. I have the options set in the program to open the recordset to allow read/write but that apparently doesn't matter since as soon as I issue an Edit command I get an error indicating that the recordset is read only. What am I missing? Is there some setting in FMP that might be wrong?

As always all help will be appreciated.

Dave

[email protected]

---

------------------

Andrew McCallum

McCALLUM CONSULTING P/L

Sydney, Australia

61 2 9585 8775

61 407 482 609

[email protected]

[daverk]

I've been there and downloaded their manuscript on FMP, ODBC and MS Office. It was very helpful but unfortunately they are only reading from the FMP db. In the mean time I have discovered that I can create new records using SQL. But I still can't do an update on an existing record whether I use SQL or try to write using a recordset.

This really has me stumped at this point and unless there is a way to do it the whole project is shot. Any help will be greatly appreciated.

[kdyer]

<quote>

But I still can't do an update on an existing record whether I use SQL or try to write using a recordset.

</quote>

I'm using Java and jdbc-odbc driver to create, update, read and delete (CRUD) fmp records. I've notice that some fields update and some don't. No errors reported. I'm not sure what causes this.

[This message has been edited by kdyer (edited February 28, 2001).]

[This message has been edited by kdyer (edited February 28, 2001).]

[This message has been edited by kdyer (edited February 28, 2001).]

[This message has been edited by kdyer (edited February 28, 2001).]