Re: SQL returns diff results in ESQL and Power Builder

iiug@hotmail.com wrote: >Yes we are initialising the var to 0. > >The count(*) in the ESQL/C program returns one though there is no record >in >the table. I tried modifying the sql as : >insert into newtab >select * from d65_po_itm >where some_conditions_here> >After running the above query, if I query the newtab table, there are no >records in newtab, and that is how it should be. > >Table newtab has the same structure as d65_po_itm What's in your where clause? carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com