>
>SELECT scode ,;
> CODE ,;
> descr ,;
> fname ,;
> descru,;
> fnameu,;
> lcode ,;
> sec ;
>from student into cursor vvvvvvvv readwrite
>now i want create new field in vvvvvvvv AND add following as string(messagebbb)
>
>messagebbb= " id#"+Alltrim(code)+" Name"+Alltrim(Name)+"Fname"+Alltrim(fname)+ "Level"+Alltrim(lcode)+ " Sec"+Alltrim(sec)
>
>thanks
SELECT scode ,;
CODE ,;
descr ,;
fname ,;
descru,;
fnameu,;
lcode ,;
sec ,;
CAST(" id#"+Alltrim(code)+" Name"+Alltrim(Name)+" Fname"+Alltrim(fname)+ " Level"+Alltrim(lcode)+ " Sec"+Alltrim(sec) as CHAR(200)) AS NewField;
from student;
into cursor vvvvvvvv readwrite
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
