So far my VServer version has been quite primitive. I'm currently implementing a user and group management. Of course, not all users should see all data.
For a long, long time I've done duplicate checking when adding data with a VSet:
dim theCheckset as VSet
theCheckset = InternalMessageIDField.FindValueAsArraySet(CheckMessageID)
if theCheckset = nil then
theResult = False
else
dim i as Integer = theCheckset.Count
if i = 0 then
theResult = False
else
theResult = true
end if
end if
I can't see this working in a multiuser environment. My database has mailboxes and emails. The duplicate check is for the emails. I wanted to add a user field to the mailboxes. But even if I add a user field to the emails, too, I can't see a way to make the VSet work. The combination of user and emails would need to be unique.
Did I miss anything or do I need to use SQL now? Is it good at all to use VSet for VServer?