Needed: Complete, working Lazarus example for desktop database access
in Linux
lazarus / 16-Databases

----------------------------------------------------------------------
dkjMusic · 2010-11-15 14:56

I would like to find the above, with a sample desktop database file,
so I can learn the basics.

I have spent nearly a week searching in vain for such a beast. The
examples I have found either don't work or require more than I know
about, e.g., connecting to a SQL server database.

I have an MS Access database on my desktop that I want to write some
Lazarus code to query. unixODBC was a bust, and I am guessing I can
find a way to export the mdb to a CSV file and import it into the db
format used by a WORKING example program.

I would really appreciate any help provided.

----------------------------------------------------------------------
raulparraco · 2010-11-17 02:54

http://facturlinex.sourceforge.net/

----------------------------------------------------------------------
davesimplewear · 2010-11-17 08:00

go to my website, nearly all are working examples of desktop db's
http://www.users.on.net/~dave.stewart/

----------------------------------------------------------------------
dkjMusic · 2010-11-17 15:44

Quote from: davesimplewear on November 17, 2010, 09:00:16 amgo to my
website, nearly all are working examples of desktop db's
http://www.users.on.net/~dave.stewart/

  Thank you so much. That is exactly what I've been looking for. I
started with the Address project, but when I opened address.lpi, I got
a message saying: Unable to find the unit of component class
"TfrDBDataSET". What should I do?

----------------------------------------------------------------------
dkjMusic · 2010-11-17 16:20

Quote from: dkjMusic on November 17, 2010, 04:44:58 pmQuote from:
davesimplewear on November 17, 2010, 09:00:16 amgo to my website,
nearly all are working examples of desktop db's
http://www.users.on.net/~dave.stewart/

  Thank you so much. That is exactly what I've been looking for. I
started with the Address project, but when I opened address.lpi, I got
a message saying: Unable to find the unit of component class
"TfrDBDataSET". What should I do?

Never mind. I tracked the component to the LazReport package which I
did not have installed. I installed and the address.lpi loaded w/o a
hitch. Man, is it difficult to get Lazarus to let go of a buggered
project.

----------------------------------------------------------------------
dkjMusic · 2010-11-17 16:39

Now when I run the project in Lazarus and select File/Exit, the
program breaks at the Close statement in TfPim.mmExitClick. How come?

----------------------------------------------------------------------
davesimplewear · 2010-11-17 18:02

that is the routine to close the program, when you say it breaks there
are you debuging?

----------------------------------------------------------------------
dkjMusic · 2010-11-18 15:14

Quote from: davesimplewear on November 17, 2010, 07:02:12 pmthat is
the routine to close the program, when you say it breaks there are you
debuging?

Yes, I must be. The Lazarus window title had (debugging...) at the
end.

I just deleted the routine then typed the code back in and it exited
without stopping there. Maybe a breakpoint was in the original?

Thanks for your help.

----------------------------------------------------------------------
mangade · 2010-11-21 02:12

Thank you for your example code. i really newbie and want to know more
about lazarus and firebird.

Thank you.