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

PB11ͨ¹ýODBCÁ¬MYSQLÎÊÌ⣬¸ßÊÖ°ïæ

PB ͨ¹ýODBC Á¬½ÓMYSQL £¬×öÁ˸öС³ÌÐò ´ÓSQLSERVER Êý¾Ý¿â¶Á³öÊý¾ÝÔÙ²åÈëµ½MYSQL Êý¾Ý¿â
ÓÃDATAWINDOW ·½Ê½ºÍ SQL Óï¾ä·½Ê½¶¼ÊÔ¹ý£¬DATAWINDOWµÄUPDATE ºÍSQLÓï¾ä¶¼Ã»·µ»Ø´íÎó£¬COMMIT Ò²Õý³£
¾ÍÊÔÊý¾ÝûÓÐͬ²½¹ýÈ¥£¬
ÓеĵçÄÔ¿ÉÒÔ£¬ÓеIJ»ÐУ¬¿ÉÒԵĵçÄÔÊÇ×°¹ýPB11.5µÄ£¬µ«ÓÐЩװ¹ýPB11.5Ò²²»ÐÐ
ÊDz»ÊdzÌÐòµÄÔËÐл·¾³²»¶Ô
DLLÈçÏ£º
atl71.dll£¬API_COM.DLL£¬gdiplus.dll£¬libjcc.dll£¬libjutils.dll£¬msvcp71.dll£¬MSVCR71.DLL£¬PBADO115.DLL£¬
pbdpl115.DLL£¬PBDWE115.DLL£¬pbdwo115.dll£¬PBODB115.DLL£¬PBRTC115.DLL£¬PBRTH115.DLL£¬PBSHR115.DLL£¬
pbtra115.dll£¬PBVM115.DLL
PB 11.5 3127°æ±¾

·Ö²»¹»¿ÉÒÔ¼Ó
ÊDz»ÊÇÄãµÄÊý¾Ý¿âÎļþÊÇÖ»¶ÁµÄ£¿

ûÓзµ»Ø´íÎó£¬ÄãÊÇÖ¸sqlca.sqlcodeµÄֵΪ0Âð£¿

Êý¾Ý¿âÎļþҲûֻ¶Á£¬SQLCA.SQLCODE ÊǵÈÓÚ0µÄ


¾ßÌå´úÂëÊÇÔõôÑùµÄ

dd

Long ll_row,ll_rowcount,ll_msgrow,ll_transrow
DateTime ldt_xgrq
n_trans_client ln_client
n_trans_server ln_server

datastore lds_Max
DataStore lds_destination
dataStore lds_source

ln_client = Create n_trans_client
ln_server = Create n_trans_server

lds_max = Create datastore
lds_destination = Create datastore
lds_source = Create datastore
of_setmsg( 0, "¿ªÊ¼Í¬²½ÉÌÆ·×ÊÁÏ,¿ªÊ¼Ê±¼ä:" + String(now(),"hh:mm:ss"),"")

//Á¬½Óµ½±¾µØÊý¾Ý¿â
If ln_client.of_connectdb( ) <&


Ïà¹ØÎÊ´ð£º

mysql µ¼ÖÂËÀ»ú

»·¾³£ºwin2003 apache2 resin3 php5 mysql5
mysql´íÎóÀï³öÏÖÕâ¸ö£¬·þÎñÆ÷Ö±½ÓËÀµ½ÄÇÀï¡£
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_log ......

mysqlÉÏÏÞÎÊÌâ

  ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......

mysql like ÎÊÌâ

select * from table where '123456789' like '%'+×ֶαí+'%'


Õâ¾äsqlÔÚsqlserverÏÂͨ¹ý£¬ÔÚmysqlÏÂÓб¨´í£¬mysqlÏÂÈçºÎʵÏÖÕâÑùµÄ²éÑ¯ÄØ
SQL code:
select * from table whe ......

eclipseÓëmySQLµÄÎÊÌâ - Java / Eclipse

ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......

Çë½ÌÒ»¸ömysqlÁ©±íÁ¬½ÓµÄÎÊÌâ

ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ