On Mar 26, 2008, at 8:59 AM, josep porres wrote:
>
> INSERT INTO demo_tab SELECT demo_tab_row.*;
>
>
> I tried this before with no success.
> But I realized that it was because a problem with a constraint, no
> warnings about this at all.
> With the detailed insert i've got the constraint error.
> I was using the execute because I had a variable called the same as
> a field, not good, I changed it.
> So now it's working perfectly!!!
You don't need SELECT at all:
INSERT INTO demo_tab VALUES (demo_tab_row.*);
John DeSoi, Ph.D.