home bbs files messages ]

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

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

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

   Message 8,346 of 9,834   
   Mike Johnson to jmose@mapson.attglobal.net   
   Re: Paradox 5 (Win) Check for emty field   
   23 Mar 07 11:49:21   
   
   From: question@hotmail.com   
      
   Hi,   
      
   No it is just a query that shows all record with a blank value in the   
   Text field (as an error report).   
      
   MJ   
      
   On 22 Mar 2007 07:44:33 -0500, "Jim Moseley"   
    wrote:   
      
   >   
   >MJ,   
   >   
   >Is this a ChangeTo query?  If so, sorry about wiping out your data!   
   >   
   >You can put in a selection criteria (-ium?) with a ChangeTo command if you   
   >separate them with a comma.   
   >   
   >For example, 'blank,changeto "XYZ"' or '_x, > 2000,changeto _x * 1.25'.   
   >The first example will change any blank field to 'XYZ'.  The second example   
   >will change any value greater than 2000, increasing it by 125%.   
   >   
   >HTH,   
   >Jim Moseley   
      
   --- 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