Cannot write to table. URGENT HELP REQUIRED.

[Joe Boyle]

You have to have a unique key/index for updates with each of RDBs sqlserver
sqlanywhere, and DB2. So either add an index or, use a SQL call with insert
or update.

Regards, Joe.


-----Original Message-----
From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com
[mailto:powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com] On Behalf Of
Syed Shahul Hameed Mustaffa
Sent: 09 July 2005 09:57
To: powerh-l at lists.sowder.com
Subject: Cannot write to table. URGENT HELP REQUIRED.

Hello gurus,

I am using AXIANT 4GL with SQL Server 2000 backend.
I am migrating the code from MPEIX to the above environment.

In one screen, when I try to update, the update fails with no clear message.
It just says 'File cannot be updated' when it tries to write to a
table without an unique index.

It is not issuing any sql statements to sql server (i watched from sql
profiler).

What could be the possible reasons?

Regards,
SYED

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request at lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.