...I would install Windows Xp in Virtualbox and use it as Hlp-Viewer.
Btw… I'm on Mac. I was looking for an app to read .hlp files, to read TjanSQL documentation. Does anyone here know how to read .hlp file on Mac? Or is there an online service to convert .hlp files into .html files? Thank you.
I would install Windows Xp in Virtualbox and use it as Hlp-Viewer.I don't even have a Windows XP installer to begin with. Would any Windows users here help me convert janSQL's .hlp files into common text format such as .pdf, .hmtl, or .txt? It should be an easy job if you're a Windows user. I'd like to put them in the public repo so everyone could read it. Thank you.
This here is also good help converter http://www.helpscribble.com/ (http://www.helpscribble.com/).
Also I played around with it last autumn and created a gui example.Thank you. Is your version newer than tatamata's? Do all the query examples in the sample.txt file work correctly in your GUI example? I found some of them don't work correctly with tatamata's version. I'm gonna try them with your version. Can you provide some more complex query examples that work with your janSQL version? It'd be helpful to janSQL users, also to show janSQL features.
It is Lazarus port of Jans example. I put it as attachment.
Is your version newer than tatamata's? Do all the query examples in the sample.txt file work correctly in your GUI example?After comparing the files of tatamata's version and soner's version, I'm pretty sure that soner's is based on tatamata's version, plus some modifications and new features added.
The original janSQL units put some VCL or LCL units that are not actually being used. They're still there in tatamata's version, I still saw them in yours as well.I was wrong, I might have opened a wrong file. Soner had done it already. So, I think it's safe to use soner's version to start enhancing this janSQL library. I'll update my github repo to use soner's version, after I clean up my mess with these files. [Update: done!]
..Yes all examples are working also with tatamatas version. My Version is "same" as tatamatas i copied them only in the same directory to remove tmzsql-dependency.
Do all the query examples in the sample.txt file work correctly in your GUI example? I found some of them don't work correctly with tatamata's version. I'm gonna try them with your version. Can you provide some more complex query examples that work with your janSQL version? It'd be helpful to janSQL users, also to show janSQL features.
..
You can take tatamatas version and when you improve this library (jansql) then you can give your changes to tatamata.I take your version and use it as the base for my next modification. All of the modification is open to public through my GitHub repo (https://github.com/git-bee/janSQL). Anybody who wants to contribute to the project could simply fork it and make a pull request. This is the new way of how open source projects work.
I converted the help-file to doc-file and html-file (copy/paste from original jansql.hlp). I thought it was small file but it took over an hour to copy it. Here is it as attachment, have fun!Ha… thank you so much! This is what I need. I'll convert them to GitHub markdown documents and put them in the repo, so everyone could read them. Thank you!
Yes all examples are working also with tatamatas version. My Version is "same" as tatamatas i copied them only in the same directory to remove tmzsql-dependency.Yes, I've tried your app on Linux and all queries work fine. So, I simply remove tatamata's version and use your version.
JanSQL is very fast, i think it is good enough for small applications.I know, I've used the original janSQL a very long time ago.
When it does not work on your computer then maybe it is mac problem (especially date and time fields). Freepascal on Mac ignores your country settings. I put in my other program this at start:Yes, I think it's not right to use local data format settings in the database file because it will make the database not portable. If you bring a database that use '.' as decimal separator –for example– then when you open it on a system that use ',' as decimal separator, janSQL wouldn't able to read the data and arise an error. So, I think the correct approach is to use a consistent data format for the database, then use local data format to display the data. CMIIW.
{$IFDEF DARWIN} //German Dateformat FormatSettings.DateSeparator:='.'; DateSeparator:='.'; FormatSettings.LongDateFormat:='dddd, d. MMMM yyyy'; LongDateFormat:='dddd, d. MMMM yyyy'; FormatSettings.ShortDateFormat:='dd.MM.yyyy'; ShortDateFormat:='dd.MM.yyyy'; {$ENDIF}
Hello everybody.Re-uploaded compiled binaries and source code.
I have resurected MightyQuery program and refactored it a bit with CodeTyphon. You can download source code and compiled binaries here:
Source code (CodeTyphon v. 8.00):
https://matasoft.hr/MightyQuery.7z
Compiled binaries for Linux and Windows:
https://matasoft.hr/MightyQuery_Binary.7z
I intend to work on it in following weeks, I want to add merge/append feature, to be able to combine multiple csv files similar to what can be done in Microsft Power Query...