Cannot write to table. URGENT HELP REQUIRED.

[Syed Shahul Hameed Mustaffa]

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