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)

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

Thats all.

Yours, Volker
--
Volker Fraenkle                         CS Controlling
Technical Consultant                    Software Systeme GmbH