Linux -Blue forest free software | Return to home page | Site Map | Search WWW | Contact Us |
Your current position : Homepage > Free Software > Technological exchanges >Database


    

Blue Forest http://www.lslnet.com at 11:08 on July 8, 2006


Generate database objects DDL ASE 12.5 database so wrong!

I use Sybase System central tool for database objects in the database so Generate DDL suggested :

Server massage number:209
Ambiguous column name crdate!

The database is ASE 12.5
Which know what it is?

Generate database objects DDL ASE 12.5 database so wrong!

Is still on the table or database trigger so Generate DDL?
Which carries a crdate you? Table there is no view that, like the Eastern trigger? Check bars, which is estimated procedure Lane view or trigger an order or a problem, even up two tables, two tables have crdate Field
You can step Generate, first of all tables, and then view, procedure, trigger, select further problems

Generate database objects DDL ASE 12.5 database so wrong!

Of the database, there are too many forms, and checks will either. I found a bit on the Internet, was also encountered the same problem, meaning they can return the old version CENTRAL problems with future versions 12.5, I also find hard to find a half-day.
Re : ambiguous column name crdate

--------------------------------------------------------------------------------

Liza AS wrote :
  >;
"; Hi.
  >;
"; I try to generate the ddl and receive this error. What
"; Should I do?
  >;
"; Thanks in advance.


In 12.5, a "crdate" field was added to sysindexes. Queries doing a join
Between sysobjects and sysindexes that did 't specify the source of the
Crdate field will raise this error. This is a particular problem using
Central against older versions of Sybase ASE 12.5. If that is what you
Are
Using, install a 12.5 version of Sybase Central.

-bret



 Privacy Policy  Copyright © 1999-2000 LSLNET.COM. All rights reserved. Blue Forest website owners. E-mail : Webmaster@lslnet.com