You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have below query to update and after I use cmd to generate file, I got error.
I don't know why but I used this query in Room Database and it's ok
ERROR
The parameter newUsersJoined should be referenced like a list (x IN (:newUsersJoined)) Change the type of newUsersJoined to not be a List<> orreference it with IN (:newUsersJoined) (including the parentheses).
QUERY
@Query('UPDATE spaces_table '
'SET '
'ownedBy = :newOwnedBy, '
'secondUserId = CASE WHEN :newSecondUserId IS NOT NULL THEN :newSecondUserId ELSE secondUserId END, '
'avatar = :newAvatar, '
'name = :newName,'
'username = CASE WHEN :newUsername IS NOT NULL THEN :newUsername ELSE username END, '
'type = :newType, '
'isTurnOffNotification = :newIsTurnOffNotification, '
'usersJoined = :newUsersJoined '
'WHERE id = :spaceId')
Future<int?> updateSpace(
String spaceId,
String newOwnedBy,
String newSecondUserId,
String newAvatar,
String newName,
String newUsername,
String newType,
int newIsTurnOffNotification,
List<UserJoinedEntity> newUsersJoined,
);
The text was updated successfully, but these errors were encountered:
I have below query to update and after I use cmd to generate file, I got error.
I don't know why but I used this query in Room Database and it's ok
ERROR
QUERY
The text was updated successfully, but these errors were encountered: