Oracle - Can Insert but can't change data 1

[emaduddeen]

Hi Everyone,

I set up a simple app with 1 browse and 1 update procedure. The data is on an Oracle database.

The browse originally had the fuzzy search control template set up. That did not work on the Oracle data. It gave us an error 35 so I removed it.

We discovered that we could lookup and insert data into the Oracle table but couldn't change the data after it was inserted. It gave us an error 33.

There is no custom code in this app.

Why can't Clarion handle changing the Oracle data?

I would use the topspeed database which works but have no choice since the place I work is an Oracle software shop and I am trying to convince them to use Clarion as the front end, not that ugly Oracle Forms product.

Thanks.

Truly,
Emad

 

[ShankarJ]

Hi Emad,

Run Trace and find out the statements being sent to the Oracle backend. It will help identify the problem. This normally occurs if the primary key is not displayed on the form and hence does not get generated in the UPDATE statement.

Regards

 

[ShankarJ]

Hi Emad,

Run Trace and find out the statements being sent to the Oracle backend. It will help identify the problem. This normally occurs if the primary key is not displayed on the form and hence does not get generated in the UPDATE statement.

Regards

 

[emaduddeen]

Hi,

I did not create a primary key for the table in oracle. If it is a requirement for clarion to have one then please let me know and I will create it.

Also I am getting ownership of the v6.3 oracle driver. Do you know if this will work with Clarion7?

Truly,
Emad

 

[ShankarJ]

Hi Emad,

ALL SQL/ODBC drivers in Clarion work perfectly ONLY when they is a PRIMARY key. With ISAM drivers, table scans are possible but with SQL/ODBC the request is sent to the backend database and since Clarion uses cursors, things do not work properly without a Primary key for every table.

Regards

 

[emaduddeen]

Hi.

Thanks for the reply.

I will re-try it after making a key on the Oracle table in Oracle.

Wasalam,
Emad