Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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( ) <&


Ïà¹ØÎÊ´ð£º

apache+PHP+mysqlÔÚwin7ÏÂʹÓÃ

ÈçÌ⣬ÕâÈý¸öÔÚwin7ÏÂʹÓûáÓÐʲô¼æÈÝÐÔÎÊÌâÂð£¿
ÓÉÓÚÎÒ×î½üÔÚʹÓÃwin7£¬¾ÍÀÁµÃ½øxpÁË£¡
×Ô¼ºÓÃwindows 2008ÓÐÒ»Äê¶àÁË£¬Ã»³öÏÖÈκÎÎÊÌâ¡£

win7²âÊÔ°æÒ²Óùý£¬²»»áÓÐʲôÎÊÌâµÄ£¬·ÅÐÄ¡£

µ±È»Äã×î ......

MySqlÎÊÌâ

MySqlÖвåÈ뵱ǰʱ¼äµÄ¸ÃÔõôд°¡£¿
now()

SQL code:

sqlÀïÊÇ£º
getdate()

ÒýÓÃ
now()


ѧϰ

SQL code:
select now();

SQL code:
TODAY()
?

SQL code:
select now();
/* ......

mysql ¼òµ¥ÎÊÌâ

¼ÙÈçÊý¾Ý¿âÖÐÓиötest±í£¬±íÖÐÓÐid£¬Name£¬num£¬¼Ç¼ʱ¼ä
idΪ×ÔÔö³¤Ö÷¼ü£¬nameÊÇÃû×Ö£¬num±íʾÆäÊýÁ¿

1  nike  100        ϵͳʱ¼ä
2  nike  300  &n ......

mysqlÉÏÏÞÎÊÌâ

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

Çë½ÌÒ»¸ö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ºÅ