Sodium: Türkiye'nin Programlama Dili
  • Sodium Home Page
  • Getting Started
    • Examples
      • Hello World Example
      • Datalist & Select Element Usage
  • Installation & Configuration
  • Frequently Asked Questions
  • How to
    • How to: use Recordset variable and to_json function for populating a tree node
    • How to: get selected tree node id
    • How to: create master detail relationship between data blocks
    • How to: use data list element for populating select elements
    • How to: define a lookup element for a select element
    • How to: use database sequence in data block element
  • Contributers
  • Roadmap
  • About Me
  • Version History
    • Change Log
    • Things To Do
    • Known Issues
  • LANGUAGE REFERENCE
    • Program Structure
      • Form File
      • Code Behind File
      • Controller File
    • Built-in Functions
      • Sodium Built-in Functions
        • Database Related Functions
          • commit
          • rollback
          • delete
          • create_postgresql_connection
          • create_oracle_connection
          • create_mysql_connection
          • get_database_type
          • get_database_name
          • run_sql_file
          • set_active_database_connection
        • REDIS Functions
          • create_redis_connection
          • close_redis_connection
          • (redis-variable-name).set
          • (redis-variable-name).get
          • (redis-variable-name).del
          • (redis-variable-name).ping
          • (redis-variable-name).incr
          • (redis-variable-name).incrBy
          • (redis-variable-name).decr
          • (redis-variable-name).decrBy
          • (redis-variable-name).strlen
          • (redis-variable-name).append
        • Other Functions
          • disable_column
          • enable_column
          • hide_block
          • hide_column
          • message
          • populate_datalist
          • prompt
          • refresh_block
          • show_block
          • show_column
          • show_page
          • populate_tree
          • to_json
          • refresh_tree_node
          • set_datablock_property
      • Built-in String Functions & Operands
        • instr
        • strlen
        • Concatanation Operator
        • replace
        • substr
        • The "sizeof" Operator
        • Like & Not Like Operators
      • File IO functions
      • Date/time Functions
    • Built-in Triggers
      • "item_modified" trigger
      • "connection_not_found" trigger
      • "page.access" trigger
      • "page_load" trigger
      • "post_query" trigger
      • "row_selected" trigger
      • "button_item_clicked" trigger
      • "pre_insert" Trigger
      • "pre_delete" Trigger
      • "pre_update" Trigger
      • "post_insert" Trigger
      • "post_delete" Trigger
      • "post_update" Trigger
      • "tree_node_expanded" Trigger
      • "tree_node_selected" Trigger
      • "user_session_end" trigger
    • TAGs
      • Data Block
        • Data Block: Form View Mode
        • Data Block: Grid View Mode
        • Data Block: Mix View Mode
      • Control Block
      • Data List
      • Tree Element
      • Table TAG
      • Inputs
        • Text Item
        • Radio Item
        • Select Item
        • Checkbox Item
        • Button Item
        • Image Item
        • Textarea Item
        • Magic Buttons
    • Native SQL support
    • Lexical Elements
      • Identifiers
      • Keywords
      • Constants
        • The Null Statement
        • String Constant
      • Operators
      • Separators
      • White Space
      • Variables
        • Variable Type: int
        • Variable Type: char
        • Variable Type: bool
        • Local variables
        • Page variables
        • Session variables
        • Predefined Variables
          • :Session.authenticated
          • :Session.user
          • :Session.Id
          • :Session.user
          • :Row.Id
      • Functions
        • Function Declarations
        • Calling Functions
        • Function Parameters
        • Recursive Functions
      • Statements
        • The "if" Statement
        • The while Statement
        • The do Statement
        • Code Blocks
        • The break Statement
        • The return Statement
      • Expressions And Operators
        • Expressions
        • Assignment Operators
        • Arithmetic Operators
        • Comparison Operators
        • Logical Operators
        • Function Calls as Expressions
        • Operator Precedence
        • Order of Evaluation
      • Escape Character
    • CSS Themes
    • Scopes
    • Connection
      • Active Database Connection
      • Connection Types
        • Database Connections
        • REDIS Connection
  • Development
    • IDE
    • Debugging
  • SODIUM DEVELOPMENT
    • Sodium Development Home Page
    • Getting Started
      • Sodium Architecture
      • Development Environment
        • Source Code
        • Applications Required
        • Compiling C Projects
        • Compiling NodeJs Project
        • Troubleshooting
Powered by GitBook
On this page
  • 2020-05-30 (Version 0.0.8)
  • Bug fixes
  • Improvements
  • 2020-05-12 (Version 0.0.7)
  • Bug fixes
  • 2020-05-10 (Version 0.0.6)
  • Improvements
  • Bug fixes
  • 2020-05-01 (Version 0.0.5)
  • Improvements
  • 2020-04-30 (Version 0.0.4)
  • Bug fixes
  • Improvements
  • 2020-04-29 (Version 0.0.3)
  • Improvements
  • 2020-04-28 (Version 0.0.2)
  • Bug fixes
  • 2020-04-23 (Version 0.0.1)
  • Improvements

Was this helpful?

  1. Version History

Change Log

Be sure to not miss out on new features and improvements!

PreviousAbout MeNextThings To Do

Last updated 4 years ago

Was this helpful?

2020-05-30 (Version 0.0.8)

Bug fixes

  • A serious bug detected in DBInt-PostgreSql.dll file. Memory locations holding sql command parameter values were overwritten by random values. (Postgresql library requires a dynamically sized pointer array to another pointer which holds actual paramater values of SQL statement. (More detail: paramValues parameter of the function)

Improvements

  • section is added to the .

  • MS Sql Server support is added.

2020-05-12 (Version 0.0.7)

Bug fixes

  • In case trigger returns false, http response was not generated correctly.

  • Some C functions related to blob column type operations for MySql database are modified/fixed.

  • Some memory areas allocated for Page Object and its properties was not released properly.

  • fixed.

2020-05-10 (Version 0.0.6)

Improvements

Bug fixes

  • C functions related to reading/writing blob data to/from database is not working with Http Server API. Migration from Microstf Internet Information Server to Http Server API is not complete.

2020-05-01 (Version 0.0.5)

Improvements

  • Table/view primary key column name is automatically populated from database schema dictionary if not provided by developer.

2020-04-30 (Version 0.0.4)

Bug fixes

  • Page expire time calculation was wrong. It is fixed.

  • Postgresql Demo was not working due to database row identifying strategy. It is replaced with new one (see Improvements for deail).

Improvements

  • Demo database objects are created in SODIUM_DEMO user in Oracle Container database (with using "alter session set "_ORACLE_SCRIPT"=true;" command). After this modification, demo database user names for both Oracle and Postgresql are same.

  • Pseudo columns

    • oid in Postgresql database

    • rowid in Oracle database

2020-04-29 (Version 0.0.3)

Improvements

2020-04-28 (Version 0.0.2)

Bug fixes

While parsing string literals in sqlx files, < and > characters are not copied into string. Sqlx file lexer fixed.

2020-04-23 (Version 0.0.1)

Improvements

Mysql Support added ()

For the data blocks whose property is set to TRUE, table/view primary key column name is automatically populated from database schema dictionary.

are not used anymore. Developer must set property if he/she want to have a writable datablock.

property added to the .

From now on, pNotify is used as client library for function. And also, a new variant has been added to message function.

create_mysql_connection
message
PQexecParams
Installation & Configuration page
page.access
MySql demo database creation script file
data block tag
auto-generated-columns
key-column-name
key-column-name
Troubleshooting