Re: Insert/Select question in 4gl

Mickey Mestel wrote: >hi, > > i'm at a customers where in a 4gl program they are doing something like >this: > >insert into table1 col1,..., name, ...coln > values (select ..., first_name + last_name, ...from table2)> This is WRONG in 4GL. You should concatenate the first and last names in 4gl program: Let full_name = first_name CLIPPED, ' ', last_name and then insert full_name into table1 Best Regards, Octav > so all they want to do is to concatenate the first and last name from >table2, and put it into the name column of table1. this works fine in >dbaccess, but doesn't in 4gl. we get a runtime error, which i just >realized i don't have written down, but can get later if need be. > > this seems like it should be simple, but i haven't been able to figure >it out in the few minutes i had to put into it. > > any ideas? > > mickm >-- > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 20 96 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com