Zugg Software :: View topic

Wanderer Joined: 06 Jan 2006 Posts: 70

I seem to encounter odd database problems. I have an alias that looks like so:

#va colourdb "%-2"
#va dbfindva %find( "%-2", ,%1)
#if (%numitems( @dbfindva)>30) {
#echo Matched %ansi( high, red)%numitems( @dbfindva)%ansi( high, cyan), too many!
#abort 1
}
#t+ dbfindcolour
#forall @dbfindva {
#DBGET %i
#mxp ~<color cyan>Record~:</color> ~<send "#SHOWDB %i">~<color indianred>%i</color></send>
#echo Item~: &Item&ID
#echo Desc~: &Description
#echo ShortName~: &InfoHere
#va IHRoom &RoomNumber
#mxp ~<send "#walk @IHRoom">~<color seashell>Room @IHRoom~</send>~</color> ~<color indianred>~ ~ ~[%roomname( @IHRoom)~]</color>~<color powderblue>~ ~ ~(%zonename( %roomzone( @IHRoom))~)~</color>
#echo ~
}
#t- dbfindcolour

It basically works like DBFIND [Field] [Query]

Sometimes it works sometimes it doesn't, sometimes it will give me 0 entries when I know for a fact that the query should return results. Sometimes it gives me the maximum number of database entries that I have.

Example: DBFIND ZONE THERA

will sometimes return:

Zone: NorthernWilderness

It also seems like changing the order of the fields changes the results sometimes.

Very confused!
Very confused!

Newbie Joined: 10 Mar 2006 Posts: 7

I see a possible problem, I'm not sure if it's the entire cause, or not a cause at all, however, I'll just throw this out there.. When you #DBGET a record, it stays active in the database window, and shows up as the only record, and if you search again, it (I think, at least sometimes what I've seen) searches only thru that array, which consists simply of that one record. So what I would do, is at the end of your #FORALL loop, put in #DBRESET which will reset everything back into the normal view and put the selection at the 0 record value.

In my experiences, this has solve a few of my database problems that have shown up.