jimmy coretes
|
Posted: 04/17/2001, 9:39 AM |
|
I have a table which has some fields I need to update:
UPDATE orders SET orders.member_id = session("userID")
WHERE (((orders.member_id)=session(unicoID)));
I know I canīt do this..!!! SQL doesnīt accept this variables.
How can I mix this kind of variables in the same procedure?
I have no idea.. thanks,
|
|
|
Alexey Alexapolsky
|
Posted: 04/18/2001, 2:41 AM |
|
Use "Form properties"/Events/"Before update" event ,
enter code :
fldmember_id = session("userID")
Where "fldsomething" is an automatically created variable for
form field named "something".
--
Regards,
Alexey
CodeCharge Support
jimmy coretes <webmaster@virtuallinksa.com> wrote in message
news:9bhrjd$ool$1@mail.tankhill.com...
> I have a table which has some fields I need to update:
>
> UPDATE orders SET orders.member_id = session("userID")
> WHERE (((orders.member_id)=session(unicoID)));
>
> I know I canīt do this..!!! SQL doesnīt accept this variables.
>
> How can I mix this kind of variables in the same procedure?
>
> I have no idea.. thanks,
>
>
|
|
|
|