https://tails.boum.org/ =1,1 GB iso
https://www.qubes-os.org/ =4,8 GB iso
++
https://www.informit.com/articles/article.aspx?p=31690&seqNum=3
++
Sunday, November 29, 2020
Friday, November 27, 2020
ZNANJE NA IZVOLTE !
250 knjiga u PDF formatu za bagatelu:
D:\50 Tips and Tricks for MongoDB Developers.pdf
D:\Accelerated DOM Scripting with Ajax, APIs, and Libraries.pdf
D:\Advanced Joomla!.pdf
D:\Agile Project Management using Team Foundation Server 2015.pdf
D:\Agile Project Management with Azure DevOps.pdf
D:\Ajax - A Beginner's Guide.pdf
D:\AJAX and PHP Building Modern Web Applications, 2nd Edition.pdf
D:\AJAX and PHP.pdf
D:\Ajax For Dummies.pdf
D:\Ajax The Definitive Guide.pdf
D:\Anaconda-Starter-Guide.pdf
D:\AngularJS-Programming-Cookbook.pdf
D:\ASP.NET MVC 4 and the Web API.pdf
D:\ASP.NET MVC 4 Recipes.pdf
D:\ASP.NET MVC in Action.pdf
D:\Beginning Ajax with ASP.NET.pdf
D:\Beginning Android Web Apps Development.pdf
D:\Beginning App Development with Flutter.pdf
D:\Beginning ASP.NET 2.0 Databases, 2nd Edition.pdf
D:\Beginning ASP.NET 4.5 Databases, 3rd Edition.pdf
D:\Beginning ASP.NET Security.pdf
D:\Beginning C- 5.0 Databases, 2nd Edition.pdf
D:\Beginning C- Object-Oriented Programming, 2nd Edition.pdf
D:\Beginning Database Design Solutions.pdf
D:\Beginning Database Design, 2nd Edition.pdf
D:\Beginning Database Design.pdf
D:\Beginning JavaScript and CSS Development with jQuery.pdf
D:\Beginning JavaScript with DOM Scripting and Ajax From Novice to Professional.pdf
D:\Beginning JavaScript with DOM Scripting and Ajax, 2nd Edition.pdf
D:\Beginning jQuery.pdf
D:\Beginning Laravel, 2nd Edition.pdf
D:\Beginning Laravel.pdf
D:\Beginning Object-Oriented Programming with C-.pdf
D:\Beginning PHP 6, Apache, MySQL 6 Web Development.pdf
D:\Beginning PHP and MySQL E-Commerce, 2nd Edition.pdf
D:\Beginning PHP and MySQL, 4th Edition.pdf
D:\Beginning Software Engineering.pdf
D:\Beginning Visual C- 2012 Programming.pdf
D:\Big Data Application Architecture Q-A.pdf
D:\Bootstrap-Programming-Cookbook.pdf
D:\Build Your Own Ajax Web Applications.pdf
D:\Build Your Own ASP.NET 4 Web Site Using C- - VB, 4th Edition.pdf
D:\Building Android Apps with HTML, CSS, and JavaScript.pdf
D:\Building Microservices Applications on Microsoft Azure.pdf
D:\Building PHP Applications with Symfony, CakePHP, and Zend Framework.pdf
D:\Building-web-apps-with-Node.js.pdf
D:\C- 3.0 Cookbook, 3rd Edition.pdf
D:\C- 5.0 in a Nutshell, 5th Edition.pdf
D:\C- Deconstructed.pdf
D:\C- in Depth, 3rd Edition.pdf
D:\c-handbook.pdf
D:\C-Tutorial.pdf
D:\CLR via C-, 4th Edition.pdf
D:\CMS Design Using PHP and jQuery.pdf
D:\Code Simplicity.pdf
D:\CodeIgniter for Rapid PHP Application Development.pdf
D:\Complete Guide to Test Automation.pdf
D:\css-handbook.pdf
D:\CSS-Programming-Cookbook.pdf
D:\Data Structures and Algorithms with JavaScript.pdf
D:\Database Systems, 4th Edition.pdf
D:\Database Systems.pdf
D:\Databases A Beginner-s Guide.pdf
D:\Decentralized Applications.pdf
D:\deno-handbook.pdf
D:\Design Patterns in PHP and Laravel.pdf
D:\Developing ASP.NET MVC 4 Web Applications.pdf
D:\Developing Responsive Web Applications with AJAX and jQuery.pdf
D:\DHTML Utopia Modern Web Design Using JavaScript - DOM.pdf
D:\Django JavaScript Integration AJAX and jQuery.pdf
D:\Docker-Containerization-Cookbook.pdf
D:\Doing Data Science.pdf
D:\Effective Team Management with VSTS and TFS.pdf
D:\es5-to-esnext.pdf
D:\Excel-2019-for-dummies.pdf
D:\Expert ASP.NET Web API 2 for MVC Developers.pdf
D:\Expert PHP and MySQL.pdf
D:\Exploring Advanced Features in C-.pdf
D:\express-handbook.pdf
D:\Foundations of Ajax.pdf
D:\Foundations of ASP.NET AJAX.pdf
D:\Getting Started with Laravel 4.pdf
D:\Head First Ajax.pdf
D:\Head First C-, 3rd Edition.pdf
D:\Head First JavaScript.pdf
D:\Head First jQuery.pdf
D:\How-to-become-a-Web-Developer.pdf
D:\How-to-Start-a-Blog-with-WordPress.pdf
D:\html-handbook.pdf
D:\HTML5 - CSS3 for the Real World.pdf
D:\HTML5 and CSS3.pdf
D:\HTML5 Web Application Development By Example.pdf
D:\HTML5, JavaScript, and jQuery 24-Hour Trainer.pdf
D:\HTML5-Programming-Cookbook.pdf
D:\Instant Hands-on Testing with PHPUnit How-to.pdf
D:\Integrating Serverless Architecture.pdf
D:\intel optimisations manual.pdf
D:\JavaScript - DHTML Cookbook, 2nd Edition.pdf
D:\JavaScript - jQuery The Missing Manual, 2nd Edition.pdf
D:\JavaScript and AJAX For Dummies.pdf
D:\JavaScript Step by Step, 3rd Edition.pdf
D:\javascript-beginner-handbook.pdf
D:\JavaScript-Interview-Questions.pdf
D:\Joomla! 1.5 JavaScript jQuery.pdf
D:\jQuery 1.3 with PHP.pdf
D:\jQuery 2 Recipes.pdf
D:\jQuery Mobile Cookbook.pdf
D:\jQuery Mobile.pdf
D:\jQuery UI Cookbook.pdf
D:\jQuery UI.pdf
D:\jQuery-Programming-Cookbook.pdf
D:\Laravel 5 Essentials.pdf
D:\Laravel Application Development Cookbook.pdf
D:\Laravel Design Patterns and Best Practices.pdf
D:\Learn HTML5 and JavaScript for Android.pdf
D:\Learning Agile.pdf
D:\Learning JavaScript Design Patterns.pdf
D:\Learning JavaScript Design Patterns2.pdf
D:\Learning JavaScript Design Patterns3.pdf
D:\Learning jQuery, 4th Edition.pdf
D:\Learning Laravel 4 Application Development.pdf
D:\Learning Laravel's Eloquent.pdf
D:\Learning PHP Design Patterns.pdf
D:\Learning Python, 4th Edition.pdf
D:\Learning React.pdf
D:\Lightweight Django.pdf
D:\LINQ Quickly.pdf
D:\LINQ to Objects Using C- 4.0.pdf
D:\LINQ Unleashed for C-.pdf
D:\linux-commands-handbook.pdf
D:\manual-WinHex.pdf
D:\Mastering Dojo.pdf
D:\Mastering Laravel.pdf
D:\Mastering Object-oriented Python.pdf
D:\MDULS AP Programa razvoja eUprave poslat na mišljenja.pdf
D:\MDULS Program razvoja eUprave poslat na mišljenja.pdf
D:\Microsoft ASP.NET and AJAX.pdf
D:\Microsoft Mapping.pdf
D:\Microsoft Visual C- 2010 Step by Step.pdf
D:\Modern JavaScript.pdf
D:\Modern X86 Assembly Language Programming.pdf
D:\MongoDB and PHP.pdf
D:\MongoDB and Python.pdf
D:\MongoDB Applied Design Patterns.pdf
D:\MongoDB Basics.pdf
D:\MongoDB Data Modeling.pdf
D:\MongoDB Recipes.pdf
D:\MongoDB The Definitive Guide.pdf
D:\MongoDB-Cookbook.pdf
D:\Murachs ASP.NET 4.5 Web Programming with C- 2012 (5th edition).pdf
D:\NEXTjs-book.pdf
D:\node-handbook.pdf
D:\Object-Oriented JavaScript.pdf
D:\Pattern-oriented Software Architecture For Dummies.pdf
D:\Patterns of HCI Design and HCI Design of Patterns.pdf
D:\Pentaho Analytics for MongoDB.pdf
D:\PharoVision.pdf
D:\PHP & MySQL Novice to Ninja, 5th Edition.pdf
D:\PHP & MySQL The Missing Manual, 2nd Edition.pdf
D:\PHP & MySQL Web Development All-in-One Desk Reference For Dummies.pdf
D:\PHP 5 MySQL Programming for the Absolute Beginner.pdf
D:\PHP 5 E-commerce Development.pdf
D:\PHP 5 Social Networking.pdf
D:\PHP 6 and MySQL 5 for Dynamic Web Sites.pdf
D:\PHP Ajax Cookbook.pdf
D:\PHP and MongoDB Web Development.pdf
D:\PHP and MySQL For Dummies, 4th Edition.pdf
D:\PHP and MySQL Recipes.pdf
D:\PHP and MySQL- Create - Modify - Reuse.pdf
D:\PHP Development Tool Essentials.pdf
D:\PHP for Absolute Beginners, 2nd Edition.pdf
D:\PHP Objects, Patterns and Practice, 3rd Edition.pdf
D:\PHP Objects, Patterns, and Practice, 4th Edition.pdf
D:\PHP Solutions, 3rd Edition (1).pdf
D:\PHP Solutions, 3rd Edition.pdf
D:\PHP Team Development.pdf
D:\PHP The Ultimate.pdf
D:\PHP-Programming-Cookbook.pdf
D:\PHP5 and MySQL Bible.pdf
D:\Practical CakePHP Projects.pdf
D:\Practical Data Science Cookbook.pdf
D:\Practical JavaScript, DOM Scripting and Ajax Projects.pdf
D:\Practical MongoDB.pdf
D:\Practical PHP and MySQL Website Databases.pdf
D:\Practical UI Patterns for Design Systems.pdf
D:\Practical Web 2.0 Applications with PHP (1).pdf
D:\Practical Web 2.0 Applications with PHP.pdf
D:\Practical-PHP-7.pdf
D:\prirucnik-linux-audio-aplikacije.pdf
D:\Pro Apache Struts with Ajax.pdf
D:\Pro ASP .NET 4.5 in C, 5th Edition.pdf
D:\Pro ASP.NET 3.5 Server Controls and AJAX Components.pdf
D:\Pro ASP.NET MVC 3 Framework, 3rd Edition.pdf
D:\Pro ASP.NET MVC 4, 4th Edition.pdf
D:\Pro ASP.NET Web API Security.pdf
D:\Pro C 7, 8th Edition.pdf
D:\Pro Django, 2nd Edition.pdf
D:\Pro JavaScript Development.pdf
D:\Pro JavaScript for Web Apps.pdf
D:\Pro PHP and jQuery.pdf
D:\Pro PHP MVC.pdf
D:\Pro PHP XML and Web Services.pdf
D:\Pro Zend Framework Techniques.pdf
D:\Professional Ajax, 2nd Edition.pdf
D:\Professional ASP.NET 3.5 Security, Membership, and Role Management with C- and VB.pdf
D:\Professional ASP.NET MVC 1.0.pdf
D:\Professional ASP.NET MVC 3.pdf
D:\Professional C- 5.0 and .NET 4.5.1.pdf
D:\Professional JavaScript for Web Developers, 3rd Edition.pdf
D:\Professional JavaScript for Web Developers.pdf
D:\Programming ASP.NET MVC 4.pdf
D:\Programming Microsoft ASP.NET MVC, 3rd Edition.pdf
D:\Programming Microsoft ASP.NET MVC.pdf
D:\Programming Razor.pdf
D:\Python - XML.pdf
D:\Python Web Development with Django.pdf
D:\Python-Programming-Cookbook.pdf
D:\react-beginners-handbook.pdf
D:\Real-World Solutions for Developing High-Quality PHP Frameworks and Applications.pdf
D:\Realtime Web Apps.pdf
D:\RINEX-2.pdf
D:\Sams Teach Yourself Ajax, JavaScript, and PHP All in One.pdf
D:\Scaling MongoDB.pdf
D:\Scrum in Action.pdf
D:\Securing Ajax Applications.pdf
D:\SignalR Programming in Microsoft ASP.NET.pdf
D:\Software Development From A to Z.pdf
D:\Software Development, Design and Coding, 2nd Edition.pdf
D:\svelte-handbook.pdf
D:\Test-Drive ASP.NET MVC.pdf
D:\Test-Driven Development with Python, 2nd Edition.pdf
D:\The Blockchain Developer.pdf
D:\The Definitive Guide to MongoDB, Third Edition.pdf
D:\The Full Stack Developer.pdf
D:\The Principles of Object-Oriented JavaScript.pdf
D:\The Professional ScrumMaster's Handbook.pdf
D:\The Way of the Web Tester.pdf
D:\The-Best-Web-Programming-Languages-to-Learn.pdf
D:\uC++.pdf
D:\Use Case Driven Object Modeling with UML.pdf
D:\View Updating and Relational Theory.pdf
D:\vue-handbook.pdf
D:\Web Development with jQuery.pdf
D:\Web Programming with PHP and MySQL.pdf
D:\Web Standards.pdf
D:\Web-Based Projects that Rock the Class.pdf
D:\WebGL Beginner's Guide.pdf
D:\WordPress Web Design For Dummies, 3rd Edition.pdf
D:\Zend Framework 2.0 by Example.pdf
D:\The-Art-of-Computer-Programming-Books-master\The-Art-of-Computer-Programming-Books-master\1.pdf
Svaka donacija je dobrodošla !
Thursday, November 26, 2020
web pascal
Web Alternatives
- Brook framework - Microframework which helps to develop web Pascal applications.
- mORMot - Synopse mORMot ORM/SOA/MVC framework.
- FreeSpider - Web development package for Free Pascal/Lazarus.
- FCL-Web Built-in Free Pascal web library.
- Fano Framework Web application framework for modern Pascal programming language.
++
++
Wednesday, November 25, 2020
Adobe Acrobat Reader DC not working after Windows 10 update - workaround
It working again after I disabled the "Enable Protected Mode at startup" feature under Edit > Preferences > Security (Enhanced).
Yeeee !
Problem with Print function after Windows 10 Update 2004
MORE TIPS:
https://github.com/trustable-code/NiGui
-----------------------------------------------------------
https://docs.racket-lang.org/gui/
-----------------------------------------------------------
-----------------------------------------------------------
-----------------------------------------------------------
-----------------------------------------------------------
-----------------------------------------------------------
Aurel Basic by Vidlanovic Zlatko Aurel:
-----------------------------------------------------------
Tuesday, November 24, 2020
An entertainment
++
https://www.epicgames.com/unrealtournament/en-US/#maps
http://www.truecombatelite.com/
Communication without internet and simcard:
https://play.google.com/store/apps/details?id=com.remaller.android.wifitalkie_lite&hl=en&gl=US
MORE FROM FLAVIO:
Read about:
Algorithm Complexity and Big O Notation
Sunday, November 22, 2020
10 linux apps
Top 10 Linux Apps:
1. Ulauncher – Application Launcher
2. Stacer – Optimizer And Monitor
3. Timeshift – System Snapshot
4. Kdenlive – Best Non-linear editing
5. Simplenote – Clean Note Taking
6. VLC – Play anything!
7. Gnome Tweak – Change Anything
8. Etcher – USB Image Writer
9. GIMP – Professional Image Editing
10. Notepadqq – Source Code Editor
https://techhut.tv/top-10-linux-apps-ubuntu/
++
MORE GOODIES:
++
Friday, November 20, 2020
LM317T
MORE TIPS:
Python
Django
JavaScript
React.js
PostgreSQL
aws
heroku
GoogleMapsApi
ZingChart
Thursday, November 19, 2020
Difference between Node.js and React.js
http://www.kanotix.com/module-Downloads.html
SMALL COMPILERS:
https://github.com/unisolate/plzero
https://www.lua.org/source/5.3/
Difference between Node.js and React.js:
| NODE.JS | REACT.JS |
|---|---|
| Node.js used as a back-end framework | React is used for developing user interfaces. |
| It supports the Model–view–controller (MVC) framework. | Does not support the Model–view–controller (MVC) framework. |
| It runs on chrome’s v8 engine and uses an event-driven, non-blocking I/O model, which is written in C++. | It uses Node.js to compile and optimize the JavaScript code and easy to create UI Test cases. |
| Node.js handles requests and authentication from the browser, make database calls, etc. | It makes API calls and processes in-browser data. |
| Here the Real-time data streaming is handled easily. | In React complex architecture makes it hard to keep track of the traditional approach. |
| Framework for JavaScript execution having the largest ecosystem of open source libraries. | Facebook-backed Open Source JS library. |
| The language used the only JavaScript. | The language used is JSX and JavaScript. |
| There is no DOM (Document Object Model) concept that is Used. | Here the Virtual DOM (Document Object Model) is Used that makes it faster. |
++
IDS:
Free and open source IDS
- ACARM-ng
- AIDE
- Fail2ban
- OSSEC HIDS
- Prelude Hybrid IDS
- Sagan
- Samhain
- Snort, GPLv2+ developed by Cisco.
- Suricata
- Zeek
Tuesday, November 17, 2020
WWII
MORE TIPS:
https://swift.org/download/#releases
https://github.com/compnerd/swift-win32
1/2 kg belog pasulja,
4 kuvana jajeta,
200 g kačkavalja,
1 kašika seckanog peršuna,
3 struka od zelenog dela mladog luka,
2-3 čena belog luka,
1 kašičica mlevene paprike,
250 ml slatke pavlake,
2 kašike kisele pavlake,
3 jajeta,
so, biber.
PRIPREMA:
Pasulj skuvajte i izmiksajte. Ako nemate vremena, možete da koristite i pasulj iz konzerve. Dodajte mlevenu papriku, iseckan crni luk, ispresovan beli luk, peršun, so i biber. Sve dobro promešajte i izručite u vatrostalnu posudu podmazanu puterom. Masu od pasulja ravnomerno rasporedite, preko nanesite polovinu izrendanog kačkavalja, zatim kolutove tvrdo kuvanih jaja i ostali deo kačkavalja. Umutite pavlaku sa jajima, malo posolite i prelijte preko kačkavalja. Stavite da se zapeče na 200 stepeni oko 30 minuta. Isključite rernu, pokrijte folijom i ostavite da odstoji još oko 15 minuta. Služite vruće uz salatu po želji.
Friday, November 13, 2020
Thursday, November 12, 2020
add jpg to pdf
Python stuff:
https://stackabuse.com/working-with-pdfs-in-python-adding-images-and-watermarks/
C# Stuff:
https://ironpdf.com/docs/questions/signing/
Delphi stuff:
https://github.com/synopse/SynPDF
https://synopse.info/forum/viewtopic.php?pid=370
http://www.trichview.com/forums/viewtopic.php?t=7304
https://awesomeopensource.com/project/synopse/SynPDF
procedure TForm5.Button1Click(Sender: TObject);
varlPdf : TPdfDocument;
lPage : TPdfPage;
begin
lPdf := TPdfDocument.Create;
try
lPdf.Info.Author := 'Tester';
lPdf.Info.CreationDate := Now;
lPdf.Info.Creator := 'Tester';
lPdf.DefaultPaperSize := psA4;
lPage := lPDF.AddPage;
lPDF.Canvas.SetFont('Helvetica',10.0,[]);
lPDF.Canvas.SetLeading(lPDF.Canvas.Page.FontSize);
lPDF.Canvas.SetLineWidth(0.1);
lPdf.Canvas.BeginText;
lPdf.Canvas.TextOut( 300, 700, 'This is some text.');
lPdf.Canvas.EndText;
lPdf.SaveToFile('c:\temp\test.pdf');
finally
lPdf.Free;
end;
end;
Conclusion - the best choice:
# To extract pages 1-3, 5 and 6-10 from a PDF file and save them as another one:
qpdf --empty --pages <input.pdf> <1-3,5,6-10> -- <output.pdf>
# To merge (concatenate) all the pages of a list of PDF files and save the result as a new PDF:
qpdf --empty --pages <file1.pdf> <file2.pdf> <file3.pdf> -- <output.pdf>
# To merge (concatenate) given pages from a list of PDF files and save the result as a new PDF:
qpdf --empty --pages <file1.pdf> <1,6-8> <file2.pdf> <3,4,5> -- <output.pdf>
# To write each group of n pages to a separate output file with a given filename pattern:
qpdf --split-pages=n <input.pdf> <out_%d.pdf>
# To rotate certain pages of a pdf with a given angle:
qpdf --rotate=<90:2,4,6> --rotate=<180:7-8> <input.pdf> <output.pdf>
# To remove the password from a password protected file:
qpdf --password=<password> --decrypt <input.pdf> <output.pdf>
--------------
Extract pages 1-3, 5 and 6-10 from a PDF file and save them as another one:
qpdf --empty --pages input.pdf 1-3,5,6-10 -- output.pdf
Merge (concatenate) all the pages of a list of PDF files and save the result as a new PDF:
qpdf --empty --pages file1.pdf file2.pdf file3.pdf -- output.pdf
Merge (concatenate) given pages from a list of PDF files and save the result as a new PDF:
qpdf --empty --pages file1.pdf 1,6-8 file2.pdf 3,4,5 -- output.pdf
Write each group of n pages to a separate output file with a given filename pattern:
qpdf --split-pages=n input.pdf out_%d.pdf
Rotate certain pages of a pdf with a given angle:
qpdf --rotate=90:2,4,6 --rotate=180:7-8 input.pdf output.pdf
Remove the password from a password protected file:
qpdf --password=password --decrypt input.pdf output.pdf
Delphi:
C#:
PM> Install-Package Spire.PDF -Version 6.11.6
free Spire pdf samples
Tuesday, November 10, 2020
form editor c#
https://ironmansoftware.com/building-a-windows-form-app-with-powershell-in-vs-code/
ili još zdravija i ukusnija varijanta:
Recept
U prazan zagrejan tiganj ubaciti nasečene šampinjone, svakog minuta ih promešati tako da svaki od njih svakom stranom dotakne dno tiganja. Peći bez vode i ikakvih dodataka oko 3 minuta, zatim dodati seckan crni luk, crvenu papriku, seckan beli luk i dinstati još 3 minuta. Zatim sipati jogurt i prstohvat origana, promešati još 1 minut. Možete na kraju dodati ocedjene sardine iz konzerve ili tunjevinu i usitniti ih pri mešanju u tiganju, obavezno pobiberiti, a alevu papriku možete dodati po ukusu na vrh kašičice.
Ovo jelo jedite bez hleba, krompira i ikakvih ugljenih hidrata, ulje, puter, masnoća nije potrebna.
Možete jelo služiti uz neku salatu od krastavaca i paradajza.
http://poincare.matf.bg.ac.rs/~jgraovac/courses/projbp/2016_2017/projbp_skripta.pdf
https://lickeys.ru/bs/brauzery/vychislitelnye-sistemy-s-obshchei-pamyatyu-pamyat-vychislitelnyh-sistem/
https://www.project-benefit.eu/eplatform/?courses=36&download=Softver%20TK%20sistema.pdf
http://www.scl.rs/pics/files/News/20080625-meteo/SEEGRIDSCI-NA3-RS-013-Parallel_Computing_Introduction-a-2008-06-24.ppt
http://predmet.singidunum.ac.rs/pluginfile.php/8543/mod_folder/content/0/0b%20Klaud%20i%20distribuirano%20ra%C4%8Dunarstvo.pdf?forcedownload=1
https://singipedia.singidunum.ac.rs/preuzmi/42921-informatika/3495
http://eprints.rclis.org/14122/1/prirucnik-linux-audio-aplikacije.pdf
http://www.vps.ns.ac.rs/Materijal/mat3799.pdf
Friday, November 6, 2020
America
#include <SQLite.au3> #include <SQLite.dll.au3> Local $aResult, $iRows, $iColumns, $iRval _SQLite_Startup() If @error Then MsgBox(16, "SQLite Error", "SQLite.dll Can't be Loaded!") Exit -1 EndIf ConsoleWrite("_SQLite_LibVersion=" & _SQLite_LibVersion() & @CRLF) _SQLite_Open() ; Open a :memory: database If @error Then MsgBox(16, "SQLite Error", "Can't Load Database!") Exit -1 EndIf ;Example Table ; ID | Name | Age ; ----------------------- ; 1 Alice | 43 ; 2 Bob | 28 ; 3 Cindy | 21 If Not _SQLite_Exec(-1, "CREATE TEMP TABLE persons (ID,Name, Age);") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg()) If Not _SQLite_Exec(-1, "INSERT INTO persons VALUES (1,'Alice','43');") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg()) If Not _SQLite_Exec(-1, "INSERT INTO persons VALUES (2,'Bob','28');") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg()) If Not _SQLite_Exec(-1, "INSERT INTO persons VALUES (3,'Cindy','21');") = $SQLITE_OK Then _ MsgBox(16, "SQLite Error", _SQLite_ErrMsg()) ; Query $iRval = _SQLite_GetTable2d(-1, "SELECT * FROM persons;", $aResult, $iRows, $iColumns) If $iRval = $SQLITE_OK Then _SQLite_Display2DResult($aResult) ;~ $aResult looks like this: ;~ ;~ ID Name Age ;~ 1 Alice 43 ;~ 2 Bob 28 ;~ 3 Cindy 21 ;~ ;~ If the dimensions would be switched in _SQLite_GetTable2d the result would look like this: ;~ ;~ Name Alice Bob Cindy ;~ Age 43 28 21 Else MsgBox(16, "SQLite Error: " & $iRval, _SQLite_ErrMsg()) EndIf _SQLite_Close() _SQLite_Shutdown()
; SQLite.dll version must match #include <MsgBoxConstants.au3> #include <SQLite.au3> #include <SQLite.dll.au3> Local $sSQliteDll = _SQLite_Startup() If @error Then MsgBox($MB_SYSTEMMODAL, "SQLite Error", "SQLite3.dll Can't be Loaded!" & @CRLF & @CRLF & _ "Not FOUND in @SystemDir, @WindowsDir, @ScriptDir, @WorkingDir, @LocalAppDataDir\AutoIt v3\SQLite") Exit -1 EndIf MsgBox($MB_SYSTEMMODAL, "SQLite3.dll Loaded", $sSQliteDll & " (" & _SQLite_LibVersion() & ")") ConsoleWrite("_SQLite_LibVersion=" & _SQLite_LibVersion() & @CRLF) _SQLite_Shutdown()
Subscribe to:
Posts (Atom)