Struan Judd wrote:
> INSERT INTO table1 ( field11, field12 )
> SELECT field21, field22 FROM table2
Hi Struan, I just tried the following in database desktop (again a
paradox table):
INSERT INTO CalcMethod ( ConfigurationID, Object, Attribute, Method,
Description )
SELECT 1, Object, Attribute, Method, Description FROM CalcMethod
Unfortunately I get "Type Mismatch in Expression", I assume this is
possibly due to attempting to hardcode the value of ConfigurationID. If
I run the SELECT portion on its own it works ok, but returns 1 as 1.0
which is the wrong type for ConfigurationID which is a straight integer.
Any idea how I can force the SELECT to return 1 instead of 1.0?
Mark
--
Mark Derricutt | Chalice of Blood
Software Developer | New Zealand Christian Music News
Auckland, New Zealand | http://www.chalice.gen.nz
[EMAIL PROTECTED] | UIN: 1934853
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
