Re: how to define remote server's table

On 1月22日, 下午6時29分, "Superboer" <superbo...@t-online.de> wrote: > try: > > create synonym in local db:> > dbaccess db1 <<! > create synonym mysystables for db2@remote:systables;> ! > > then in 4gl use mysystables. > > Superboer. > > r...@star2000.com.tw schreef: > > > Hi , > > I had to connect to the remote database in 4gl . > > local server&db is : db1@local > > remote server & db is : db2@remote > > > in 4gl program : > > $ cat test.4gl > > database db1 > > main > > define q record like db2@remote:systables.*> > end > > It won't pass the compile . > > How should I solve this problem ? I had test this program deeply. I have two box : A box: ids10.FC5 4gl 7.32.FC2 B box : ids7.31.FD2 4gl 7.20.UD7 If the remote server is A box , compiling will failed. For example : $ cat test.4gl database db1 main define q record like db2@remote:systables.*end db1 = B box (ids 7.3) db2 = A box (ids10) error list here: | The symbol "db2@remote:systables" is not the name of a table in the | specified database. | See error number -4320. All of the 4gl program used to run OK on B box until migrating to A box. There are a lot of program embedded these kind of commands, It's tough to modify to synonym table. Anyone occurred this before ? How should I solve this ? Any help will be appreciated!