Database

MatDeck has incorporated range of functions and tools that can be used for simple and fast data exchange with SQLite database. You can store and read a large amount of data, combine this data with GUI elements to create very useful applications and forms, save results of your calculations in SQLite db files and share then, …

We can divide database functions in two group:

  1. Functions for database data exchange
  2. Graphical objects for database data exchange

Functions for database data exchange are:

  • Database read – with this function you can read data stored in SQLite db document and placed them in MatDeck variable, ready for further use.
  • Database write – with this function MatDeck variable can be writing as data and store in SQLite db document.
  • Database query – with this function you can execute queries in selected database. You have to write queries as a string in SQLite query language, which is basically the standard SQL language that omit some features while at the same time adding a few features of its own.

Database

Examples:

Choose your currency:

Close
Converted prices are for reference only - all orders are charged in £ Pound Sterling (£) GBP.
  • USDUS Dollars ($)
  • EUREuros (€)
  • GBPPound Sterling (£)
  • AUDAustralian Dollars ($)
  • BRLBrazilian Real (R$)
  • CADCanadian Dollars ($)
  • CZKCzech Koruna
  • DKKDanish Krone
  • HKDHong Kong Dollar ($)
  • HUFHungarian Forint
  • ILSIsraeli Shekel (₪)
  • JPYJapanese Yen (¥)
  • MYRMalaysian Ringgits
  • MXNMexican Peso ($)
  • NZDNew Zealand Dollar ($)
  • NOKNorwegian Krone
  • PHPPhilippine Pesos
  • PLNPolish Zloty
  • SGDSingapore Dollar ($)
  • SEKSwedish Krona
  • CHFSwiss Franc
  • TWDTaiwan New Dollars
  • THBThai Baht (฿)
  • INRIndian Rupee (₹)
  • TRYTurkish Lira (₺)
  • RUBRussian Rubles