Cannot write to table. URGENT HELP REQUIRED.

[Joe Boyle]

Hi Syed,

I am absolutely certain, but I cannot explain how your other screen worked.

Re the screen that worked, were you writing new rows, or updating existing
rows ? I ask this because only updating suffers from this problem - in order
to update a row, PH must first re-retrieve the row in order to ensure that
the checksum value has not changed, and there must be a unique key value to
identify the specific row.  

Oracle need not have a unique index because it uses a DBKEY which is a
unique row identifier within the database. There are also Mpe file systems
which use a DBKEY, namely allbase and possibly image.

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.