Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

oracle odbc ¶ÁÈ¡ numberÎÊÌâ

ÎÒµÄoracleÊý¾Ý¿âÓиö×Ö¶ÎÀàÐÍFD_USER_IDÊÇ number£¨38£©£¬ÎÒÓÃodbc¶ÁÈ¡Ëû£¬
ÆäÖÐCRecordset rs£»
    CDBVariant v;
    rs.GetFieldValue(FD_USER_ID, v,SQL_C_SLONG);
    ÔÚÎҵĻú×ÓÉÏ ¶Á³öÀ´µÄv.m_lVal ÊÇÕýÈ·µÄ
    µ«ÊÇÔÚÁíÍâµÄ»ú×ÓÉ϶Á Ìáʾ˵numberic out of rang
    ¸ú×ÙÁËÏ·¢ÏÖÊÇrs.GetFieldValue(FD_USER_ID, v,SQL_C_SLONG);ÖеÄSQL_C_SLONGÎÊÌâ ÓÚÊÇÎÒ»»³ÉÁË
    SQL_C_CHAR£¬¶Á³öÀ´¸úÊý¾Ý¿âµÄ²»Ò»Ñù¡£È»ºó»»³ÉSQL_C_DOUBLE Ò²ÊDz»Ò»Ñù¡£Ó¦¸ÃÔõÃ´ÅªÄØ£¬SQL_C_SLONGÔÚÎÒ»ú×ÓÉ϶¼ÊǺõİ¡ ΪʲôÔÚ±ðµÄ»ú×ÓÉϾÍÓÐÎÊÌâÁËÄØ£¬»¹ÓÐûÓÐʲô°ì·¨²»ÓÃSQL_C_SLONG ÕýÈ·¶Á³öÀ´ÄØ
ûÈ˻ذ¡

À´¸öÈ˻ؠ ÎÒ¸ø·Ö ²»ÏëÀË·Ñ


Äã²»»áÊÇodbc°æ±¾²»¶Ô°É?

ÄãÔÚSQL°æËµ:

ÕÒµ½ÎÊÌâÁË ÏÈÕû³É×Ö·û´®µÄ ³öÀ´ÔÚת¾Í¿ÉÒÔÁË

SQL_C_SLONG

javaÖÐÓиö getBigDecimal£¬¿ÉÒÔÈ¡38λÉõÖÁ¸ü¶àλµÄ¡£
¿´¿´ÄãµÄÓïÑÔÖÐÓÐûÓжÔÓ¦µÄ°¡£¿


Ïà¹ØÎÊ´ð£º

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

oracleÊý¾Ý¿â »º³å³Ø - Oracle / »ù´¡ºÍ¹ÜÀí

ÇëÎÊÕâ¸ö»º³å³ØÊÇÔõô»ØÊ°¡£¿¿ÉÒÔÁ¬½Ó»º³å³ØÀûÓÃÆäÖеÄÊý¾Ý°É£¿ÔõôÓã¿
Õâ¸öÊÇoracle×Ô¶¯×öµÄ£¬Ò»°ãÓ¦ÓóÌÐòÊDzÙ×÷²»Á˵ġ£

²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿

ÒýÓÃ
²»ÄÜÖ±½ÓÁ¬½ÓÂð£¿
²»ÄÜ

ÄÇ»º³å³ØÀïµÄÊý¾ÝÒ²²»Äܲéѯ ......

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ