Delete table row

[Amal]

Hi

is there anyway to delete some specific rows from a mapinfo table. I
have a table called clutter in which there is a column which has
different clutter type. I want to delet some clutter type data.

I tried this

Delete from Clutter where cluttertype = "Open" but gave an " error
cannot perform this operation on field cluttertype". i am new to this.
any information on this will be helpfull.

Regards

[siddahrtha kamasani]

Hi

 

Select * from Clutter where cluttertype = "Open" into temptab

 

Delete from temptab

 

Warm Regds

Sidharth Kamasani

Project Manager

Empower Consultancy Pvt. Ltd.

--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

--
Warm Regds
Sidharth Kamasani

[Amal]

Hi Sidharth

Thanks for your reply ..

Now i am getting an error message "Numeric values required"
BTW cluttertype column is defiend as character

Regards

Amal

On Jul 16, 10:12 am, siddahrtha kamasani <sidharthkamas...@gmail.com>
wrote:

> Hi
>
> Select * from Clutter where cluttertype = "Open" into temptab
>
> Delete from temptab
>
> Warm Regds
> Sidharth Kamasani
> Project Manager
> Empower Consultancy Pvt. Ltd.
>

> On 16 July 2010 06:31, Amal <ghosh.a...@gmail.com> wrote:
>
>
>
>
>
> > Hi
>
> > is there anyway to delete some specific rows from a mapinfo table. I
> > have a table called clutter in which there is a column which has
> > different clutter type. I want to delet some clutter type data.
>
> > I tried this
>
> > Delete from Clutter  where cluttertype = "Open" but gave an " error
> > cannot perform this operation on field cluttertype". i am new to this.
> > any information on this will be helpfull.
>
> > Regards
>
> > --
> > You received this message because you are subscribed to the
> > Google Groups "MapInfo-L" group.To post a message to this group, send
> > email to mapi...@googlegroups.com
> > To unsubscribe from this group, go to:
> >http://groups.google.com/group/mapinfo-l/subscribe?hl=en
> > For more options, information and links to MapInfo resources (searching
> > archives, feature requests, to visit our Wiki, visit the Welcome page at
> >http://groups.google.com/group/mapinfo-l?hl=en
>
> --
> Warm Regds

> Sidharth Kamasani- Hide quoted text -
>
> - Show quoted text -

[zer...@gmail.com]

Hi,

Try to use Quick Record Selector v2 from Toby Grant.

http://www.directionsmag.com/files/index.php/view/810


Sent from my BlackBerry®
powered by Sinyal Kuat INDOSAT

[siddahrtha kamasani]

Hi Amal,

 

Try this

 

Dim rid as integer

 

Select * from Clutter where cluttertype = "Open" into temptab

rid = temptab.ROWID

 

Delete from Clutter where ROWID = rid

 

 Warm Regds
 Sidharth Kamasani
 Project Manager
 Empower Consultancy Pvt. Ltd.

[Amal]

Hi Sidharth

Its giving the same message "Numeric values required"

Regards


Amal



On Jul 16, 11:26 am, siddahrtha kamasani <sidharthkamas...@gmail.com>
wrote:

> Hi Amal,
>
> Try this
>
> Dim rid as integer
>
> Select * from Clutter where cluttertype = "Open" into temptab
>
> rid = temptab.ROWID
>
> Delete from Clutter where ROWID = rid
>
>  Warm Regds
>  Sidharth Kamasani
>  Project Manager
>  Empower Consultancy Pvt. Ltd.

[Amal]

Thanks .. this will help.

> archives, feature requests, to visit our Wiki, visit the Welcome page athttp://groups.google.com/group/mapinfo-l?hl=en- Hide quoted text -

[Amal]

Hi

This tool has done the trick..
http://www.directionsmag.com/files/index.php/view/682

Thanks to the Author Oguzhan DABANLIBASAR

Thank you Sidharth and Zery for help.

> > archives, feature requests, to visit our Wiki, visit the Welcome page athttp://groups.google.com/group/mapinfo-l?hl=en-Hide quoted text -
>
> > - Show quoted text -- Hide quoted text -

[siddahrtha kamasani]

Hi Amal,

 

Can u send me snapshot of table structure. Through group or to my mailid: Sidharth...@gmail.com

 

 

warm regds

Sidharth Kamasani
Project Manager
Empower Consultancy Pvt. Ltd.