The unique keys in a verity collection are for the same reasion you need a
unique key in a database - for updates. When verity refreshes a collection,
it doesn't drop the whole thing and rebuild it. It looks for the key and if
it exists, it updates the record.
As to why it fails with a fifth ta
I realise no one is following this thread anymore, but I'm just updating it in
case it helps someone from the archives later.
Course if anyone has any suggestions, feel free to chime in.
I have changed the Select strings to make all the keys unique. I still don't
understand why this is necessa
Ok, after a lot of messing around I have come up with this:
---
select CStr(tblpoker.pokerid) + '|' + tblCasinos.casinoid AS
CasinoID,tblpoker.pokerdesc
from tblCasinos, tblPoker
where ',' + tblCasinos.poker + ',' like '%,' + CStr(tblPoker.pokerid) + ',%'
UNION
select CStr(tblslots.slotsid) + '|'
> That's cool if I just wanted to find out whether the
> tblcasino.poker field was in a list.
You mean if a tblPoker.pokerid field is in a tblCasio.poker list...
> But consider that I want to have one query where I join
> the tblcasinos table to the other sub-tables containing
> the descriptions
That's cool if I just wanted to find out whether the tblcasino.poker field was
in a list.
But consider that I want to have one query where I join the tblcasinos table to
the other sub-tables containing the descriptions of the game types.
For purposes of creating a Verity Collection from the dat
Heh... Although I know there's NO need to tell you this, avoiding
comma delimited lists would prevent the need to poke people with your
poker pickle. :-P
That being said, the obligatory pickle-poking may not be as bad as you
think...
give this query a poke... err... I mean peek...
select casinoi
Well..I've gone and gotten myself into some trouble with a database design
(mentioned it before) and Verity Searching.
It wasn't planned, but it's turned out that we need to do a Verity search on a
database.
There is one table of casinos, and several other tables of different casino
games.
7 matches
Mail list logo