Recent

Author Topic: LazSqlX  (Read 143647 times)

flamer0n

  • Guest
Re: LazSqlX
« Reply #30 on: October 18, 2013, 01:10:11 pm »
LazSqlX (v4.0.2.1270) new version available for download

What's new:
 - Data Importer (import data from delimited text file)
 - Script Create Table
 - Bug fixes


Download from SourceForge
https://sourceforge.net/projects/lazsqlx/files/Version%204.0.2.1270/LazSqlX_Setup.exe/download

JD

  • Hero Member
  • *****
  • Posts: 1848
Re: LazSqlX
« Reply #31 on: December 16, 2013, 09:39:19 am »
I just discovered this DM Admin project & I'm very impressed!  :D

Hats off to flamer0n for the good work. Nice to see a Linux version exists - an alternative to FlameRobin & TurboBird on Linux for a Firebird user like myself.

Looking forward to your publishing the source so we can all contribute (after you've removed your company's proprietary code, of course).

You still haven't added your applications to the Lazarus Application Gallery like BigChimp suggested. You ought to. It is very important so that we can show what one can do with Lazarus.

JD
« Last Edit: December 16, 2013, 09:42:05 am by JD »
Windows - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe),
Linux Mint - Lazarus 2.1/FPC 3.2 (built using fpcupdeluxe)

mORMot; Zeos 8; SQLite, PostgreSQL & MariaDB; VirtualTreeView

flamer0n

  • Guest
Re: LazSqlX
« Reply #32 on: December 16, 2013, 03:03:42 pm »
sorry JD and others, I've been busy i just uploaded the source codes. Please don't laugh at me :), LazSqlx has been started as a very small util for executing queries only, than adding little by little stuff there over time, it grew a bit more (along with me), and as you can notice, code is not very good structured, no pattern followed or whatsoever, a bit of spaghetti :), some things unfinished yet, very few comments... anyway I just hope you guys take care of the rest.

The big size of the archive is because of libs of DB clients there, sorry;

Here is the download link from source forge:
https://sourceforge.net/projects/lazsqlx/files/Sources/LazSqlX_Sources.zip/download

Components Used:

 - Zeos Db Components 7.1 Stable (3rd Party)
 - lazMouseAndKeyInput (in Lazarus components list)
 - lazDbExport (in Lazarus components list)

The rest are included by default in Lazarus IDE.

ps. I didn't add it to the project list of lazarus where BigChimp suggested because I forgot, sorry. I'm giving you the code (ok some stuff removed, but unnoticed) and please take care of the rest, of course who can and has will to do so, make it public on git or svn or whatever.

Thank you Lazarus community!
« Last Edit: December 16, 2013, 03:16:44 pm by flamer0n »

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #33 on: December 16, 2013, 03:07:23 pm »
Flamer0n, thanks a lot for that. About spaghetti code etc: I think we've all done this... or are doing this between posting messages on the forum ;)

Thanks again!
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

flamer0n

  • Guest
Re: LazSqlX
« Reply #34 on: December 16, 2013, 03:09:57 pm »
ps. for Linux version to work, ListBox of tables must be changed to=>  Style=lbStandard, (yeah I could have done it with compiler directives but I didn't), it's probably some bug, for linux only

flamer0n

  • Guest
Re: LazSqlX
« Reply #35 on: December 17, 2013, 03:05:23 pm »
 Has anyone managed to compile sources successfully? Just curious...

miab3

  • Full Member
  • ***
  • Posts: 145
Re: LazSqlX
« Reply #36 on: January 01, 2014, 01:50:48 pm »
@flamer0n

Quote
Has anyone managed to compile sources successfully? Just curious...

Yes I succeeded:
http://zeoslib.sourceforge.net/viewtopic.php?f=40&t=3795&p=25124#p25124

But I have a problem with the 64-bit Windows version.
At this building stops:
Code: [Select]
Forms\EditMemoFormU.pas(11,3) Hint: Unit "messages" not used in EditMemoFormU
DbInfo\AsSqlKeywords\AsSqlKeywords.pas(10,2) Warning: Illegal compiler directive "$STATIC"
DbInfo\AsSqlKeywords\AsSqlKeywords.pas(15,21) Hint: Unit "strutils" not used in AsSqlKeywords
Calling resource compiler "c:\codetyphon\fpc\bin\x86_64-win64\gorc.exe" with "/machine x64 /nw /ni /r /d FPC /fo .\DbInfo\AsSqlKeywords\AsSqlKeywords.res C:\lproj\LazSqlX_64\DbInfo\AsSqlKeywords\AsSqlKeywords.rc" as command line
Compiling resource C:\lproj\LazSqlX_64\DbInfo\AsSqlKeywords\AsSqlKeywords.rc
DbInfo\AsSqlKeywords\AsSqlKeywords.pas(161,1) Error: Error while compiling resources. Compile with -vd for more details. Check for duplicates.
DbInfo\AsSqlKeywords\AsSqlKeywords.pas(161,1) Fatal: There were 1 errors compiling module, stopping

Michal



BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #37 on: January 01, 2014, 01:53:07 pm »
If the .rc file is in a subdirectory of the .lpi file, it might be this bug:
http://bugs.freepascal.org/view.php?id=24483
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

miab3

  • Full Member
  • ***
  • Posts: 145
Re: LazSqlX
« Reply #38 on: January 01, 2014, 02:37:30 pm »
@BigChimp

Quote
If the .rc file is in a subdirectory of the .lpi file, it might be this bug:

So that was it.
I copied  resources files to .lpi directory and Windows-64 version builds and running.

Michal

Mike.Cornflake

  • Hero Member
  • *****
  • Posts: 1260
Re: LazSqlX
« Reply #39 on: January 02, 2014, 10:34:53 pm »
Has anyone managed to compile sources successfully? Just curious...

Many thanks for open sourcing this.  I've been offline for a few months.  I'll be trying this out sometime over the next weeks, and am looking forward to it.  I'm particularly keen to see how you use the Oracle Lite library, I'd love to bypass the need for Oracle Client installed.   

The app I spend most of my time has similar technical requirements for yours.  Yours is more geared around admin tasks, mine is extracting data from Master/Detail/(Detail) relationships from various databases.  I'm hoping there's enough commonality that we can share code :-)
« Last Edit: January 02, 2014, 10:39:09 pm by Mike.Cornflake »
Lazarus Trunk/FPC Trunk on Windows [7, 10]
  Have you tried searching this forum or the wiki?:   http://wiki.lazarus.freepascal.org/Alternative_Main_Page
  BOOKS! (Free and otherwise): http://wiki.lazarus.freepascal.org/Pascal_and_Lazarus_Books_and_Magazines

flamer0n

  • Guest
Re: LazSqlX
« Reply #40 on: July 18, 2014, 01:05:47 pm »
I just added LazSqlX to  :)
Lazarus Application Gallery

flamer0n

  • Guest
Re: LazSqlX
« Reply #41 on: September 06, 2014, 06:01:23 pm »
LazSqlX on Source Forge

v4.2.1

- Query Execution runs with SQLDB for MsSql,Oracle and Sqlite (except for Firebird and MySql). Expected result: Much more stability and improvement.
- Sqlite returns descriptive execution erros now (using sqldb)
-Guid fields are displayed correctly in a DbGrid when connected to MsSql,Oracle (using sqldb)
- some improvements and bugfixes in select query generation
- some improvements in autocompletion
- Query Execution now works as a thread
- A little bit of code refactorings

GUI:
-UI Tweaks
- TMemo field displays as text on DBGrid (thnx to a post here on forum)
- Grid PopUpMenu: SelectAll DBGridRows
- LoadingIndicator when queries are being executed (using TAnimatedGif)
-Syntax Check (using TSqlParser)

Mike.Cornflake

  • Hero Member
  • *****
  • Posts: 1260
Re: LazSqlX
« Reply #42 on: September 06, 2014, 07:55:42 pm »
Great news :-)
Lazarus Trunk/FPC Trunk on Windows [7, 10]
  Have you tried searching this forum or the wiki?:   http://wiki.lazarus.freepascal.org/Alternative_Main_Page
  BOOKS! (Free and otherwise): http://wiki.lazarus.freepascal.org/Pascal_and_Lazarus_Books_and_Magazines

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #43 on: September 06, 2014, 10:07:07 pm »
Nice, thanks a lot!

- Query Execution runs with SQLDB for MsSql,Oracle and Sqlite (except for Firebird and MySql). Expected result: Much more stability and improvement.
Could you indicate why you didn't switch to sqldb for Firebird? No time/too much effort? Something else?
Anything I can do to help (if I can)?
Want quicker answers to your questions? Read http://wiki.lazarus.freepascal.org/Lazarus_Faq#What_is_the_correct_way_to_ask_questions_in_the_forum.3F

Open source including papertiger OCR/PDF scanning:
https://bitbucket.org/reiniero

Lazarus trunk+FPC trunk x86, Windows x64 unless otherwise specified

flamer0n

  • Guest
Re: LazSqlX
« Reply #44 on: September 08, 2014, 09:37:41 am »
Yes, I had a problem connecting to a Firebird-2.5 database using SQLDB (on Win7):
"IBConnection1 : DoInternalConnect :  -unavailable database"
the thing is that Employee.fdb" exists, it's there and Zeos connects and runs queries against it without problems

 

TinyPortal © 2005-2018