home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 9,281 of 10,840   
   Elef to All   
   Re: find in database   
   12 Mar 05 12:53:58   
   
   XPost: comp.lang.basic.visual.database   
   From: m.p.b@*toglimi*rocketmail.com   
      
   "Henk Salomons"  ha scritto nel messaggio   
   news:d0nlva$jgn$1@reader11.wxs.nl...   
   >    Question,   
   >   
   > Is it possible to use a AND in a find string, somthing like this:   
   >  Db.recordset.find("Collum1=London AND Collum2=Amsterdam"), 0,   
   > adSearchForward, adBookmarkFirst   
   >   
   > In this syntax is doesn't work, is there a way to do this??   
   >   
   > Greetings Henk   
   >   
   >   
   Try this (note apostrophes around town names):   
      
   Db.recordset.find("Collum1='London' AND Collum2='Amsterdam'"), 0,   
   adSearchForward, adBookmarkFirst   
      
   Bye   
   Elef   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca