🚀 go-pugleaf

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