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( ) <&
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£
win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£
µ±È»Äã×î ......
MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()
SQL code:
sqlÀïÊÇ£º
getdate()
ÒýÓÃ
now()
ѧϰ
SQL code:
select now();
SQL code:
TODAY()
?
SQL code:
select now();
/* ......
¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿
1 nike 100 ϵͳʱ¼ä
2 nike 300 &n ......
ÇëÎÊһϴó¼ÒÓÐûÓÐÈËÅäÖùýmysqlµÄiniµÄÅäÖÃÎļþ£¬ÏÖÔÚÎÒÓÐÒ»¸öÎÊÌâ¾ÍÊÇ.ÏÖÔÚ±íÖÐ35ÍòÌõµÄÊý¾Ý²éѯ³öÀ´ÊÇûÓÐÎÊÌâµÄ£¬µ«Êǵ±Êý¾Ý¿â´ïµ½°ÙÍòÒÔÉÏÊý¾Ý¾Í²éѯ²»³öÀ´ÁË£¬£¨Ç°ÌáÊÇͬÑùµÄÌõ¼þÀ´×öÕâÁ½´ÎÊý¾Ý²éѯ² ......
ÓÐÒ»ÌõsqlÓï¾ä select a.name ,b.name from tableA a,tableB b where a.id = b.id and ¡£¡£¡££¨ÆäËû¹ýÂËÌõ¼þ£©
ÆäÖÐa.id ΪtableAÖ÷¼ü ÓÐΨһÐÔË÷Òý Êý¾ÝÁ¿²Å1ǧ¶à
b.id ΪÈÕÖ¾±ítableB µÄÍâ¼ü £¬ÂýÈ¥Ìõ¼þµÄ²Å ......