Re: [fpc-pascal] [Lazarus] FreePascal and Lazarus Foundation

[Tony Caduto]

What events of the last few days is Boian talking about in his announcement?
On Jun 27, 2016 5:51 AM, "Victor Campillo" 
wrote:

On 27/06/16 10:00, Michael Van Canneyt wrote:

How did you manage to find this site ? I didn't make a public announcement
yet :-)

But seems that somebody else did it, see this post of Boian Mitov
https://plus.google.com/+BoianMitov/posts/46r34KmgrdQ.


Anyway, I am very happy with the announcement, this could be a great push
for the community.

Best Regards.

-- 
Victor Campillo


___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Sqldb - How to pass an array of values as a param to be used with SQL IN operator?

[Tony Caduto]

Well, I guess if there is no user input going into the query it's not a big
dea,l of course if there is you should at least sanitize it to prevent
injection.
On Apr 10, 2016 2:39 PM, "Luiz Americo Pereira Camara" <
luizameri...@gmail.com> wrote:

>
>
> 2016-04-10 16:29 GMT-03:00 Tony Caduto <tony.cad...@gmail.com>:
>
>> What about using a stored procedure to do it ?  You could pass the list
>> for the in as a string and handle it in the stored procedure.  Of course
>> that's no help if using sqlite or other that does not support stored
>> procedures.
>>
>
> I'm working with multiple DB engines, so i try to avoid non standard
> syntax/features.
> My workaround is working fine, so no need to break this rule
>
> Luiz
>
> ___
> fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Sqldb - How to pass an array of values as a param to be used with SQL IN operator?

[Tony Caduto]

What about using a stored procedure to do it ?  You could pass the list for
the in as a string and handle it in the stored procedure.  Of course that's
no help if using sqlite or other that does not support stored procedures.
On Apr 10, 2016 1:39 PM, "Stephen Chrzanowski" <pontia...@gmail.com> wrote:

The problem with that Tony is that the the bind might make :myparam a
string, so you'll be doing a 1-integer to 1-string comparison, which won't
give you any results.  Essentially you'll be asking for a list of results
whos field is equal to "1,2,3,4", not a list of results in which the field
in question contains the numbers 1, or 2, or 3, or 4.

At OP

Due to the nature of the bind mechanism, you won't be able to do it this
way.  The only way you'll be able to do that is with your program doing
string substitution instead of doing the bind.  Since you're dealing with
integers only, you'll just need to make sure that every entry you're
substituting for is actually an integer.


On Sun, Apr 10, 2016 at 10:01 AM, Tony Caduto <tony.cad...@gmail.com> wrote:

> Did you try putting quotes around the param ID in the sql query?
> in(":myparam")
> I am guessing it's the commas that are the problem.
>
> Sqlite will accept double qoutes as will MySQL postgres will not though.
> On Apr 10, 2016 7:40 AM, "leledumbo" <leledumbo_c...@yahoo.co.id> wrote:
>
>> > But until now i havent figured a way to pass an array of values (mostly
>> integers) to be used with IN operators.
>>
>> That, unfortunately, is not possible. It's a DBMS limitation,
>> parameterized
>> values are actually passed as is to DBMS. So there's nothing you can do
>> unless you can convince DBMS maintainer to implement it.
>>
>> > Is there a way to accomplish this?
>>
>> No other way than direct formatting for now.
>>
>>
>>
>>
>> --
>> View this message in context:
>> http://free-pascal-general.1045716.n5.nabble.com/Sqldb-How-to-pass-an-array-of-values-as-a-param-to-be-used-with-SQL-IN-operator-tp5724873p5724874.html
>> Sent from the Free Pascal - General mailing list archive at Nabble.com.
>> ___
>> fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
>> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>>
>
> ___
> fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>


___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Sqldb - How to pass an array of values as a param to be used with SQL IN operator?

[Tony Caduto]

Did you try putting quotes around the param ID in the sql query?
in(":myparam")
I am guessing it's the commas that are the problem.

Sqlite will accept double qoutes as will MySQL postgres will not though.
On Apr 10, 2016 7:40 AM, "leledumbo"  wrote:

> > But until now i havent figured a way to pass an array of values (mostly
> integers) to be used with IN operators.
>
> That, unfortunately, is not possible. It's a DBMS limitation, parameterized
> values are actually passed as is to DBMS. So there's nothing you can do
> unless you can convince DBMS maintainer to implement it.
>
> > Is there a way to accomplish this?
>
> No other way than direct formatting for now.
>
>
>
>
> --
> View this message in context:
> http://free-pascal-general.1045716.n5.nabble.com/Sqldb-How-to-pass-an-array-of-values-as-a-param-to-be-used-with-SQL-IN-operator-tp5724873p5724874.html
> Sent from the Free Pascal - General mailing list archive at Nabble.com.
> ___
> fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] FPC generated executables and digital signatures

[Tony Caduto]

It only does that if the exe is executed from a location windows deems
unsafe.
Even on Windows 10 my laz exes work fine with no publisher warning but as
soon as you try from a network mapped drive or a UNC location bam you get
the warning.
On Apr 8, 2016 8:39 AM, "OBones" <obo...@free.fr> wrote:

> If the exe is unsigned, then Windows will complain everytime it is run.
> If it is signed with a fully resolved certificate (not a self created
> one), then it will show the publisher in the dialog and depending on your
> security settings will either ask you if you want to be asked the next time
> or not ask you at all.
>
> But this only works with paid for certificates that can trace back to one
> of the recognized CAs.
>
> Tony Caduto wrote:
>
>>
>> Graeme,
>>
>> Glad to help, that's always annoyed me as well but have never had time to
>> fully investigate it, I imagine it's due to a signing issue like you
>> originally thought.
>> If you find anything out let us know 
>>
>> On Apr 8, 2016 8:01 AM, "Graeme Geldenhuys" <
>> mailingli...@geldenhuys.co.uk <mailto:mailingli...@geldenhuys.co.uk>>
>> wrote:
>>
>> On 2016-04-08 13:51, Tony Caduto wrote:
>> > I only get that if I run the exe from a shared network drive on
>> Windows 7
>> > and up.
>>
>> Ha, that was the problem! My Win7 is a VirtualBox VM, and my
>> source code
>> is on a VirtualBox shared folder (mapped to a drive letter in Windows
>> 7).  If I copy that executable to the C: drive, then in runs
>> without the
>> warning dialog.
>>
>> What is the point of that? A drive letter is a drive letter. Why
>> does it
>> make a difference to Windows it that drive is local, or a network
>> drive?
>>
>> At least now we found the cause of the problem. Thanks Tony. It least
>> now I know this will not happen on every Windows system. Now to figure
>> out a solution (eventually).
>>
>> Regards,
>>   - Graeme -
>>
>> --
>> fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
>> http://fpgui.sourceforge.net/
>>
>> My public PGP key: http://tinyurl.com/graeme-pgp
>> ___
>> fpc-pascal maillist  - fpc-pascal@lists.freepascal.org
>> <mailto:fpc-pascal@lists.freepascal.org>
>> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>>
>>
>>
>> ___
>> fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
>> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>>
>
> ___
> fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] FPC generated executables and digital signatures

[Tony Caduto]

Graeme,

Glad to help, that's always annoyed me as well but have never had time to
fully investigate it, I imagine it's due to a signing issue like you
originally thought.
If you find anything out let us know 
On Apr 8, 2016 8:01 AM, "Graeme Geldenhuys" <mailingli...@geldenhuys.co.uk>
wrote:

On 2016-04-08 13:51, Tony Caduto wrote:
> I only get that if I run the exe from a shared network drive on Windows 7
> and up.

Ha, that was the problem! My Win7 is a VirtualBox VM, and my source code
is on a VirtualBox shared folder (mapped to a drive letter in Windows
7).  If I copy that executable to the C: drive, then in runs without the
warning dialog.

What is the point of that? A drive letter is a drive letter. Why does it
make a difference to Windows it that drive is local, or a network drive?

At least now we found the cause of the problem. Thanks Tony. It least
now I know this will not happen on every Windows system. Now to figure
out a solution (eventually).

Regards,
  - Graeme -

--
fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
http://fpgui.sourceforge.net/

My public PGP key:  http://tinyurl.com/graeme-pgp
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] FPC generated executables and digital signatures

[Tony Caduto]

I only get that if I run the exe from a shared network drive on Windows 7
and up.  Maybe your not enabling the manifest, the laz ide does it
automatically for win32.
On Apr 8, 2016 6:20 AM, "Graeme Geldenhuys" 
wrote:

> Hi,
>
> I don't visit Windows much, but was doing some testing on a Win7 VM.
> Every time I run my FPC generated executable I get a Security Warning
> dialog pop up and it mentions a "Unknown Publisher", and I have to then
> click the 'Run' button before my application runs.
>
> Does anybody know what is required to get rid of this Security Warning?
> Like I said, I don't know which much, and when I do us Windows, it's
> normally Win2000 which doesn't have this issue.
>
> Regards,
>   - Graeme -
>
> --
> fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
> http://fpgui.sourceforge.net/
>
> My public PGP key:  http://tinyurl.com/graeme-pgp
> ___
> fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Bug in FPC 3.0.0 (was: Bug in FPC 3.0.0?)

[Tony Caduto]

I have the latest version of Devart pgdac and virtualtable.pas compiles
fine.
On Feb 23, 2016 3:33 AM, "Serguei TARASSOV"  wrote:

> Hello,
>
> Sorry, my previous example was not complete.
> Here is a problem detected when compiling UniDAC 6.2.8.
> Taken from real code in VirtualTable.pas
>
> program Project1;
>
> {$MODE DELPHI}
>
> uses
>   SysUtils, Classes, DB;
>
> procedure InternalCreateFieldDefs(Fields: TFields; FieldDefs: TFieldDefs);
> var
>   F: TField;
>   FieldDef: TFieldDef;
> begin
>   begin
> with F do
> begin
>   FieldDef := FieldDefs.AddFieldDef;
>   // in FPC 3.0.0 Error: No member is provided to access property
>   // in FPC 2.6.4 compiles OK
> end;
>   end;
> end;
>
> begin
> end.
>
>
>
>
> -
> --
> Regards,
> Serguei
> --
> View this message in context:
> http://free-pascal-general.1045716.n5.nabble.com/Bug-in-FPC-3-0-0-was-Bug-in-FPC-3-0-0-tp5724274.html
> Sent from the Free Pascal - General mailing list archive at Nabble.com.
> ___
> fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal
>
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Delphi compiler team left Embarcadero/Idera

[Tony Caduto]

Hmm maybe sad for Delphi users, I myself have not used Delphi since 2012,
hopefully Delphi users see the light and start using Lazarus and FPC.

It's not surprising that people are leaving embarcadero, it sucks being on
the end of a dirty acquisition stick
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] Issue with Linking

[Tony Caduto]

Msmw.amaal
On Aug 19, 2015 4:02 PM, Chris Moody inqu...@greensnakedesign.com wrote:

 Hi all,

 So I reset up my Pi and I was able to get the current version of FPC to
 get as far as the linking stage, at which point it shows this:

 /usr/bin/ld: warning: link.res contains output sections; did you forget -T?
 /home/pi/fpc-2.6.4/lib/fpc/2.6.4/units/arm-linux/rtl/cprt0.o: In function
 `_haltproc_eabi':
 (.text+0x88): undefined reference to `_fini'
 /home/pi/fpc-2.6.4/lib/fpc/2.6.4/units/arm-linux/rtl/cprt0.o: In function
 `_haltproc_eabi':
 (.text+0x90): undefined reference to `_init'
 Dentist.pas(106) Error: Error while linking
 Dentist.pas(106) Fatal: There were 1 errors compiling module, stopping
 Fatal: Compilation aborted
 Error: /home/pi/fpc-2.6.4/bin/ppcarm returned an error exitcode (normal if
 you did not specify a source file to be compiled)

 I'm not sure how to fix this. If anyone can assist, it would be greatly
 appreciated.

 Thanks once again,

 Chris
 ___
 fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
 http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] MigraterrrrRzr t ttt f bug tracker bugtracker

[Tony Caduto]

_2bt
On Aug 5, 2014 2:37 AM, Graeme Geldenhuys mailingli...@geldenhuys.co.uk
wrote:

 On 2014-08-04 08:21, Michael Van Canneyt wrote:
  Since 500 million records do not fit in memory,

 Time for a RAM upgrade. ;-)


 Regards,
   - Graeme -

 --
 fpGUI Toolkit - a cross-platform GUI toolkit using Free Pascal
 http://fpgui.sourceforge.net/
 ___
 fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
 http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] newbie question: using fpc in linux

[Tony Caduto]

If your just doing Web Development you can cross compile for linux on
windows,  it's not that bad,  you do need to build the cross compiler and
then copy some of the linux libs to your development pc.  It's totally
possible and then you just copy the compiled app to your server,  you don't
need fpc on the server at all
On Apr 3, 2013 9:50 AM, duilio foschi duiliofos...@euplan.com wrote:


 thanks to your suggestions, I could compile and successfully test the
 'hello world' code that comes with the brook framework.

 Now I am ready to wet my feet in the world of web programming.

 In my company we have a few dedicated (remote) servers running linux.

 And (when I will be able to get real applications) these applications will
 run on these remote servers.

 In my company, linux is not used on local PCs... but it would not be hard
 to get a local linux box if needed.

 Using 'nano' editor from a Bitwise XTerm (as I do now) does not look the
 most productive environment.

 Which tools (editors, GUIs) do you use when programming in Linux ?

 I guess you all use a local linux box, right ?

 Thank you
 Duilio


 ___
 fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
 http://lists.freepascal.org/mailman/listinfo/fpc-pascal

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

Re: [fpc-pascal] TurboPower FlashFiler for Free Pascal

[Tony Caduto]

I would say it's a decent database as nexus db for Delphi is a fork of it.
But why not use sqlite?  It can be fully embedded as well,  there is at
least 1 Delphi sqlite component set that does not require the sqlite dll.
On Oct 23, 2012 8:25 AM, Graeme Geldenhuys gra...@geldenhuys.co.uk
wrote:

 Hi,

 Yeah, a catchy title!  ;-)

 I want to know if anybody here has ever used FlashFiler in Delphi. Was
 it a good product, and do you think it would be worth the effort porting
 it to Free Pascal?  Or is FlashFiler simply too old and outdated.

 I mainly use Firebird RDBMS for all my database needs and think it is
 excellent. I use it in client/server and embedded form under Linux and
 Windows.

 But I am also intrigued by the idea of having a true embedded database
 server - compiled directly into my executable for even easier deployment.

 Any thoughts on this?  Has anybody else started such a port?

 Regards,
   - Graeme -
 ___
 fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
 http://lists.freepascal.org/mailman/listinfo/fpc-pascal

___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

[fpc-pascal] cross compiler linker issue win32 to Linux

[Tony Caduto]

Hi,
I have the cross compiler setup(win32 to linux) and I can compile most of
my apps just fine except for
one that is a daemon and uses cthreads and cmem in the uses.

It does not give any errors except for linker error and if I change the
verbosity to show all
it still does not show anything meaningful.
The app won't run on Ubuntu server unless I have cthreads in the uses,
otherwise it gives a mutex error about
two many threads.

Here is the linker errors:

Linking project1
Searching file C:\lib\crtend.o... not found
Searching file C:\Users\20659\Documents\Lazarus
Projects\i386-linux-gnu\crtend.o... not found
Searching file C:\Users\20659\Documents\Lazarus
Projects\usr\lib\i386-linux-gnu\crtend.o... not found
Searching file C:\Users\20659\vbox_share\4.6\crtend.o... found
Searching file C:\lib\crtn.o... not found
Searching file C:\Users\20659\Documents\Lazarus
Projects\i386-linux-gnu\crtn.o... not found
Searching file C:\Users\20659\Documents\Lazarus
Projects\usr\lib\i386-linux-gnu\crtn.o... found
Searching file c:\codetyphon\fpc\bin\i386-linux\i386-linux-ld.exe... not
found
Searching file C:\codetyphon\fpc\bin\i386-win32\i386-linux-ld.exe... found
Using util C:\codetyphon\fpc\bin\i386-win32\i386-linux-ld.exe
project1.lpr(16,1) Error: Error while linking
project1.lpr(16,1) Fatal: There were 1 errors compiling module, stopping
Fatal: Compilation aborted
Error: C:\codetyphon\fpc\bin\i386-win32\ppc386.exe returned an error
exitcode


Anyone have any ideas on how I can get this working?  I have all the
libpthread shared objects copied over to the windows system.

Thanks
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal

[fpc-pascal] tzipper issue(zipper.pp)

[Tony Caduto]

Hi,
I am trying to port a Delphi app to Freepascal/Lazarus.
The original app zipped the contents of a memo(using vclzip) which was
saved to a stream, and the zip does not get stored in a file, rather a
tmemorystream, which
is then sent to a client app via a socket.

So I noticed the tzipper class in 2.6.x has the ability to save to stream
and this works, but it forces you to write the zip to a file first as you
have to provide a filename, and if you don't provide a filename it raises a
exception.

Unless I missed something, this seems odd that you have to write to a file
in order to save to a stream.

Thanks,

Snorkel
___
fpc-pascal maillist  -  fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal