[archive] AcuODBC question

[Migrated content. Thread originally posted on 08 May 2008]

Hi!
I am very new with AcuODBC...
I successfully linked a Vision table through AcuODBC to MS Access.
My problem is that I cannot modify any data in primary-key fiields.
I can only change data in other columns.

Is this how it works or am I doing somthing wrong?

Regards
Th.

Consider what you would need to do if you were trying to change data -primary key data through a COBOL program. You would need to save whatever data in a temporary field - delete the entire record - which eliminates the primary key and then write a new record with either the same primary key or a new one. The same type of action would be needed through ODBC in that you need to delete the entire record or row if that promary key is invalid or needs to be changed. You need to be very prudent when do this as other programs (or queries of the data) may rely on the data that is in the primary key.

[Migrated content. Thread originally posted on 08 May 2008]

Hi!
I am very new with AcuODBC...
I successfully linked a Vision table through AcuODBC to MS Access.
My problem is that I cannot modify any data in primary-key fiields.
I can only change data in other columns.

Is this how it works or am I doing somthing wrong?

Regards
Th.

That makes sense...

Thank you

[Migrated content. Thread originally posted on 08 May 2008]

Hi!
I am very new with AcuODBC...
I successfully linked a Vision table through AcuODBC to MS Access.
My problem is that I cannot modify any data in primary-key fiields.
I can only change data in other columns.

Is this how it works or am I doing somthing wrong?

Regards
Th.

That makes sense...

Thank you