Re: Reading a row into a Row variable (SPL)

> Mauricio Hernandez wrote: <snip> > > FOREACH cursorA FOR > > SELECT * INTO r FROM Table> > <snip> > > The problem is that when I run the function, the server complains as > > follows: > > > > 720: Number of columns in FOREACH SELECT does not match number of > > variables.> > > > The problem seems to be that '*' is (correctly) interpreted as all the > > attributes of Table and the system seems to be expected as many > > variables as attributes in Table after INTO. > > > > Is there a way to select all attributes into a row variable? Sorry, I dunno Universal Server, but try: SELECT * INTO r.* FROM Table this works on OnLine 5, 4gl v4 (I hope ;-) Michal -- -------------------------------------------------------------- Michal Hajek mailto:hajek@nspuh.cz Sprava NIS http://www.nspuh.cz NsP Uherske Hradiste phone : voice +420 0632 529 204 Purkynova 365 fax +420 0632 551 014 686 68 Uherske Hradiste Czech Republic --------------------------------------------------------------