Re: Synonyms - again

In <287gtvINNoou@emory.mathcs.emory.edu> jparker@hpbs2561.boi.hp.com (Jack Parker) writes: >Ladies, Gentlemen, honoured members of the net, >We have a cinnamon which goes from one engine on one platform to another on >another. >Last week we had a -934 (connection no longer valid) which turned out to >be because we had an index on a varchar field. So 'we' changed the columns >in question to char. I don't know if 'we' re-created the index or not. >Today suddenly we get -387 (No connect permission) for this cimmanon. After >some this and that it turns out that the sillymon had to be dropped and >re-created - at which point all was well. > Q1) how did this happen? does a simynum work based on tabid or on the > character name? Don't know. SE uses tabid. OnLine uses tabid for local tables, server name + database name + owner name + table name for remote tables. Did you rebuild the table in such a way that the owner name changed perhaps? (seems unlikely!) > Q2) is this a documented feature that I missed will STFM (Skimming ...)? The above is documented (Guide to SQL: Reference 2-23). > Q3) depends on your fiscal year - it may actually start in September. Maybe it was a sillyman playing with the sillymon. > Q4) I have no more questions your honour(s). That's good, I have no answers. >cheers >j. - the solomon kid. graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.