Recent

Author Topic: LazSqlX  (Read 143667 times)

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #165 on: October 21, 2014, 01:51:20 pm »
@flameron has already provided all the required lib files in LazSQLx\Windows_Libs.  I see fbclient25.dll is in that collection :-)
Yes but AFAIR fbembed.dll is searched first. I've got a systemwide install in my path... so that's why I copied another fbembed.dll...
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

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #166 on: October 21, 2014, 01:52:00 pm »
Why on earth can that code create a SIGSEGV?

Any first field reference in a method can crash if the instance is not allocated or corrupt. If you typecast any pointer to a class and then run methods on it, chances are the crash behaviour will look like this. This is no different from Delphi btw.

And keep in mind that assigned() is only a test for zero, not general validity.
Yes got it thanks.
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

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #167 on: October 22, 2014, 01:33:38 pm »
Thanks for all the help everyone.

Improvements/fixes
- Mike.Cornflake fixed memory leaks
- cosmetic/layout
- File import auto mapping of field names; less memory use for large file import

Git patch (hope I did it right) - attached
All source files: https://bitbucket.org/reiniero/fpc_laz_patch_playground/downloads/LazSqlX_memleak_import2014_10_22.zip
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 #168 on: October 22, 2014, 02:07:29 pm »
Wow, so many posts n replies! Thank you guys!

Just pushed the changes to github LazSqlX

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #169 on: October 22, 2014, 02:10:37 pm »
Thanks a lot ;)

Flamer0n, do you mind if I try to remove the Jedi mouse and keyboard dependency in the code?
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 #170 on: October 22, 2014, 02:15:11 pm »
BigChimp no I don't, it's just the autocomplete won't be invoked after pressing "." after a table name or alias, but user must press ctrl+space which is not a big deal. Maybe it was lame simulating ctrl+space to invoke the autocomplete but I didn't know how else to do it

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #171 on: October 22, 2014, 02:21:53 pm »
Ok. I'll see if I can find another way...
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

goldenfox

  • New Member
  • *
  • Posts: 47
Re: LazSqlX
« Reply #172 on: October 22, 2014, 03:17:22 pm »
This is a really nice project. Good job!

Zath

  • Sr. Member
  • ****
  • Posts: 391
Re: LazSqlX
« Reply #173 on: October 22, 2014, 03:59:58 pm »
Well, after reading through all these latest posts, it's like you're all Elders and Gavins to me but it's good to see things are getting resolved as this is a very useful project for me.

On another matter, what happens if it's mutton dressed as lamb ? How many pigeons would that be equivalent to and are they wood pigeons or town pigeons because wood pigeons are more like chicken in size anyway !

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #174 on: October 22, 2014, 04:07:54 pm »
On another matter, what happens if it's mutton dressed as lamb ?
:)

Well, I like mutton. It's got a nice, robust flavour. To each his own, of course ;)
Re the pigeons - definitely town pigeons in my case...
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

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #175 on: October 23, 2014, 03:22:05 pm »
Ok, with thanks to martin_fr I think I've got the code completion stuff sorted. Now going on fixing my own fileimport code that is skipping records/fields <blush>... as well as some miscellaneous fixes/improvements as I go along.

I'll send an ehm... carrier pigeon when I'm done ;)
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

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #176 on: October 24, 2014, 11:24:15 am »
Ok, done. Turns out it is rather easy to generate a patch set from local commits in git:
Code: [Select]
git format-patch -M origin/master

A zip with patches that:
* Fix import skipping data (sorry, my fault)
* Improves import GUI while importing
* Removes mouse and keyboard unit dependency for sql editor (thanks Martin_fr)
* Cosmetic fixes
* Unifies debug format to dwarf2 with sets as stabs is very ancient and not very informative
* Small code fixes; please see patch description for details
* Removes binary files from repository that should not be there (e.g. .dcu files)

Download
https://bitbucket.org/reiniero/fpc_laz_patch_playground/downloads/PatchesFixImportRemoveMouseKeyboard.zip
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 #177 on: October 24, 2014, 04:49:25 pm »
thanks to everyone for helping

 Just made a minor change on key handling:

 *vk_oem_period handling left in OnKeyUp and
 *ssCtrl+vk_space handling moved to onKeyDown

reason: "." has to be inserted before autocomplete happens but in case of ctrl+space the autocomplete first should be executed;

git is up to date



flamer0n

  • Guest
Re: LazSqlX
« Reply #178 on: October 24, 2014, 05:05:52 pm »
 currently working on new editForm for table data. It will be generated at runtime according to table properties (field types,references to other tables). Made some new dbcontrols for that etc/

BigChimp

  • Hero Member
  • *****
  • Posts: 5740
  • Add to the wiki - it's free ;)
    • FPCUp, PaperTiger scanning and other open source projects
Re: LazSqlX
« Reply #179 on: October 24, 2014, 05:07:04 pm »
Thanks a lot! Good luck with the form.
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

 

TinyPortal © 2005-2018