CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 multiple insert

Print topic Send  topic

Author Message
rquezada

Posts: 7
Posted: 10/10/2007, 8:57 AM

Por favoir URGENTE requeiro al ayuda de un colega...

Necesito crear un formulario tipo editablegrid, para ingreso de multiples datos a una tabla, pero los dos primeros textbox recogen datos de otra tabla.

espero su ayuda.
_________________
Rodrigo
View profile  Send private message
andy


Posts: 183
Posted: 10/12/2007, 3:50 AM

ROUGH TRANSLATION:
Please I require the URGENT help of a colleague ...

I need to create a standard "editable grid" form for multiple data entry into a table, but the first two textboxes collect data from another table.

I hope you can help.
_________________
Andy

RAD tools for rich UI controls:
http://www.koolphptools.com
View profile  Send private message
andy


Posts: 183
Posted: 10/12/2007, 3:54 AM

Hi Rodrigo

How about making these two fields listbox fields.
The list box can lookup data from other tables.

GOOGLE (RUBBISH) TRANSLATION:
Hola Rodrigo

Acerca de cómo hacer que estos dos campos lista ( "LISTBOX" ) campos.
La LISTBOX puede cuadro de búsqueda de datos de los demás cuadros.


_________________
Andy

RAD tools for rich UI controls:
http://www.koolphptools.com
View profile  Send private message
oracolo

Posts: 3
Posted: 10/18/2007, 8:05 AM

You can use a your own statement "insert".

In the BeforeExecuteInsert:

1. rewrite the original "insert" statemet ...

$YourGrid->DataSource->SQL = "insert into FirstTable (field3,field4,...) values ($fieldValue3,$fieldValue4,...)";

and then ....

2. always in the same event, write a new statement od "insert"

$dB = new clsDBYour();
$SQL = "insert into SecondTable (field1,field2) values ($fieldValue1,$fieldValue2)";
$dB->query($SQL);
$dB->close();

bye
_________________
Using: CodeCharge Studio 3.2.0.4 - Apache, PHP and ORACLE
View profile  Send private message
rquezada

Posts: 7
Posted: 10/18/2007, 8:28 AM

HI. please, in not second table is second or more data from one table one form.


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