home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Chip 2001 May
/
W2KPRK.iso
/
apps
/
InternetScanner
/
data1.cab
/
Crystal_Files
/
Crystal
/
p2sifmx.dll
/
string.txt
next >
Wrap
Text File
|
1999-11-22
|
3KB
|
119 lines
80 Crystal Reports
100 SELECT tabname, owner FROM systables WHERE tabid > 0
101 ;
102 sp_tables
103 SELECT a.name, c.name, a.type FROM sysusers c, sysobjects a WHERE a.uid = c.uid
104 SELECT name FROM sysdatabases
106 SELECT syscolumns.name, syscolumns.type, syscolumns.length
107 No default database defined. Please specify a database name
108 256
109 8
110 _
111 AND owner LIKE
112 AND tabname LIKE
113 AND tabtype IN
114 SELECT COUNT(*) FROM systables WHERE tabid > 0
115 SELECT COUNT(*) FROM sysusers c, sysobjects a WHERE a.uid = c.uid
116 SELECT COUNT (*)
117 Database Not Found
118 Warning: %d table names will be returned.\nProceed?
119 Allow Reporting On
120 Unable To Connect to SQL Server %s
128 AND tabid BETWEEN 1 AND 24
129 AND tabid >= 100
130 SELECT procname, owner FROM sysprocedures WHERE mode IN ('D','O','P')
131 ;
132 AND procname LIKE
133 COUNT(*)
134 select data from informix.sysprocbody where datakey = 'T' and seqno = 1
135 and procid = (select procid from informix.sysprocedures where informix.sysprocedures.procname = '%s')
136 EXECUTE PROCEDURE
137 sysmaster
200 3
201 4
202 5
203 7
204 8
205 9
206 10
207 11
300 = Equal Join
301 = Left Outer Join
302 = Right Outer Join
303 > Greater Join
304 < Less Join
305 >= Greater Or Equal
306 <= Less Or Equal
307 != Not Equal Join
400 =
401 =
402 =
403 =
404 =
405 =
406 =
407 >
408 <
409 >=
410 <=
411 !=
1000 HEX\n11\n1\n7\n0
1200 ABS\n7\n1\n7\n0
1201 MOD\n7\n2\n7\n7\n0
1202 POW\n7\n2\n7\n7\n0
1203 ROOT\n7\n1\n7\n8
1204 ROUND\n7\n1\n7\n8
1205 SQRT\n7\n1\n7\n0
1206 TRUNC\n7\n1\n7\n8
1207 COS\n7\n1\n7\n0
1208 SIN\n7\n1\n7\n0
1209 TAN\n7\n1\n7\n0
1210 ASIN\n7\n1\n7\n0
1211 ACOS\n7\n1\n7\n0
1212 ATAN\n7\n1\n7\n0
1213 ATAN2\n7\n2\n7\n7\n0
1214 EXP\n7\n1\n7\n0
1215 LOGN\n7\n1\n7\n0
1216 LOG10\n7\n1\n7\n0
1400 LENGTH\n4\n1\n11\n0
1401 OCTET_LENGTH\n4\n1\n11\n0
1402 CHAR_LENGTH\n4\n1\n11\n0
1403 CHARACTER_LENGTH\n4\n1\n11\n0
1404 TRIM\n11\n1\n11\n0
1600 USER\n11\n0\n4
1601 DBSERVERNAME\n11\n0\n4
1602 SITENAME\n11\n0\n4
1603 TODAY\n9\n0\n4
1604 CURRENT\n15\n0\n4
1800 DATE\n9\n1\n255\n0
1801 DAY\n4\n1\n255\n0
1802 MONTH\n4\n1\n255\n0
1803 YEAR\n4\n1\n255\n0
1804 WEEKDAY\n4\n1\n255\n0
1805 MDY\n9\n3\n4\n4\n4\n0
2000 AVG\n7\n1\n255\n1
2001 MAX\n250\n1\n255\n1
2002 MIN\n250\n1\n255\n1
2003 SUM\n250\n1\n255\n1
2004 COUNT\n4\n1\n255\n1
2005 RANGE\n250\n1\n255\n0
2006 STDEV\n7\n1\n255\n0
2007 VARIANCE\n7\n1\n255\n0
4048 SQL Command Failed
4304 SELECT
4305 FROM
4306 WHERE
4307 systables
4308 sysprocedures
4309 tabid >= 100 AND tabtype IN ('T')
4310 tabid >= 100 AND tabtype IN ('V')
4311 tabid >= 100 AND tabtype IN ('S', 'P')
4312 tabid BETWEEN 1 AND 24
4313 mode IN ('D', 'O', 'P')
4314 AND procname LIKE
4315 tabname, owner
4316 procname, owner
4317 Login Error
4318 The procedure definition contains an error. Precision cannot be smaller or equal to the number of decimals.
4319 The procedure definition contains an error.