Could it have come down to a simple typo. Checking the table name, do you
have a table with the name "memeber" or "member"?
On 10 April 2012 02:20, Gavin wrote:
> Hi Suman,
>
> Yes the variables are containing data. vcode is randomly generated,
> loginName, and email come in from a form.
>
> I
You could also try the following approach:
- on the table, have an INSERT trigger add the username to a column
named CREATE_WHO (this can be extended to UPDATE operations too, but
this probably isn't necessary in your example)
- create a view based on "select * from table where CREATE_WHO =
SUBSTRI
