John,
Inserts can (and usualy do) have both eg
"insert into mytable (obj, col1,col2,col3) values (newobj,val1,val2,val3)"
Alters are carried out with the update command and can include both (they
also usually have a rowid statement for individual updates) eg
"update mytable set obj = newobject, col1 = val1, col2 = val2, col3 = val3
where rowid = x"
simply once you have done a couple.
Sanity check failed
Cheers
Martin
===================================
Martin Roundill
GIS Manager
Waitakere City Council
Private Bag 93109
Henderson
Waitakere City
New Zealand
Ph +64 9 836 8000 ext 8344
Fax +64 9 836 8001
email [EMAIL PROTECTED]
===================================
> -----Original Message-----
> From: John Chioles [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, 19 October 1999 10:34
> To: 'MapInfo-L'
> Subject: MI MB sanity check: Insert/Alter Objs/Table
>
> MBers:
>
> This is a sanity check:
> Please confirm that it is not possible to insert both objects and values
> into a table w/ a single statement.
> Likewise, with Alter one can either alter an Object or a Table both not
> both
> at the same time.
>
> -John
>
> ----------------------------------------------------------------------
> To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
> "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
