Difference between revisions of "Nsfb"

From AOLserver Wiki
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
= nsfb 1.0 =
+
= nsfb 1.2 =
 
Created by [mailto:info@waplikace.cz Richard Kotal].
 
Created by [mailto:info@waplikace.cz Richard Kotal].
  
Line 9: Line 9:
 
* support many configuration options such as charset, dialect, transaction isolation level, ...
 
* support many configuration options such as charset, dialect, transaction isolation level, ...
 
* support all kind of the data types
 
* support all kind of the data types
 +
* support for FB specific functions such as create and drop db, information about db connection
 +
* support for FB events handle
 +
* support for importing data from a file into the BLOB value
 +
* support for writing a BLOB data into the file
 +
* support hexadecimal and base64 representation of the input (set to the db) and output data (read from the db)
  
[http://www.aolserver.cz/download.php Download page],  [http://www.aolserver.cz/download/nsfb-1.0.tgz nsfb-1.0.tgz]
+
 
 +
 
 +
 
 +
[http://www.aolserver.cz/download.php Download page],  [http://www.aolserver.cz/download/nsfb-1.2.tgz nsfb-1.2.tgz]
  
  
Line 21: Line 29:
 
     ns_db sp_exec $db  
 
     ns_db sp_exec $db  
 
     ns_db dml $db "commit"
 
     ns_db dml $db "commit"
 +
    ns_db releasehandle $db
 +
 +
Simple sample (synchronous waiting for events):
 +
 +
    set db [ns_db gethandle fb15]
 +
    set events [list "DEC" "SUN" "HP"]
 +
    ns_fb event alloc $db $events
 +
    ns_fb event wait $db ; # process waiting for the occurence of the event
 +
    set out [ns_fb event catch $db $events]
 +
    ns_adp_puts "catched events: $out"
 
     ns_db releasehandle $db
 
     ns_db releasehandle $db

Latest revision as of 12:03, 23 October 2006

nsfb 1.2

Created by Richard Kotal.


This is internal AOLserver database driver for Firebird|Interbase database (http://www.firebirdsql.org).

  • support read and write BLOB data
  • support read and write ARRAY data
  • support full size of varchar (32765 bytes) or char (32767 bytes)
  • support many configuration options such as charset, dialect, transaction isolation level, ...
  • support all kind of the data types
  • support for FB specific functions such as create and drop db, information about db connection
  • support for FB events handle
  • support for importing data from a file into the BLOB value
  • support for writing a BLOB data into the file
  • support hexadecimal and base64 representation of the input (set to the db) and output data (read from the db)



Download page, nsfb-1.2.tgz


Simple sample (update array data):

   set db [ns_db gethandle fb15]
   ns_db dml $db "set transaction"
   ns_db sp_start $db "update job set language_req = ? where job_code = 'CEO'"
   ns_db sp_setparam $db "1" "" "in" "[list Eng "" Ger "" Itl]"
   ns_db sp_exec $db 
   ns_db dml $db "commit"
   ns_db releasehandle $db

Simple sample (synchronous waiting for events):

   set db [ns_db gethandle fb15]
   set events [list "DEC" "SUN" "HP"]
   ns_fb event alloc $db $events
   ns_fb event wait $db ; # process waiting for the occurence of the event
   set out [ns_fb event catch $db $events]
   ns_adp_puts "catched events: $out"
   ns_db releasehandle $db