deagon
Posts: 31
|
| Posted: 05/22/2007, 10:38 AM |
|
I'm trying to find an way with the least amount of code to take selected data fields and move or copy these selected data fields to another table in the same database. Is there a straight forward method to do this? I'm trying to take POstorage table and move the selected data including customer, customerPO, amont and qty and move it to the Jobstorage table where it becomes an active job. I'm not sure what direction to go in.
Any help would be greatly appreciated!
Thanks..
|
 |
 |
ReneS
Posts: 225
|
| Posted: 05/22/2007, 11:32 AM |
|
Hi,
Do you mean by using ASP and webpage? or within the database with enterprise manager or other tool?
Rene
|
|
|
|
deagon
Posts: 31
|
| Posted: 05/22/2007, 11:45 AM |
|
I'm told by Yes software that code charge does not have the ability to move or copy data from one table to another. What I'm trying to do is take specific multiple table data from the sql database and insert the data with the same name into another table. After that has been accomplished I will delete the records in the first table. This will allow me to authorize a sales order and add a jobnumber into the jobstorage table. Its seems overkill but I must follow the logic specified by my boss. I'm testing using SQL select into, SQL insert and sql in statements in after clicking submit button. I'm still going to need to test data fields prior to inserting into another table.
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 05/23/2007, 10:04 AM |
|
You could use the "delete" checkbox in the editable grid to do what you
want.
Except, before deleting the record you would first place your insert query
onti the other table.
|
|
|
|
|
