Re: Views on external databases

Bill Dixon writes: [stuff deleted] > The sql statements we are using to try to set up the view on the > branch database are: > create view state_tbl ( > state_code, > state_name ) > as select > m.state_code, > m.state_name > from main:state_tbl m> > With SE I receive: > Error 554: Syntax disallowed in this database server. have you tried the following : create view state_tbl as select state_code, state_name from main:state_tbl ??? If this doesn't work, perhaps you don't have I-Net installed ? Either way, this should definitely work in both SE and Online, as long as you have the distribution product installed (I-Net for Standard Engine, I-Star for Online) Hope this helps, Richard Ridley DHL Asia Pacific