>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)>
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