[fpc-devel] sqldb lazarus component

[alvise.nicoletti at siteland.it]

I did the 3 points you said, and got a lot rows like this from windows 
command line:
Processing unmaintained/mysql/Makefile.fpc
 i386-linux requires: rtl,mysql
 i386-go32v2 requires: rtl,mysql
 i386-win32 requires: rtl,mysql
 i386-os2 requires: rtl,mysql
 i386-freebsd requires: rtl,mysql
 i386-beos requires: rtl,mysql
 i386-netbsd requires: rtl,mysql
 i386-solaris requires: rtl,mysql
 i386-qnx requires: rtl,mysql
 i386-netware requires: rtl,mysql
 i386-openbsd requires: rtl,mysql
 i386-wdosx requires: rtl,mysql
 i386-darwin requires: rtl,mysql
 i386-emx requires: rtl,mysql
 i386-watcom requires: rtl,mysql
 i386-netwlibc requires: rtl,mysql
 i386-wince requires: rtl,mysql
 m68k-linux requires: rtl,mysql
 m68k-freebsd requires: rtl,mysql
 m68k-netbsd requires: rtl,mysql
 m68k-amiga requires: rtl,mysql
 m68k-atari requires: rtl,mysql
 m68k-openbsd requires: rtl,mysql
 m68k-palmos requires: rtl,mysql
 powerpc-linux requires: rtl,mysql
 powerpc-netbsd requires: rtl,mysql
 powerpc-amiga requires: rtl,mysql
 powerpc-macos requires: rtl,mysql
 powerpc-darwin requires: rtl,mysql
 powerpc-morphos requires: rtl,mysql
 sparc-linux requires: rtl,mysql
 sparc-netbsd requires: rtl,mysql
 sparc-solaris requires: rtl,mysql
 x86_64-linux requires: rtl,mysql
 x86_64-freebsd requires: rtl,mysql
 x86_64-win64 requires: rtl,mysql
 arm-linux requires: rtl,mysql
 arm-palmos requires: rtl,mysql
 arm-wince requires: rtl,mysql
 arm-gba requires: rtl,mysql
 powerpc64-linux requires: rtl,mysql
 Writing Makefile

After that i did a "make" having this errors:
Error makefile 2676: Command syntax error
Error makefile 2681: Command syntax error
Error makefile 2682: Command syntax error
Error makefile 2689: Command syntax error
Error makefile 2690: Command syntax error
Error makefile 2734: Command syntax error
Error makefile 2735: Command syntax error
Error makefile 2779: Command syntax error
Error makefile 2780: Command syntax error
Error makefile 2824: Command syntax error
Error makefile 2825: Command syntax error
Error makefile 2869: Command syntax error
Error makefile 2870: Command syntax error
Error makefile 2914: Command syntax error
Error makefile 2915: Command syntax error
Error makefile 2959: Command syntax error
Error makefile 2981: Command syntax error
Error makefile 2982: Command syntax error
Error makefile 2983: Command syntax error
*** 1426 errors during make ***

I'm using lazarus "recompiled for wince", found on that link:
http://wiki.lazarus.freepascal.org/index.php/Windows_CE_Interface
ftp://ftp.freepascal.org/pub/fpc/contrib/cross/gdb-6.4-win32-arm-wince.zip

I didn't compiled it myself, i'm not that good ;)

About the second part of your mail, in components\sqldb i found in the 
makefile.fpc "LCL_PLATFORM=win32"
Is it good to modify it at hand and try to "make" it?

If someone of you think that the compiled libraries would solve my 
problem, and have all the stuff
used to compile them, please give me a little hand and send me them, i 
can spend a month to try it without success.
I use linux at home and i know how to compile from makefiles, but here 
at work i'm using windows.

Thank you for any help.. in the meantime i'll go ahead with other tasks 
of that PocketPC application, hoping
that there is a solution to use mysql directly from it. If not, it would 
be so hard but i'll have to do a server/client
application to wrap the database data through other tcp protocols :'(

Bye,
Alvise
> The sqldb-components in sqldblaz are just a simple wrapper around the
> real sqldb-components. This wrapper is used by Lazarus, so you can drop
> the components on a form. 
>
> Your problem isn't that the sqldblaz.ppu isn't there, but that sqldb
> isn't compiled at all on a wince-target. So it's not available, and thus
> Lazarus can't build the wrapper.
>
> What you need is sqldb.ppu and mysqlconnXX.ppu. Now they aren't compiled
> for wince, because no-one tested it. But in principle, it should work.
>
> I think that you already compiled fpc by yourself. You can enable sqldb
> for wince by doing the following:
>
> 1: Edit fcl/db/Makefile.fpc and add sqldb to dirs_wince
> 2: Edit fcl/db/sqldb/Makefile.fpc and add mysql to dirs_wince
> 3: go to fcl/db and run the command 'fpcmake -r -Tall'
> 4: recompile fpc and see what happens.
>
> Maybe that you're lucky and that it will compile. If so, also compile
> the sqldblaz-package in lazarus. And then: try
>
> And for all: report your findings here. ;)
>
> On Tue, 2006-12-19 at 12:42 +0100, alvise.nicoletti at siteland.it wrote:
>   
>> Hi to all, and excuse me if i'm writing to the wrong list but i just 
>> subrscibed ;)
>>
>> I got a problem that i'm not able to resolve... i'm using lazarus and 
>> freepascal compiler tools to cross-compile a software i'm developing to 
>> a Pocket PC with Windows 2003 inside.
>>
>> The system is winCe (widget) and ARM (architecture). Thanks to lazarus 
>> all works, but i got a problem...
>>
>> The sqldb component have no libraries to (cross)compile in wince-arm 
>> architecture...
>> I need the sqldb component files:
>> registersqldb.o
>> sqldblaz.o
>> registersqldb.ppu
>> sqldblaz.ppu
>>
>> Compiled for arm-wince.
>>
>> I got the i386-win32 version under:
>> C:\apps\lazarus\components\sqldb\lib\i386-win32\
>>
>> But the arm-wince directory (in the lib directory) is empty.
>>
>> I write to you cause this component should be open source, but i'm not 
>> able neither to compile it or to find the source, and i know that Joost 
>> van der Sluis that should be the component author write in that mailing 
>> list.
>>
>> I apologize if i wrote something wrong and if i'm asking for help, but 
>> i'm in a bit hurry and i have to discover if i can make my Pocket PC 
>> connect to a local mysql database as soon as possible, or i'll be forced 
>> to use .net (bleah).
>>
>> Actually i have no problems to compile an executable application that 
>> works on it, but if i add SQLdb components i get, of course, compiling 
>> errors.
>> _______________________________________________
>> fpc-devel maillist  -  fpc-devel at lists.freepascal.org
>> http://lists.freepascal.org/mailman/listinfo/fpc-devel
>>
>>