Hi Tom,
Try:
delete from tablename [where rowid=n]
You'll need to supply the table name in place of "tablename". The
optional rowid where clause allows you to select a particular record to
delete.
-- Eric Johnson
Tom Halbrook wrote:
Hi Listers:
Being a MapBasic Neophyte, I have what will probably be a dumb
question. But here goes any way.
I manually select a record from table A, append it to table B, delete
the selected record from table A and then save both tables.
To automate steps I have built a button pad and associated program to
append the selected record to table B, then commit both tables. But I
can’t seem
to find the right statement to delete the record from table A. I know
it’s simple but I’m at my wits end.
Any Help?
Thanks, Tom H
------------------------------------------------------------------------
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l