Re: Deleting from a non-base table in forms 4.5.

From: Alfonso brugnoli <alfonso.brugnoli_at_tin.it>
Date: Mon, 19 Feb 2001 21:42:37 GMT
Message-ID: <hrgk6.49008$Uj1.435643_at_twister2.tin.it>

Hello ! You can attack the sql code or Java program to understand well the problem !?
A suggestion may is to do two transaction : 1 : to get data into combo box or other object

           SELECT sequential number
           FROM    TABLE

2 : select it and to set with this value a string Container 3 : to do a Dynamic update query :

           DELETE *
           FROM    TABLE
           WHERE    sequential number = 'string Container'

This is only a idea ! But I am not sure to undertand your problem !?
                                    Paolo Brugnoli

"Matt B." <mcb_at_ds.znet.com> ha scritto nel messaggio news:t6499aasin7tfd_at_corp.supernews.com...
> "John Jessamy" <jjessamy_at_wow.net> wrote in message
> news:93onnc019s5_at_enews4.newsguy.com...
> > I am trying to delete from a table that is used for storing a
 sequential
> > number. The form is not based on this table and I would like to remove
 that
> > record right after I have finished selecting it into the form. I have
> > tried a conventional Delete statement in a post-database-commit trigger
 as
> > well as a client side procedure with no success.This seems to be a
 fairly
> > simple problem but the solution escapes me. If anyone has any
 suggestion,
> > they would be greatly appreciated.
> >
> > Thanks in advance.
> > John Jessamy.
>
> Odd request, but if you have to, you have to.
>
> Never had this situation before, but how about on POST-QUERY, put a delete
> statement there?
>
> -Matt
>
>
Received on Mon Feb 19 2001 - 22:42:37 CET