[RBASE-L] - RE: stored procedures

[Troy Sosamon]

I would guess that project is not a valid or safe command in a stored procedure.   I would write it out the long way and use create Temp table....... and then do an insert into your temp table.   Even if you can do it, I would not recomend making any structure changes from a SP.  You should be ok with temp tables.     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Alan Wolfe Sent: Thursday, January 15, 2004 3:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - stored procedures Hey everyone,   i have a stored procedure that has just 1 line in it:   project .tempname from userno using all .clause       and i put the stored procedure in like this so it takes 2 parameters:   put resdet.cmd as resdet tempname text, clause text       now when i call it from the R> like this:   call resdet('temptable','where userno < 4')       im aiming for it to do this:   project temptable from userno using all where userno < 4     but when i try and call it it gives me an error saying "Missing table list", making me think im using variables incorrectly or something.  Does anybody know why its doing that or how to make it do what im trying to do?   Thanks a bunch! Alan