µoªí¤H |
¤º®e |
¥DÃD: ¦p¦ó§ó§Ö¨Çupdate¤j¶q¬ö¿ý |
smithjoe
¦^ÂÐ: 13
Æ[¬Ý: 8978
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¤Q¤@¤ë 30, 2015 4:41 pm ¥DÃD: ¦p¦ó§ó§Ö¨Çupdate¤j¶q¬ö¿ý |
¥i´£¥Üupdate 5000µ§¬ö¿ýªº¼gªk? |
¥DÃD: ¦p¦ó§ó§Ö¨Çupdate¤j¶q¬ö¿ý |
smithjoe
¦^ÂÐ: 13
Æ[¬Ý: 8978
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤@ ¤Q¤@¤ë 30, 2015 4:18 pm ¥DÃD: ¦p¦ó§ó§Ö¨Çupdate¤j¶q¬ö¿ý |
±z¦n:
§Ú¦³ÓDBF¦³150¸Uµ§¬ö¿ý(¬ù1.5GB).....
·í¤¤§Ú·Qupdate5000µ§¬ö¿ý, ¦p¤U...
update salestran set cinput = '20151112' where sales_id = 'A7089321'
§Úcopy¤F©Ò¦³update statementÓprg¥hupdate, ¦ý¨ ... |
¥DÃD: VFP - datetimeÅܦ¨character |
smithjoe
¦^ÂÐ: 2
Æ[¬Ý: 3417
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤G ¤Q¤@¤ë 10, 2015 6:09 pm ¥DÃD: VFP - datetimeÅܦ¨character |
±z¦n,
§Ú·Q§âDBF¤¤¤@Ómod_time(datetime()Åܦ¨character(26):
²{®É:
"12/20/2007 09:46:19 PM"
Åܦ¨:
"2007-12-20-21.46.19.000000"
("/"Åܦ¨"-", ¤¤¶¡ªÅ®æÅܦ¨"-")
¥i¥H«ç»ò¿ì??
ÁÂ!! |
¥DÃD: ¦p¦ó¦bvfp9ªºformÅÜ°µEXE? |
smithjoe
¦^ÂÐ: 7
Æ[¬Ý: 5662
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤Q¤ë 28, 2015 3:50 pm ¥DÃD: ¦p¦ó¦bvfp9ªºformÅÜ°µEXE? |
§Ú¹Á¸Õ¤U¦C°µªk:
1. Tools -> Class browser -> Open -> "select the form (abc.scx)" -> view class code -> "copy program"
2. New a pproject -> Add new program -> "Paste program code ... |
¥DÃD: ¦p¦ó¦bvfp9ªºformÅÜ°µEXE? |
smithjoe
¦^ÂÐ: 7
Æ[¬Ý: 5662
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤Q¤ë 28, 2015 2:26 pm ¥DÃD: ¦p¦ó¦bvfp9ªºformÅÜ°µEXE? |
±z¦n,
§Ú¦bvfp9°µ¤F±iform, ¦³checkbox, form button, «öbutton·|processing, ³Ì«á·|¦³messagebox....
¦]¬°·Q©ñ±iform¨ì¥t¥~¤@³¡¨S¦³vfpªºPC¥h¹B¦æ, ½Ð°Ý¦p¦ó¦bvfp9ªºformÅÜ°µEXE?
ÁÂ!!! |
¥DÃD: Field <name> does not accept null value |
smithjoe
¦^ÂÐ: 8
Æ[¬Ý: 8304
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤Q¤ë 16, 2015 4:58 pm ¥DÃD: Field <name> does not accept null value |
¦^ckp6250:
¥Î¤F append from v_cur_vfp_abc , ¥X¤F'File c:\foxpro\v_cur_vfp_abc.dbf' does not exist
¦^syntech:
¥ý«e§Ú¦b[¸ê®Æªí®æ³]p¤u¨ã] ¤¤¿ï¨ú NULL ®Ö¨ú¤è¶ô (»PORACLE Äæ¦ì "ALLOW NULL" ¬Û¦P), ¹B¦ ... |
¥DÃD: Field <name> does not accept null value |
smithjoe
¦^ÂÐ: 8
Æ[¬Ý: 8304
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¥| ¤Q¤ë 15, 2015 4:56 pm ¥DÃD: Field <name> does not accept null value |
±z¦n,
§Ú¥´ºâ¥Ñoracle©â30 table ªºdata¥hvfp dbf, syntax¦p¤U:
==================================
USE vfp_abc exclusive
ZAP
CLOSE TABLES
SQLEXEC(gnConnHandle, "SELECT * from oracle_abc where mod_ti ... |
¥DÃD: vfp9 - Alias is not found |
smithjoe
¦^ÂÐ: 6
Æ[¬Ý: 6208
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤E¤ë 18, 2015 5:11 pm ¥DÃD: vfp9 - Alias is not found |
Á¤j¤j, ¾ÇÀ´¤F..... |
¥DÃD: vfp9 - Alias is not found |
smithjoe
¦^ÂÐ: 6
Æ[¬Ý: 6208
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤E¤ë 18, 2015 11:33 am ¥DÃD: vfp9 - Alias is not found |
·Q°µªº¬Ov_cur_vfp_abcÀx¦soracle data, select vfp_abc ¤§«á append ¥Ñv_cur_vfp_abc¥hvfp_abc, ¦ó¦p¦ó¸Ñ¨M©O??
ÁÂ! |
¥DÃD: vfp9 - Alias is not found |
smithjoe
¦^ÂÐ: 6
Æ[¬Ý: 6208
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤E¤ë 18, 2015 10:42 am ¥DÃD: vfp9 - Alias is not found |
ÁÂsyntech,
½Ð°ÝÀ³©ñ¦bSQLEXEC«e or APPEND«e©O??
ÁÂ!! |
¥DÃD: vfp9 - Alias is not found |
smithjoe
¦^ÂÐ: 6
Æ[¬Ý: 6208
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤ ¤E¤ë 18, 2015 10:20 am ¥DÃD: vfp9 - Alias is not found |
±z¦n,
§Ú¥´ºâ¥Ñoracle©â30 table ªºdata¥hvfp dbf, syntax¦p¤U:
==================================
USE vfp_abc exclusive
ZAP
CLOSE TABLES
SQLEXEC(gnConnHandle, "SELECT * from oracle_abc where mod ... |
¥DÃD: ¿ï¨úOracle table¤¤ªºdate field¥hVFP§@¤ñ¸ûªº°ÝÃD |
smithjoe
¦^ÂÐ: 6
Æ[¬Ý: 5734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤E¤ë 09, 2015 5:10 pm ¥DÃD: ¿ï¨úOracle table¤¤ªºdate field¥hVFP§@¤ñ¸ûªº°ÝÃD |
ÁÂsyntech,
¨ä¹ê§Ú¤£¤°¾é¸Ñªº¬O¦p¦ó¥ÑSQLEXEC PASS VALUE¥hVARIABLE....
¥i§_¸Ñµª¦p¤U:
1. ¥ÎSQLEXEC(gnConnHandle, + SELECT STATMENT + CURSOR), ¹ï¶Ü?
2. SQLEXEC ¥u·|pass 0 or 1 return code ¥hVARIABLE ... |
¥DÃD: ¿ï¨úOracle table¤¤ªºdate field¥hVFP§@¤ñ¸ûªº°ÝÃD |
smithjoe
¦^ÂÐ: 6
Æ[¬Ý: 5734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤E¤ë 09, 2015 4:16 pm ¥DÃD: ¿ï¨úOracle table¤¤ªºdate field¥hVFP§@¤ñ¸ûªº°ÝÃD |
ÁÂsyntech,
¥H¤Ustatement¦³syntax error, ¦p¦óªÈ¥¿©O?
year()=SQLEXEC(gnConnHandle, 'SELECT business_time FROM time_server', 'cusor_time')
if year()='2015' then
messagebox("GO")
else
message ... |
¥DÃD: ¿ï¨úOracle table¤¤ªºdate field¥hVFP§@¤ñ¸ûªº°ÝÃD |
smithjoe
¦^ÂÐ: 6
Æ[¬Ý: 5734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤E¤ë 09, 2015 12:03 pm ¥DÃD: ¿ï¨úOracle table¤¤ªºdate field¥hVFP§@¤ñ¸ûªº°ÝÃD |
¦p¦ó©â¥Xbusiness time ¤¤ªº¦~«×°µ¤ñ¸û?
¨Ò¦p, business time ¬O2015/01/01, ¦p¦ó©â¥X"2015"¥h¤@Óvariable?
ÁÂ! |
¥DÃD: ¿ï¨úOracle table¤¤ªºdate field¥hVFP§@¤ñ¸ûªº°ÝÃD |
smithjoe
¦^ÂÐ: 6
Æ[¬Ý: 5734
|
ª©±: VFP °Q½×°Ï µoªí©ó: ¬P´Á¤T ¤K¤ë 12, 2015 4:35 pm ¥DÃD: ¿ï¨úOracle table¤¤ªºdate field¥hVFP§@¤ñ¸ûªº°ÝÃD |
±z¦n¡A
§Ú·Q¿ï¨ú¨ä¤¤¤@ÓOracle table¤¤ªºdate field data¥h§@¤ñ¸û, ¦p:¡@oracle date data > 31/12/2014, °õ¦æ¡@function xxx, else, °õ¦æ¡@function yyy....
¤U¦C¬O¿ï¨úOracle table¤¤ªºdate fieldªºco ... |
|