|
VFP ·R¥ÎªÌªÀ°Ï ¥»°Q½×°Ï¬° Visual Foxpro ·R¥ÎªÌ¸gÅç¥æ¬yªº¦a¤è, ½Ð¦h¦h§Q¥Î"·j´M"ªº¥\¯à, ¥ý¬d¬Ý¬Ý¦³µL«e¨Ò¥i´`, ¦pªGÁÙ¦³¤£À´ªº¦Aµo°Ý. ³¡¥÷¥DÃD¦³ªþ¥[ÀÉ®×, ¶·¥ýµù¥U¦¨¬°ªÀ°Ï©~¥Á¤~¥i¥H¤U¸ü.
|
¤W¤@½g¥DÃD :: ¤U¤@½g¥DÃD |
µoªí¤H |
¤º®e |
forever8888
µù¥U®É¶¡: 2023-12-14 ¤å³¹: 10 ¨Ó¦Û: ®ç¶é¤K¼w
²Ä 1 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤¤ë 03, 2024 10:27 am ¤å³¹¥DÃD: form Äæ¦ì·s¼W¸j©w |
|
|
¤é«e¦]¬°»Ýn¡A©Ò¥H¦b¤@Óform¤W±·s¶}¤F¤@Ócheckbox¡Asql¨ºùؤ]¥[¤J¹ïÀ³ªºÄæ¦ì¡A³]©w¦n¤§«á´ú¸Õok¥i¥HÀx¦s¸ÓÄæ¦ìªº¤Ä¿ïª¬ºA(0 or 1)¡C
¦ý¤µ¤Ñµo²{·s¼W¸ê®Æªº®É«á
·|¥X²{ µLªk´¡¤J NULL Ȩì table.id ¡A¸ê®Æ¦æ¤£±o¦³NULL
¦¹form¼W§R§ïªº¤èªk¬Ý°_¨Ó¬O¨Ï¥Î¸òdbcÀɮ׳sµ²¡A¦Û°Ê¸j©wÄæ¦ì¡A¦Ó·s¼Wªº®ÉÔ·|¦Û°Ê²£¥Í¤@¦ê¼Æ¦rµ¹id¨Ï¥Î¡A¥B쥻·s¼Wªº¾÷¨î³£¬O¥¿±`ªº¡A
¥Ø«e½T©w¹L¬O¦]¬°¥[¤J¤F³oÓÄæ¦ì¤§«á¦Ó¾ÉP²{¦b¥X²{³oÓ¿ù»~(sql¸òform¨ºùØ®³±¼·sÄæ¦ì´N«ì´_¤F)¡A¦ý¥Ñ©ó쥻ªºµ{¦¡¤£¬O§Ú¼gªº¡A©Ò¥H¦³ÂI¤£ª¾¹D¬O¥i¯àþ¸Ì¥X¤F°ÝÃD¡A¬G·Q¤W¨Ó½Ð±Ð¦U¦ì¤j¤j¡AÁÂÁÂ
¦P®É¤]¦b·Q¤@Ó°ÝÃD¡A·|¤£·|insert¸òdbcªº¸j©w¨S¦³ÃöÁp©O?
¦]¬°¦bdbc¤¤table.view¤¤¬Ý¨ì¸Ì±ªº«ü¥O¬O
DBSetProp(ThisView+".cross_month","Field","DataType","L")
DBSetProp(ThisView+".cross_month","Field","UpdateName","dbo.vcust.cross_month")
DBSetProp(ThisView+".cross_month","Field","KeyField",.F.)
DBSetProp(ThisView+".cross_month","Field","Updatable",.T.)
¦ü¥G¨S¦³¬Ý¨ìinsert¬ÛÃöªº°T®§ _________________ ¤j®a¦n¡A§Ú¬O¤E§À¤H¬W¤O¡AµL¤÷µL¥À¤@®e¾¹ |
|
¦^³»ºÝ |
|
|
forever8888
µù¥U®É¶¡: 2023-12-14 ¤å³¹: 10 ¨Ó¦Û: ®ç¶é¤K¼w
²Ä 2 ¼Ó
|
µoªí©ó: ¬P´Á¤ ¤¤ë 03, 2024 2:49 pm ¤å³¹¥DÃD: °ÝÃD¤w¸Ñ¨M |
|
|
«á¨Óµo²{¬O¦bdbc ¤¤ªºview¸Ì±¦³Óupdate criteria¸Ì±ªºfield¸j©wªº¦a¤è¡A¹]µ§¹Ï®×¤U±ªº¦a¤èÃij£¥´¤Ä¡A¥L¤~·|§âªí³æªºÈ¸ò¸ê®Æ®wÄæ¦ì¸j©w¡A
¦b§Ú·s¼WÄæ¦ì¤§«á¡Akeyªº¨ºÓÄæ¦ì¤£ª¾¹D¬°Ô£³Q¤Ä±¼¤F _________________ ¤j®a¦n¡A§Ú¬O¤E§À¤H¬W¤O¡AµL¤÷µL¥À¤@®e¾¹ |
|
¦^³»ºÝ |
|
|
foxy
µù¥U®É¶¡: 2007-08-16 ¤å³¹: 245 ¨Ó¦Û: ®õ°ê
²Ä 3 ¼Ó
|
µoªí©ó: ¬P´Á¤é ¤¤ë 05, 2024 12:28 pm ¤å³¹¥DÃD: |
|
|
¦bMS SQL Server, ·s¼WÄæ¦ì«á±³]©wã³\ NULL _________________ ¶i¾P¦s+¥Í²£»s³y+·|p+û¤uÁ~¸ê+CRM+POS¹s°â+À\ÆU¤â¾÷app+¹q°Ó¤â¾÷app+¹q°Óºô¯¸,ª«¬y¨t²Î. ¥¿/²Å餤¤å,^,¤é,®õ,½q¨l¤å. MS SQL Server + «e¥x VFP + PHP ºô¯¸ + Flutter ¤â¾÷ App, ³£¦@¨É MS SQL Serverªº¸ê®Æ. www.foxacc.com LINE: mike-lm |
|
¦^³»ºÝ |
|
|
forever8888
µù¥U®É¶¡: 2023-12-14 ¤å³¹: 10 ¨Ó¦Û: ®ç¶é¤K¼w
²Ä 4 ¼Ó
|
µoªí©ó: ¬P´Á¤@ ¤¤ë 13, 2024 4:28 pm ¤å³¹¥DÃD: |
|
|
¦]¬°è¦n³Q¤Ä±¼¨S¦³³s°Ê¨ìªº´N¬OpkÄæ¦ì¡A©Ò¥H¤~·|³y¦¨°ÝÃD¡A¦ýÁÙ¦n¤]¶¶§Q¸Ñ¨M¤F _________________ ¤j®a¦n¡A§Ú¬O¤E§À¤H¬W¤O¡AµL¤÷µL¥À¤@®e¾¹ |
|
¦^³»ºÝ |
|
|
|
|
±z µLªk ¦b³oÓª©±µoªí¤å³¹ ±z µLªk ¦b³oÓª©±¦^ÂФ峹 ±z µLªk ¦b³oÓª©±½s¿è¤å³¹ ±z µLªk ¦b³oÓª©±§R°£¤å³¹ ±z µLªk ¦b³oÓª©±¶i¦æ§ë²¼ ±z µLªk ¦b³oÓª©±ªþ¥[ÀÉ®× ±z µLªk ¦b³oÓª©±¤U¸üÀÉ®×
|
Powered by phpBB © 2001, 2005 phpBB Group ¥¿Å餤¤å»y¨t¥Ñ phpbb-tw ºûÅ@»s§@
|