Re: Date function in PERFORM

In <95152.16003032JMX3X@CMUVM.CSV.CMICH.EDU> AMR E MALIK <32JMX3X@CMUVM.CSV.CMICH.EDU> writes: >Hi all!! >I'm trying to setup a form which should have the ability to capture the >name of the person who is currently adding/updating the form. We have >RS/6000 AIX 3.2.4 and Informix SE 5.0. The SQL lets me use the "user" >function, but when I put it in the "instructions" section it gives >error saying that "user" is not a field in the table?? I have a column >in the "member" table which would record the value returned by the "user" >function. any pointers? >I know the "today" function works in perform, but "user" doesn't seem to >I would really appreciate it if someone could give me any pointers on this >thanks, >-AMR >the piece of code giving error: >instructions >on editadd editupdate of member > let f_usr1 = user >. >... >end {** of instructions section **} >** f_usr1 is the field name and member is the table, f_usr1 points to >member.lastuser field in the "attributes" section. I ran into a similar problem, and the solution (without 4gl or esql) was to add the row in an sql script " Insert into [table](user_name, ...stuff) value(user, ...stuff)", then update the now existing record with the form. When I get around to updating this applet, I'll use 4gl, but I didn't have it at the time so had to do it with sql only. Cheers