CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> Programming

 After insert records of a editable grid, insert the same records in another table

Print topic Send  topic

Author Message
iaiti

Posts: 9
Posted: 10/19/2006, 4:37 AM

Hi !

I have an editable grid where I insert the order itens of my order. I made the example and it works fine. But after I insert my rows I also want to insert all the rows of the editable grid in another table. I Have the ORDER_ITENS table and I have a MISSED_ITENS table (I want to fill this table with all the itens from the editable grid).
Anyone can Help me?
View profile  Send private message
Glenn Rathke \(Soft Design Consulting\)
Posted: 10/19/2006, 5:24 AM

Hi,

If you're using a SQL database, create an insert trigger on ORDER_ITENS that
will insert into MISSED_ITENS.

Glenn


"iaiti" <iaiti@forum.codecharge> wrote in message
news:144537637e92c98@news.codecharge.com...
> Hi !
>
> I have an editable grid where I insert the order itens of my order. I made
> the
> example and it works fine. But after I insert my rows I also want to
> insert all
> the rows of the editable grid in another table. I Have the ORDER_ITENS
> table and
> I have a MISSED_ITENS table (I want to fill this table with all the itens
> from
> the editable grid).
> Anyone can Help me?
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>

iaiti

Posts: 9
Posted: 10/23/2006, 2:51 AM

Thanks for your reply. I'm using Microsoft Access as database.
I donīt Know how I can do it ?
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright Đ 2003-2004 by UltraApps.com  and YesSoftware, Inc.