Insert Query and Integer fields (Pdox Table)

Article View: comp.lang.pascal.delphi.databases

Article #80

Back to comp.lang.pascal.delphi.databases Previous Next

#80

From: Frans Trentelman
Date: Tue, 29 Dec 1998 00:00

31 lines
1498 bytes

Hello all,

Has anyone solved this:

When I use an Insert Query on a Paradox Table like

Insert into "DestTable"
Select 
stringfield,
integerfield,
anotherfield,
0 as integerfield2,
etc
From "anothertable"

Then it won't work unless:
1. I select as many fields as there are in "DestTable"
2. The DestTable Integer fields are of Type "Number"

the first problem i think i can live with, but the second i'm worried
about.
Also I want to insert a null value into an integer field. (which is a
problem)


Greetings,
Frans
-- 
Please send very useful reply's via e-mail.
When replying via e-mail, remove the letters 'NOSPAM.' from my adress.
Thank you.

Technical Details

Message-ID: <36889365.98B81D98@NOSPAM.som.nl>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,61d915cad5e332a6,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: ff75c,61d915cad5e332a6,start
X-Google-Attributes: gidff75c,public
From: Frans Trentelman <ftrentel@NOSPAM.som.nl>
Subject: Insert Query and Integer fields (Pdox Table)
Date: 1998/12/29
Message-ID: <36889365.98B81D98@NOSPAM.som.nl>
X-Deja-AN: 426710604
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@nl.uu.net
X-Trace: koza.nl.net 914920228 9928 195.109.251.52 (29 Dec 1998 08:30:28 GMT)
Organization: SOM
Mime-Version: 1.0
Reply-To: ftrentel@NOSPAM.som.nl
NNTP-Posting-Date: 29 Dec 1998 08:30:28 GMT
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop