(UTC)
  Lantica User Forum › Archived Topics › Archived Topics › Delete all records in 1 field
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Delete all records in 1 field (Read 507 times)
javir73
Member
*
Offline


No personal text

Posts: 20
Joined: Jun 30th, 2004
Delete all records in 1 field
Aug 11th, 2004 at 6:48pm
Print Post Print Post  
Hello.  I have yet again translated another Q&A database into Sesame.  This time, the last 2 fields show random characters. (ie. /^, /R, /T)  I have no idea where these came from, but the database seems to be working other than this.  Is there a way to delete all the records in 1 field?  I have 7011 records at present and do not wish to go through them individually.  Also, these characters are not present in the Q&A database.

Thanks
  
Back to top
 
IP Logged
 
CapitalG
Full Member
Members
***
Offline



Posts: 143
Location: Phoenix, Arizona
Joined: Mar 4th, 2003
Re: Delete all records in 1 field
Reply #1 - Aug 11th, 2004 at 7:00pm
Print Post Print Post  
See the Users Guide pages 237 - 259 on Mass Update.  Just run a mass update changing them to blank/null.

  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge