PB Êý¾Ý¿âÁ¬½ÓÒÔ¼°sqlÓï¾äÔËÐÐÐÅÏ¢·µ»Ø´úÂë½âÊÍ´óÈ«
Èç¹ûÒ»¸ö SQL Óï¾ä·¢ÉúÁË´íÎó£¬ÄÇô sqlca.sqlcode ½«ÊÇ·ÇÁãÖµ¡£
Èç¹û sqlca.sqlcode СÓÚ 0 ÄÇô¾ÍÊÇ·¢ÉúÁËijÖÖÑÏÖØµÄ´íÎó£¬ÏóÊý¾Ý¿â¶¨ÒåÓë²éѯ¶¨Òå²»Ò»Öµȣ®
Èç¹û´óÓÚ 0 ÔòÊÇͨ³£µÄ´íÎó£¬Ïó±í²»°üÀ¨ËùÒªÇóµÄÐеȣ®
sqlca.sqlcode == 0£¬³É¹¦
sqlca.sqlcode == -1 ʧ°Ü £¨»ñÈ¡¾ßÌåʧ°ÜÐÅÏ¢£ºmessagebox('',"³ö´íÐÅÏ¢:"+sqlca.SQLErrText) £©--PBÀïµÄ²Ù×÷·½·¨
sqlca.sqlcode == 100, Data not found line %d.
ÕâÊÇÒ»¸ö"Õý³£µÄ"´íÎ󣬸æËßÄãÄãÕýÔÚ²éѯµÄ¶«Î÷ÕÒ²»µ½»òÕßÎÒÃÇÒѾԽ¹ýÁËÓαêµÄ·¶Î§¡£££Èç²éѯ²»µ½Ïà¹ØÐÅÏ¢µÈ
¿ÉÄÜ·¢ÉúµÄ´íÎóÁÐ±í£º
-12, Out of memory in line %d.
ͨ³£²»³öÏÖÕâ¸ö´íÎó¡£ÕâÊÇÄãµÄÐéÄâÄÚ´æºÄ¾¡µÄ±êÖ¾¡£
-200, Unsupported type %s on line %d.
ͨ³£²»³öÏÖÕâ¸ö´íÎó£®Õâ±íÃ÷Ô¤±àÒëÆ÷Éú³ÉÁËһЩ¿â£¨º¯Êý£©²»ÈϵõĶ«Î÷£®¿ÉÄÜÄãÔËÐеÄÔ¤±àÒëÆ÷ºÍµ±Ç°¿â²»¼æÈÝ£®
-201, Too many arguments line %d.
ÕâÒâζ×Å Postgres ·µ»ØÁ˱ÈÎÒÃÇµÄÆ¥Åä±äÁ¿¸ü¶àµÄ²ÎÊý£®¿ÉÄÜÄã©Á˼¸¸öINTO :var1,:var2-ÁбíÀïµÄËÞÖ÷±äÁ¿£®
-202, Too few arguments line %d.
ÕâÒâζ×Å Postgres ·µ»ØÁ˱ÈÎÒÃǵĶÔÓ¦ËÞÖ÷±äÁ¿ÒªÉٵIJÎÊý£®¿ÉÄÜÄã¶àÊäÈëÁ˼¸¸öINTO :var1,:var2-ÁбíÀïµÄËÞÖ÷±äÁ¿£®
-203, Too many matches line %d.
×ÅÒâζ×Ųéѯ·µ»ØÁ˶à¸öÐУ¬µ«ÄãÉùÃ÷µÄ±äÁ¿²»ÊÇÊý×飮ÄãÖ´ÐÐµÄ SELECT ¿ÉÄܲ»ÊÇΨһµÄ£®
-204, Not correctly formatted int type: %s line %d.
×ÅÒâζ×ÅËÞÖ÷±äÁ¿ÊÇÒ»¸ö int ÀàÐͲ¢ÇÒ Postgres Êý¾Ý¿âÀïµÄ×Ö¶ÎÊÇÁíÒ»ÖÖÀàÐÍ£¬°üº¬×ÅÒ»¸ö²»ÄÜת»»³ÉÒ»¸ö int ÀàÐ͵ÄÊýÖµ£®¿â£¨º¯Êý£©Ê¹Óà strtol ×ö´ËÀàת»»£®
-205, Not correctly formatted unsigned type: %s line %d.
×ÅÒâζ×ÅËÞÖ÷±äÁ¿ÊÇÒ»¸ö unsigned int£¨ÎÞ·ûºÅÕûÊý£©ÀàÐͶøPostgres Êý¾Ý¿âÀïµÄ×Ö¶ÎÊÇÁíÍâÒ»ÖÖÀàÐͲ¢ÇÒ°üº¬Ò»¸ö²»ÄÜת»»³Éunsigned int µÄÊýÖµ£®¿â£¨º¯Êý£©Ê¹Óà strtoul ×öÕâÀàת»»£®
-206, Not correctly formatted floating point type: %s line %d.
×ÅÒâζ×ÅËÞÖ÷±äÁ¿ÊÇÒ»¸ö float £¨¸¡µã£©ÀàÐͶø Postgres Êý¾Ý¿âÀïµÄ×Ö¶ÎÊÇÁíÍâÒ»ÖÖÀàÐͲ¢ÇÒ°üº¬Ò»¸ö²»ÄÜת»»³É float µÄÊýÖµ£®¿â£¨º¯Êý£©Ê¹Óà strtod ×öÕâÀàת»»£®
-207, Unable to convert %s to bool on line %d.
ÕâÒâζ×ÅËÞÖ÷±äÁ¿ÊÇÒ»¸ö bool £¨²¼¶û£©ÀàÐÍ£¬¶ø Postgres Êý¾Ý¿âÀïµÄ×Ö¶ÎÖµ¼È²»ÊÇ 't' Ò²²»ÊÇ 'f'¡£
-208, Empty query l
Ïà¹ØÎĵµ£º
SQL Server 2000 Êý¾Ý¿âͬ²½ÅäÖõÄÔÀí
¸´ÖƵĸÅÄî
Microsoft? SQL Server? 2000 µÄ¸´ÖÆÊÇÔÚÊý¾Ý¿âÖ®¼ä¶ÔÊý¾ÝºÍÊý¾Ý¿â¶ÔÏó½øÐи´ÖÆ
ºÍ·Ö·¢²¢½øÐÐͬ²½ÒÔÈ·±£ÆäÒ»ÖÂÐÔµÄÒ»×é¼¼Êõ¡£
ʹÓø´ÖÆ¿ÉÒÔ½«Êý¾Ý·Ö·¢µ½²»Í¬Î»Öã¬Í¨¹ý¾ÖÓòÍø¡¢Ê¹Óò¦ºÅÁ¬½Ó¡¢Í¨¹ý Internet ·Ö
·¢¸øÔ¶³Ì»òÒÆ¶¯Óû§¡£¸´ÖÆ»¹Äܹ»Ê¹Óû§Ìá¸ßÓ¦ÓóÌÐòÐÔÄÜ ......
update anketo1 set fb = substring('10',fb+1,1) WHERE id =5
ºóÀ´ÎÊÁËBM,BM˵ֱ½ÓÈ¡·´
update anketo1 set fb = ~ fb WHERE id =5
ÎÒ¸æËßÁËBMÓÃsubstringÒ²¿ÉÒÔ.
BM˵:"Õâ¼Ò»ïÀ÷º¦£¬ÕâÒ²ÄÜÏë³ö,ÕâÊôÓÚаÃÅÎ书."
×îºóÓÖÏëµ½ÓÃABSÈ¡¾ø¶ÔÖµÒ²¿ÉÒÔ
update anketo1 set fb = abs(fb-1)
ÎÒ¾õµÃ²»¹ÜÊÇʲôÎ书,ÄÜÖ ......
ÅäÖÃʹÓà SQL ServerÌṩ³ÌÐò
<configuration>
<system.web> <-- ¸ü¸ÄÌṩ³ÌÐòÅäÖ㺠-->
<membership defaultProvider="AspNetSqlProvider" />
</system.web>
<membership> <--ÅäÖÃÌṩ³ÌÐò -->
<prov ......
Ò»£ºsql loader µÄÌØµã
oracle×Ô¼º´øÁ˺ܶàµÄ¹¤¾ß¿ÉÒÔÓÃÀ´½øÐÐÊý¾ÝµÄÇ¨ÒÆ¡¢±¸·ÝºÍ»Ö¸´µÈ¹¤×÷¡£µ«ÊÇÿ¸ö¹¤¾ß¶¼ÓÐ×Ô¼ºµÄÌØµã¡£
±ÈÈç˵expºÍimp¿ÉÒÔ¶ÔÊý¾Ý¿âÖеÄÊý¾Ý½øÐе¼³öºÍµ¼³öµÄ¹¤×÷£¬ÊÇÒ»ÖֺܺõÄÊý¾Ý¿â±¸·ÝºÍ»Ö¸´µÄ¹¤¾ß£¬Òò´ËÖ÷ÒªÓÃÔÚÊý¾Ý¿âµÄÈȱ¸·ÝºÍ»Ö¸´·½Ãæ¡£ÓÐ×ÅËٶȿ죬ʹÓüòµ¥£¬¿ì½ÝµÄÓŵ㣻ͬʱҲÓÐһР......
½ñÌìÔÚһ̨Ðé»úÉϰ²×° sql server 2005£¬¾ÓÈ»±¨1´íÁË£¨ÎÞÓïÁË£¬×°Õâ¸ö¶«Î÷¶¼Åª²»ºÃ%>_<%£©¿ªÊ¼ÒÔΪÊÇÒòΪADÓòµÄÔÒò£¬ºóÀ´É¾µôÓòÓÖÖØ½¨Óò£¬È»ºóÔÙ×°£¬ÓÖ±¨2´í£¬ÓÚÊÇÎʱðÈËËÑË÷µÈµÈ£¬ÕÒµ½ÔÒòËµÒªÖØÐÂ×¢²áinstaller£¬×îÖÕ°²×°³É¹¦ÁË£¬º¦ÎÒ¼Ó°à۵쬏ßÐ˵ÄÊǰ²×°ºÃÀ²£¬¿ÉÊÇÎÒûÓÐŪÃ÷°×µ½µ×ÊÇɶÔÒòµ¼ÖÂsql°²×°²»ÁËÄØ£ ......