Cannot write to table. URGENT HELP REQUIRED.

[Syed Shahul Hameed Mustaffa]

Dear Joe,

You're correct. I couldn't update.
It says 'not all records are updated'.

I'll try to use the sql solution you've recommended.
I'll let you know the results.

Best Regards,
SYED

On 7/9/05, Joe Boyle <atla38 at dsl.pipex.com> wrote:
> 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.
> 
>