BatchMove and a field Constant

Thread View: borland.public.delphi.database.objectpascal

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Don Gollahon Thu, 08 Jan 1998 00:00

Author: Don Gollahon
Date: Thu, 08 Jan 1998 00:00

17 lines
1224 bytes

I'm moving data from a MSSQL 6.5 table to another MSSQL 6.5 table that
has some new fields.  I want one of the fields to just get 'D' placed
in it but BatchMove tells me there's no field named D.

In another instance of this I will be taking a phone number field that
was 10 characters and splitting it up into area code, prefix, suffix
using substring.  But my guess is the BatchMove won't do this either.

Is there a way to get BatchMove to do the above?  If not, is there a
way to write an SQL statement that will do something similar to
batchmove like commit every 100 records and keep going on key
violations (or overwrite the record on key violations)?

Thanks.

Don Gollahon (dlgllhn@ibm.net)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads