Insert Query and Integer fields (Pdox Table)

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

2 messages

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

2 total messages Started by Frans Trentelman Tue, 29 Dec 1998 00:00

#80

Author: 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.

Re: Insert Query and Integer fields (Pdox Table)

#79

Author: grozev
Date: Tue, 29 Dec 1998 00:00

49 lines
2091 bytes

In article <36889365.98B81D98@NOSPAM.som.nl>,
  ftrentel@NOSPAM.som.nl wrote:
> 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
---------------------------------------------

Hi Frans,

Try this

INSERT INTO Dest_table (field1, field2.... list exactly the fields)
SELECT field1,field2.....
FROM AnotherTable
WHERE Search_Condition;

I think the 'NUMBER' type is for float values. Use  'SHORT' or 'LONG NTEGER'
for an	Integer field.

Use NULL to insert a null value.


Best regerds / Grozev

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/       Search, Read, Discuss, or Start Your Own

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