Delphi Êý¾ÝÀàÐÍ
Ò»¡¢ÕûÊýÀàÐÍ
ÀàÐÍ ËùÕ¼×Ö½ÚÊý È¡Öµ·¶Î§
byte 1 0-255
word 2 0-65535
shortint 1 -128-127
smallint 2 -32768-32767
integer 4 -214748648-214748467
longint 4 -214748648-214748467
cordinal 4 0-2147483647
¶þ¡¢ÊµÊýÀàÐÍ
ÀàÐÍ Ëùµã×Ö½ÚÊý È¡Öµ·¶Î§
Real 6 ±2.9×10µÄ¸º39´Î·½µ½1.7×10µÄ38´Î·½
Single 4 ±1.1×10µÄ¸º45´Î·½µ½1.1×10µÄ38´Î·½
double 8 ±5.0×10µÄ¸º324´Î·½µ½1.7×10µÄ308´Î·½
extended 10 ±3.4×10µÄ¸º4932´Î·½µ½1.1×10µÄ4932´Î·½
Comp 8 -263-262
Èý¡¢×Ö·ûÀàÐÍ
×Ö·ûÀà Ëùµã×Ö½ÚÊý ÈÝÄÉ×Ö·û·¶Î§
ansichar 1 Ò»¸öASCii×Ö·û
widechar 2 Ò»¸öµ¥´úÂë×Ö·û
Char 1 Ò»¸öASCII×Ö·û
ËÄ¡¢×Ö·û´®ÀàÐÍ
ÀàÐÍ ÈÝÄÉÀàÐÍ ÊÇ·ñÒÔ¿Õ×Ö½Ú½áÊø ³¤¶È·¶Î§
shortstring Char ·ñ 255
ansistring Char ÔÊÐí Ô¼3GB
string Char ²»ÏÞ 255»ò3GB
widestring widechar ÔÊÐí Ô¼1.5GB
Îå¡¢²¼¶ûÀàÐÍ
ÀàÐÍ ·¶Î§ Ëùµã×Ö½ÚÊý
bool ×Ö 2
boolean Ò»×Ö½Ú 1
bytebool ×Ö½Ú 1
wordbool ×Ö 2
longbool Ë«×Ö½Ú 4
Ïêϸ°æ£º
(1) »ù±¾Êý¾ÝÀàÐÍ£º
a¡¢ ÕûÊýÀàÐÍ£º (ͨÓÃÀàÐÍ<32λ>£ºInteger£ÓзûºÅ£»Cardinal£ÎÞ·ûºÅ)
¾ßÌ壺
ÓзûºÅ£ºShortint<8λ>£¬Smallint<16λ>£¬Longint<32λ >
ÎÞ·ûºÅ£ºByte<8λ>£¬Word<16λ>£¬LongiWord<32λ >
b¡¢×Ö·ûÀàÐÍ£º (ͨÓÃÀàÐÍ<8λ>£ºChar £ÓëAnsiCharµÈͬ)
¾ßÌ壺
AnsiChar<8λ> £ºÖ÷Òª´æ·ÅAnsi×Ö·û
WideChar<16λ>£ºÖ÷Òª´æ·ÅUnicode×Ö·û
c¡¢²¼¶ûÀàÐÍ£º (ͨÓÃÀàÐÍ<8λ>£ºBoolean£ÓëByteBoolµÈÍ
Ïà¹ØÎĵµ£º
´ó¼Ò¶¼ÈÏΪ£¬CÓïÑÔÖ®ËùÒÔÇ¿´ó£¬ÒÔ¼°Æä×ÔÓÉÐÔ£¬ºÜ´ó²¿·ÖÌåÏÖÔÚÆäÁé»îµÄÖ¸ÕëÔËÓÃÉÏ¡£Òò´Ë£¬ËµÖ¸ÕëÊÇCÓïÑÔµÄÁé»ê£¬Ò»µã¶¼²»Îª¹ý¡£Í¬Ê±£¬ÕâÖÖ˵·¨Ò²ÈúܶàÈ˲úÉúÎó½â£¬ËƺõÖ»ÓÐCÓïÑÔµÄÖ¸Õë²ÅÄÜËãÖ¸Õë¡£Basic²»Ö§³ÖÖ¸Õ룬Ôڴ˲»ÂÛ¡£Æäʵ£¬PascalÓïÑÔ±¾ÉíÒ²ÊÇÖ§³ÖÖ¸ÕëµÄ¡£´Ó×î³õµÄPascal·¢Õ¹ÖÁ½ñµÄObject Pascal£¬¿ÉÒÔ˵ÔÚÖ¸ÕëÔËÓ ......
ÔÚDelphiÖÐʹÓÃRASʵÏÖ¶Ôϵͳ²¦ºÅµÄ¿ØÖÆ
ÔÚÆóÒµÓ¦ÓÃÖÐÓÐʱºòÏ£ÍûÄÜÔÚ³ÌÐòÖÐʵÏÖ¶Ô²¦ºÅÍøÂçµÄ¿ØÖÆ£¬ÒÔʵÏÖ×Ô¶¯²¦ºÅ¡¢×Ô¶¯¶Ï¿ªÍøÂç¡£ÔÚ³¢ÊÔÁ˶àÖÖ·½Ê½Ö®ºó£¬ÈÏΪRASÊÇÒ»ÖֱȽÏÎȶ¨µÄ·½Ê½¡£ÔÚgoogleÁËÍøÉÏһЩ×ÊÁϺó£¬ÏÖÕûÀíÈçÏ£º
Ò»¡¢Ê×ÏÈÐèÒªÓиöÕë¶ÔRASµÄÍ·Îļþ¶¨Ò壬Ras.pas´úÂëÈçÏÂ
{* Cop ......
DECLARE
TYPE TY_QUECUR IS REF CURSOR;
CUR_COLUMNS TY_QUECUR;
SQLCMD VARCHAR(500);
TABNAME VARCHAR(20);
COLNAME VARCHAR(50);
COLTYPE VARCHAR(20);
COLCOMMENT VARCHAR2(50);
COLLENGTH INTEGER;
COLPRECISION INTEGER; ......
ʲôÊÇÁ÷£¿Á÷,¼òµ¥À´Ëµ¾ÍÊǽ¨Á¢ÔÚÃæÏò¶ÔÏó»ù´¡ÉϵÄÒ»ÖÖ³éÏóµÄ´¦ÀíÊý¾Ý
µÄ¹¤¾ß¡£ÔÚÁ÷ÖУ¬¶¨ÒåÁËһЩ´¦ÀíÊý¾ÝµÄ»ù±¾²Ù×÷£¬Èç¶ÁÈ¡Êý¾Ý£¬Ð´ÈëÊý¾ÝµÈ£¬
³ÌÐòÔ±ÊǶÔÁ÷½øÐÐËùÓвÙ×÷µÄ£¬¶ø²»ÓùØÐÄÁ÷µÄÁíһͷÊý¾ÝµÄÕæÕýÁ÷Ïò¡£Á÷²»
µ«¿ÉÒÔ´¦ÀíÎļþ£¬»¹¿ÉÒÔ´¦Àí¶¯Ì¬ÄÚ´æ¡¢ÍøÂçÊý¾ÝµÈ¶àÖÖÊý¾ÝÐÎʽ¡£Èç¹ûÄã¶Ô
Á÷µÄ²Ù×÷·Ç³£ÊìÁ·£¬ÔÚ³ ......