Article View: borland.public.delphi.database.objectpascal
Article #1Re: BatchMove and a field Constant
From: Tony Lavelle
Date: Tue, 13 Jan 1998 00:00
Date: Tue, 13 Jan 1998 00:00
19 lines
1391 bytes
1391 bytes
In article <34b545ae.28391344@forums.borland.com>, Don Gollahon <dlgllhn@ibm.net> writes >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. > You can batch move from a TQuery. The SQL string can be something like: SELECT Name, Phone, 'D' AS Something, ... In the Mappings property treat Somthing as if it were a field. Hope this helps. -- Tony Lavelle, Hyrax Computer Systems Ltd, UK Tel +44 181 464 8417 mailto:tony@hyrax.co.uk Fax +44 181 402 2006 http://www.hyrax.co.uk To reply by email - please remove '.nospam' from address
Technical Details
Message-ID:
<RbYTFAAc77u0EwLR@hyrax.demon.co.uk>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<34b545ae.28391344@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10de66,634efecb8f97770c X-Google-Attributes: gid10de66,public X-Google-Thread: 124d08,634efecb8f97770c X-Google-Attributes: gid124d08,public From: Tony Lavelle <tony@hyrax.demon.co.uk.spamtrap> Subject: Re: BatchMove and a field Constant Date: 1998/01/13 Message-ID: <RbYTFAAc77u0EwLR@hyrax.demon.co.uk> X-Deja-AN: 316793169 References: <34b545ae.28391344@forums.borland.com> MIME-Version: 1.0 Distribution: world X-NNTP-Posting-Host: hyrax.demon.co.uk [194.222.32.206] Organization: Hyrax Computer Systems Ltd Newsgroups: borland.public.delphi.database.objectpascal,borland.public.delphi.database.sqlservers