FirebirdSQL

ç»çµ¦åæ¡[[FirebirdSQL|FirebirdSQL]]çæåå

[[åå:FirebirdSQL.png]]


æ¡è¿åä½å° [http://vfp.sunyear.com.tw/viewforum.php?f=2  FireBirdSQL è¨è«å] ä¸åè¨è«

== [[FirebirdSQL/0|ä»ç´¹ç¯ What is Firebird]] ==
*[[FirebirdSQL/0/1|ç¬¬ä¸ç«  Firebird ç¼å±æ·å²]]
*[[FirebirdSQL/0/2|ç¬¬äºç«  Firebird ç¹æ§]]
*[[FirebirdSQL/0/3|ç¬¬ä¸ç«  Firebird æè¶£è©±é¡]]
*[[FirebirdSQL/0/4|ç¬¬åç«  Firebird é¢å°æªä¾]]


== [[FirebirdSQL/1| ç¬¬ä¸ç¯  Firebird å¿«éå¥éæå¼]] ==
*[[FirebirdSQL/1/1| ç¬¬ä¸ç«  FireBird æ¯æçå¹³å°èçæ¬åå®è£]]
**[[FirebirdSQL/1/1/1 | Windows çæ¬çå®è£]]
***[[FirebirdSQL/1/1/1/1 | æåå®è£]]
***[[FirebirdSQL/1/1/1/2 | åå½¢ä»é¢å®è£]]
***[[FirebirdSQL/1/1/1/3 | Embedded serverå®è£]]
**[[FirebirdSQL/1/1/2 | Linux çæ¬çå®è£]]
**[[FirebirdSQL/1/1/3 | è£½ä½åæ§åKNOPPIXåç¢ç]]
*[[FirebirdSQL/1/2 | ç¬¬äºç«  Firebird ODBC/JDBC é©åç¨å¼çå®è£ ]]
*[[FirebirdSQL/1/3 | ç¬¬ä¸ç«  Firebird é£ç·åä¸²ï¼åå«.Neté£ç·åä¸²ï¼ ]]
*[[FirebirdSQL/1/4 | ç¬¬åç«  Firebird è³æåº«ç®¡çä»é¢ï¼isqlï¼]]
*[[FirebirdSQL/1/5 | ç¬¬äºç«  å®¢æ¶ç«¯ç¨å¼éç¼ ]]
*[[FirebirdSQL/1/6 | ç¬¬åç«  ä»éº¼æ¯ Dialectï¼]]

== [[FirebirdSQL/2/1 | ç¬¬äºç¯ Firebird é²éä½¿ç¨æå]] ==
*ç¬¬ä¸ç«  Command-line tools 
**[[FirebirdSQL/2/1/1 | isql ]]
**[[FirebirdSQL/2/1/2 | gbak ]]
**[[FirebirdSQL/2/1/3 | gfix ]]
**[[FirebirdSQL/2/1/4 | gsec ]]
**[[FirebirdSQL/2/1/5 | gstat ]]
**[[FirebirdSQL/2/1/6 | fb_lock_print ]]
**[[FirebirdSQL/2/1/7 | ibmgr ]]

*[[FirebirdSQL/2/2 | ç¬¬äºç«  Server Configuration ]]
*[[FirebirdSQL/2/3 | ç¬¬ä¸ç«  Network Configuration ]]
*[[FirebirdSQL/2/4 | ç¬¬åç«  Database Security ]]
*[[FirebirdSQL/2/5 | ç¬¬äºç«  Database Configuration and Maintenance ]]
*[[FirebirdSQL/2/6 | ç¬¬åç«  Database Backup and Restore ]]
*[[FirebirdSQL/2/7 | ç¬¬ä¸ç«  Database and Server Statistics ]]
*[[FirebirdSQL/2/8 | ç¬¬å«ç«  Interactive Query ]]
*[[FirebirdSQL/2/9 | ç¬¬ä¹ç«  Database and Server Performance ]]
*[[FirebirdSQL/2/10| ç¬¬åç«  Data Replication ]]

== [[FirebirdSQL/3/1 |ç¬¬ä¸ç¯ Firebird è³æåº«ç®¡ç]] ==
ï¼ä»¥IBexpertçºä¾ï¼---commandèªæ³ç¸å,æåªé¤åä¾ç
*ç¬¬ä¸ç« èªèSQLèªè¨èè³æåå¥
**SQLçèªæ³æ¨æº
**è³æåå¥ Data Type
**èå¥åç¨±
*ç¬¬äºç« å»ºç«è³æåº«/è³æè¡¨/éè¯
**å»ºç« User
**å»ºç« Database
**å»ºç« Table
**å»ºç« Index
**å»ºç« View
**å»ºç« Relation
*ç¬¬ä¸ç« ååè³æåº«çè³æ
**SELECT - SQL
**UPDATE - SQL
**DELETE - SQL
**DROP
*ç¬¬åç« è¦åç©ä»¶.é è¨è³ªç©ä»¶.èªè¨åå¥
*ç¬¬äºç« åç¨ç´¢å¼Optimize
*ç¬¬åç« iSQLç¨å¼è¨è¨
**[[FirebirdSQL/3/Store Procedure|Store Procedure]]
**[[FirebirdSQL/3/Trigger|Trigger]]
**[[FirebirdSQL/3/Transaction|Transaction]]
**Buffering

== ç¬¬åç¯ Firebird èªè¨æå ==

== [[FirebirdSQL/5|ç¬¬äºç¯ å®¢æ¶ç«¯ç¨å¼ç¨å¼éç¼]] ==
*[[FirebirdSQL/5/VFP| ç¬¬ä¸ç«  VFP ä½¿ç¨ ODBC SPT]]
*[[FirebirdSQL/5/2| ç¬¬äºç«  PHP ]]
*[[FirebirdSQL/5/3| ç¬¬ä¸ç«  BC++/Delphi ]]
*[[FirebirdSQL/5/4| ç¬¬åç«  dotNetéç¼]]
*[[FirebirdSQL/5/5| ç¬¬äºç«  VBéç¼]]

== æå¾ç¯ Firebird ç¶åç¯ ==
*[[FirebirdSQL/6/1| ç¬¬ä¸ç«  ç¶²ç«ç¸éè¨æ¯]]
*[[FirebirdSQL/æå¾ç¯ Firebird ç¶åç¯/FirebirdSQLä¸è¼| ç¬¬äºç«  FirebirdSQLä¸è¼çæ¬/å·¥å·/æ¸ç± ]]
*[[FirebirdSQL/æå¾ç¯ Firebird ç¶åç¯/VFP&Firebird| ç¬¬ä¸ç«  VFP&Firebird ]]
*[[FirebirdSQL/æå¾ç¯ Firebird ç¶åç¯/FireBird&SQLServer| ç¬¬åç«  å¦ä½å¾Microsoft SQL Serverè½æå°FirebirdSQL ]]

== åçç¯ Firebird Q&A ==
* FirebirdSQL--å®è£è¨å® 
*# [[FirebirdSQL/åçç¯/å®¢æ¶ç«¯çæå°å®è£|å®¢æ¶ç«¯çæå°å®è£]]
*# [[FirebirdSQL/åçç¯/å®è£ç¨å¼çè³æ¬è£½ä½|å®è£ç¨å¼çè³æ¬å¶ä½]]
*# [[FirebirdSQL/åçç¯/Firebird Embedded Server and VFP | Firebird Embedded Server and VFP ]]
*# [[FirebirdSQL/åçç¯/å¦ä½æ¹è®å®¢æ¶ç«¯é£ç·çPort|å¦ä½æ¹è®å®¢æ¶ç«¯é£ç·çPort]]
* FirebirdSQL--è³æåº«ç¶è· 
*# [[FirebirdSQL/åçç¯/è³æåº«ææ¯æå±æ©èç|è³æåº«ææ¯æå±æ©èç]]
*# [[FirebirdSQL/åçç¯/æ¹æ¬¡æªå·è¡åä»½ä¿®å¾©|æ¹æ¬¡æªå·è¡åä»½ä¿®å¾©]]
*# [[FirebirdSQL/åçç¯/æ¹è®è³æè¡¨çç´¢å¼åç¨±|æ¹è®è³æè¡¨çç´¢å¼åç¨±]]
*# [[FirebirdSQL/åçç¯/ååºç´¢å¼åç¨±|ååºç´¢å¼åç¨±]]
*# [[FirebirdSQL/åçç¯/å·¥ä½æç¨--åä»½å·¥ä½ |å·¥ä½æç¨--åä»½å·¥ä½]]
* FirebirdSQL-è³æåº«åå 
*# [[FirebirdSQL/åçç¯/InterBase User å®ç¾©|InterBase User å®ç¾©]]
*# [[FirebirdSQL/åçç¯/SQLCommandåå¾è³æè¡¨æ ¼|SQLCommandåå¾è³æè¡¨æ ¼]]
*# [[FirebirdSQL/åçç¯/ç·¨èéè¤è¼¸å¥ä¾å¤èç|ç·¨èéè¤è¼¸å¥ä¾å¤èç]]
*# [[FirebirdSQL/åçç¯/æ¾åºéè¤çç´é|æ¾åºéè¤çç´é]]
* FirebirdSQL-è³æåº«æç 
*# [[FirebirdSQL/åçç¯/fbServerä½¿ç¨CPU100%çåé¡|fbServerä½¿ç¨CPU100%çåé¡]]
*# [[FirebirdSQL/åçç¯/Performance with joins and order by|joins and order byçæçåé¡]]
* FirebirdSQL-å¶ä» 
*# [[FirebirdSQL/åçç¯/ROUND|å¦ä½åæ¨äºå¥å°æ¸é»]]

== Firebird å·²ç¥é®é¢åè¡¨ ==
* [[æ°æ®åºæä»¶çå¨è·¯å¾ä¸ä¸è½åå«ä¸æåç¬¦|è·¯å¾é®é¢]]



æ¬ç¶²é ç©ºéç±[http://www.sunyear.com.tw å°æè³è¨æéå¬å¸]åè²»æä¾
http://sunyear.com.tw/images/botton02_r1_c01.jpg