Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Multi-DBMS report
HI, I'm using an application which connects to Sybase and Oracle databases (same model). It uses crpe32.dll to launch crystal report (7.0) at runtime. To ensure designing the same file ".rpt" for both databases, I use PELogOnServer function and pass P2SSYB10.DLL or P2SORA7.DLL as first...- morsi
- Thread
- Replies: 0
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Drop Index
Hi, I would like to drop index in a databse different from the current db. In creation the syntax "create index index_name on dbname_db..table_name(..)" is ok but "drop index dbname_db..table_name.index_name" don't work ? Besides, deleting line from sysindexes isn't possible...- morsi
- Thread
- Replies: 4
- Forum: Sybase: Adaptive (SQL) Server
-
Sybase Error Message
Hi, How to get Sybase Error Message in a procedure. With @@error, i can only get the description in master..sysmessages but i want to insert the full message (formatted with the right objects) in a table of log. Thanks- morsi
- Thread
- Replies: 2
- Forum: Sybase: Adaptive (SQL) Server
-
A Simpe Join Which Madden Quey Optimiser
Hello, I'm looking a strange behaviour on my Sybase 12.5 when executing a simple query : select T.* from TABLE1 T, TABLE_JOB J where J.SESSID = 0 and T.ELEMENTID = J.ELEMENTID TABLE1 is a table of 80.000 rows, have an non-custered index on ELEMENTID TABLE_JOB is a table of 1 to 100 rows, have...- morsi
- Thread
- Replies: 3
- Forum: Sybase: Adaptive (SQL) Server
