2. PHPRunner General questions
  3. copy records variable at once
This topic is locked

copy records variable at once

 		1/4/2010 10:59:03 PM
PHPRunner General questions
O
 onlline author

I have a problem.

I have a table this table :
id name date user request for

1 Leo 10/10/2009 frank office 1 add copy delete

2 Leo 11/10/2009 peter office 2 add copy delete
//** Insert a record into another table ****

global $conn;

$count = 50;

for ($i = 0; $i < $count; $i++) $conn->Execute($this->InsertSQL($rs));

// $strSQLInsert = "insert into TableName (Field1, Field2) values (Value1, Value2)";

db_exec($strSQLInsert,$conn);
When i click on copy relate record, this record is replicated one time.

I want to copy the record of my choice, 1 ,2 , 50 , 100...

i want to decide how many times the record must be copied

Can you help me?
O
 		onlline author 1/4/2010

global $conn;

for ($i=0; $i<20; $i++)

$conn->Execute($this->InsertSQL($rs));
?????
J
 		Jane 1/7/2010

Hi,
here is a sample:

http://www.xlinesoft.com/phprunner/docs/update_multiple_records.htm
O
 		onlline author 1/7/2010



Hi,
here is a sample:

http://www.xlinesoft.com/phprunner/docs/update_multiple_records.htm


Hi Jane,
I need to insert and delete do not! such uncertainty'm a payable
payables
customer id value due date
1 leo 20/02/2010 500.00

1 leo 20/03/2010 500.00

1 leo 20/04/2010 500.00

1 leo 20/05/2010 500.00

1 leo 20/06/2010 500.00
would like to share in a single repeat 25 times omesmo register but with the right dates
these values change as the client
J
 		Jane 1/8/2010

Hi,
you can modify BeforeDelete event and insert new records with different date values.
O
 		onlline author 1/8/2010



Hi,
you can modify BeforeDelete event and insert new records with different date values.


Perfect worked well but for a function of accounts payable! thank you very much! but now I have to doubt before
Grandpa put here more data to explain better!
my table adplen
seller enrolls name represented product value due
I need to enter with 25 plots for this client. I would like to come at once with the 25 plots, one thing that also need the system to do is to put the expiration date of the following months
example
Customer: Leonardo enrollment: 1220 represented: Microsoft seller: Amazon product: Seven Value: $ 10,000.00 due
this client pay falls 25 plots at the same value, but at future dates
J
 		Jane 1/12/2010

Leonardo,
I recommend you to publish your project on Demo Account and open a ticket at http://support.xlinesoft.com sending a URL to your pages along with detailed description of what you want to do.