With some SQl combine a select with an insert
HTH D On 29/07/14 18:05, John C wrote: > Hi all > > I have a table with a CLIENT index field. How can I copy (within the > same table) the contents from one client to another client? > > Table structure: Client_ID, Field1, Field2, Field3 > > Before 1, 222, 333, 444 > > 1, 555, 666, 777 > > After 1, 222, 333, 444 > > 1, 555, 666, 777 > > *2*, 222, 333, 444 > > *2*, 555, 666, 777 > > Thanks a lot > > John C > > > > _______________________________________________ > NZ Borland Developers Group - Delphi mailing list > Post: [email protected] > Admin: http://delphi.org.nz/mailman/listinfo/delphi > Unsubscribe: send an email to [email protected] with > Subject: unsubscribe > _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
