Hi - I'm sure that this has been covered loads of times but I can't find any
record of it.

I want to update a table on the basis of a condition i.e. (in SQL terms)
        
        update tblPostDist
                set target_custs=tot_custs
                where tot_custs>target_custs

I can't see any way of issuing the where condition, I've tried typing the
above code into the MapBasic window and the response was something like
"unable to update target_custs"

Any help/ideas/note of limitations is appreciated.

Cheers - Andrew

_________________
Andrew Whittam
Senior Business Analyst
Tel: 020-7349 4087
Fax: 020-7349 4001



_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.

Reply via email to