Re: Insert/Select question in 4gl

OOPS, SORRY, My previous message was WRONG. I didn't read very carefully. :-( 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)> > 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 >--=20 > >----------------------------------------------------------------------- >Note the new address: mickm@*ix*.netcom.com. of course, leave out the >stars, those are just there for emphasis, oh, and leave off the period >at the end of the com, that is just to denote the end of the sentence. > >So what you *really* want is mickm@ix.netcom.com =20 >Now why the hell didn't I just say that in the first place? It's a=20 >mystery... >----------------------------------------------------------------------- >=01=01=01=01 --=20 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