Cannot write to table. URGENT HELP REQUIRED.

[Joe Boyle]

Example of embedded Sql approach is below, where t_hm and t_order are
temporary items,

let t_hm = truncate (concat_log ) + "add date"	 &
+ ' JOTIME ' + d_hm[1:8]

sql  in mydb transaction update &
update concat_row 	                &
set concat_log = : t_hm where order_no = :t_order


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
Joe Boyle
Sent: 09 July 2005 13:49
To: 'Syed Shahul Hameed Mustaffa'; powerh-l at lists.sowder.com
Subject: RE: Cannot write to table. URGENT HELP REQUIRED.

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.

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.