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 Studio -> PHP

 5USD for resolve: Insert One Record to Two or More Tables (newbie)

Print topic Send  topic

Author Message
azzarev

Posts: 9
Posted: 06/17/2013, 10:24 AM

Hi Guys,
I have to insert a record in two differents tables. How can I do it? I have no idea.
View profile  Send private message
adorni

Posts: 120
Posted: 06/19/2013, 9:40 PM

I need this too.

Thanks!
View profile  Send private message
ckroon

Posts: 868
Posted: 06/26/2013, 5:41 PM

Use the record form to insert the record into table 1, then add a Custom Code event to the record from in the After Insert Event.

You need to grab the last insertID from the record you just inserted, get teh values you need from that record and then do a sql Insert into table 2.

_________________
Walter Kempees...you are dearly missed.
View profile  Send private message
azzarev

Posts: 9
Posted: 06/26/2013, 6:53 PM

Really thx for your reply.
1) How to grab last insertID from the record I just inserted?
2) How to get the values I need from that record?
3) How to do a sql to Insert into table 2?

Sorry but I am totally newbie! Thanks for your patience!
View profile  Send private message
MichaelMcDonald

Posts: 639
Posted: 06/27/2013, 7:54 PM

There are a couple of guys on here whose business provides CCS training.

For newbies attempting this kind of thing, it's a good idea to consider them, because they can provide jump starts into complex solutions.
_________________
Central Coast, NSW, Australia.

View profile  Send private message
azzarev

Posts: 9
Posted: 06/27/2013, 7:59 PM

Quote MichaelMcDonald:
There are a couple of guys on here whose business provides CCS training.

For newbies attempting this kind of thing, it's a good idea to consider them, because they can provide jump starts into complex solutions.

How to obtain this training?
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.