Updating data in 4D database

Does anyone know how to update data in 4D? I am having trouble with this. I
have the connection working and selecting the records works also. When I
want to update or insert is where I am having the problem. I am getting this
error.....

Run-time error '-2147217900 (80040e14)':

[Simba][Simba ODBC Driver]Update Certification set certification.<< ???>>Key
=......

I know key is a reserve word. I put it in [] and still gave me the same
error. Can someone please help?

--
Message posted via http://www.accessmonster.com

Re: Updating data in 4D database

This site is for developing databases in MS Access! You need to find a site
dedicated to 4D database development!

dst393 wrote:
>Does anyone know how to update data in 4D? I am having trouble with this. I
>have the connection working and selecting the records works also. When I
>want to update or insert is where I am having the problem. I am getting this
>error.....
>
>Run-time error '-2147217900 (80040e14)':
>
>[Simba][Simba ODBC Driver]Update Certification set certification.<< ???>>Key
>=......
>
>I know key is a reserve word. I put it in [] and still gave me the same
>error. Can someone please help?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com

Re: Updating data in 4D database

I was using access to retrieve records from the 4D database. It doesn't
matter because I solved that problem.

Linq Adams wrote:
>This site is for developing databases in MS Access! You need to find a site
>dedicated to 4D database development!
>
>>Does anyone know how to update data in 4D? I am having trouble with this. I
>>have the connection working and selecting the records works also. When I
>[quoted text clipped - 8 lines]
>>I know key is a reserve word. I put it in [] and still gave me the same
>>error. Can someone please help?
>

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-ac cess/200710/1