Cannot write to table. URGENT HELP REQUIRED.

[Joe Boyle]

Could it be that the screen which did not error was actually adding new rows
to the database rather than updating existing rows ?

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 14:58
To: Joe Boyle
Cc: powerh-l at lists.sowder.com
Subject: Re: Cannot write to table. URGENT HELP REQUIRED.

Dear Joe,

Thanks again and it is great to hear from you.

Are you sure about mandatory unique indexes?
I'm asking this question just because I could update the table using a
screen that I created with Axiant screen builder wizard.

According to your statement, the update should have failed. Am I correct?

In PH(MPEIX), the same code writes to a table even without unique index.

Regards,
SYED.

On 7/9/05, Joe Boyle <atla38 at dsl.pipex.com> wrote:
> 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 &lt;password&gt;" 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 &lt;password&gt;" 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 &lt;password&gt;" 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.