Babycat
Member
- Local time
- Today, 06:17
- Joined
- Mar 31, 2020
- Messages
- 285
Hi all,
I want to clear CurrentID (long) to null (nothing) in table current logged User
I thought it was simple SQL.
UPDATE L_TBLUSER_CURRENT SET L_TBLUSER_CURRENT.CurrentID = Null;
But I got error: "You tried to assign the NULL value to a variable that is not a Variant data type"
My purpose is when I read back Dlookup("CurrentID", "L_TBLUSER_CURRENT")& "" = "" then msgbox "No current UserID"
Any help please?
I want to clear CurrentID (long) to null (nothing) in table current logged User
I thought it was simple SQL.
UPDATE L_TBLUSER_CURRENT SET L_TBLUSER_CURRENT.CurrentID = Null;
But I got error: "You tried to assign the NULL value to a variable that is not a Variant data type"
My purpose is when I read back Dlookup("CurrentID", "L_TBLUSER_CURRENT")& "" = "" then msgbox "No current UserID"
Any help please?