Recent

« previous next »
Pages: [1]

Author Topic: JanSQL for Lazarus  (Read 10116 times)

tatamata

  • Hero Member
  • *****
  • Posts: 787
    • ZMSQL - SQL enhanced in-memory database
JanSQL for Lazarus
« on: December 30, 2008, 09:16:10 am »
Hello.
I have tried to port JanSQL(www.jansfreeware.com) to Lazarus.
Only one error remained, regarding procedural function, but I don't know to solve it. It is probably trivial.
Could someone take a look?
You can download it from:
http://matalab.freehostia.com/JanSQLLazarus.zip

Thanks.
Logged

Marc

  • Administrator
  • Hero Member
  • *
  • Posts: 2584
Re: JanSQL for Lazarus
« Reply #1 on: December 30, 2008, 09:51:25 am »
If you post the problem line here I might have a look. I don't want to download and instal and try whole packages.
Logged
//--
{$I stdsig.inc}
//-I still can't read someones mind
//-Bugs reported here will be forgotten. Use the bug tracker

Leledumbo

  • Hero Member
  • *****
  • Posts: 8757
  • Programming + Glam Metal + Tae Kwon Do = Me
Re: JanSQL for Lazarus
« Reply #2 on: December 30, 2008, 10:03:47 am »
Quote
Only one error remained, regarding procedural function
Have you put {$mode delphi} on top of the unit? Remember that under Delphi you don't need @ when assigning a procedural variable, but you do under FPC (strictness, I love it).
Logged

bee

  • Sr. Member
  • ****
  • Posts: 393
Re: JanSQL for Lazarus
« Reply #3 on: December 30, 2008, 10:15:58 am »
It has been done. Check out http://freepascal.org/contrib/db.php3?category=Database and look for laz-tjansql. I did it long time ago and I never use it again since then. It may have some problems with newer FPC/Lazarus. :)

Logged
-Bee-

A long time pascal lover.

tatamata

  • Hero Member
  • *****
  • Posts: 787
    • ZMSQL - SQL enhanced in-memory database
Re: JanSQL for Lazarus
« Reply #4 on: December 30, 2008, 10:29:28 am »
I get it, I missed to put {$H+}. It works now. Thanks.
Logged

tatamata

  • Hero Member
  • *****
  • Posts: 787
    • ZMSQL - SQL enhanced in-memory database
Re: JanSQL for Lazarus
« Reply #5 on: December 30, 2008, 10:33:13 am »
Bee,
Yes, I know for your contrib. In fact I used it.
The problem I experienced is that JanSQL retrieves only first row when query contains more than one table.
I thought it was due to a bug in your conversion project, since original Delphi JanSQL queries tables correctly.
But, now, after I did my own conversion, it seems the problem is due something in FPC or Lazarus that behaves differently than in Delphi...
If you have time, please take a look.
Logged

tatamata

  • Hero Member
  • *****
  • Posts: 787
    • ZMSQL - SQL enhanced in-memory database
Re: JanSQL for Lazarus
« Reply #6 on: January 06, 2009, 11:22:04 am »
Here is the link for downloading ported JanSQL (ported by Bee):
http://matalab.freehostia.com/laz-jansql.zip

If anyone is interested to check it out, why it behaves this way...
Logged

theo

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 1927
Re: JanSQL for Lazarus
« Reply #7 on: January 06, 2009, 02:20:19 pm »
Quote from: tatamata on January 06, 2009, 11:22:04 am
Here is the link for downloading ported JanSQL (ported by Bee):
http://matalab.freehostia.com/laz-jansql.zip

If anyone is interested to check it out, why it behaves this way...

Not Found
The requested URL /laz-jansql.zip was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Apache/1.3.33 Server at matalab.freehostia.com Port 80
Logged

tatamata

  • Hero Member
  • *****
  • Posts: 787
    • ZMSQL - SQL enhanced in-memory database
Re: JanSQL for Lazarus
« Reply #8 on: January 06, 2009, 02:27:39 pm »
Oh, it must be with "SQL" capitals:
http://matalab.freehostia.com/laz-janSQL.zip
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018