Re: [fpc-pascal] ann: new pascal magazine
Bee schreef: Hi all, There is a new pascal magazine at http://www.blaisepascal.eu/ It might a good place to promote FreePascal and its technologies, e.g. - fpc features and supported platforms - lazarus IDE - lazarus components - mobile programming (wince, symbian) - macOS support - web framework (powtils, fpweb) - db component (fcl-db) - pascal cross platform programming - morfik - etc. So, who's gonna start? ;) I noticed Lazarus already being promoted at the frontpage. Let's start with subscriptions (at only EUR 25) first! ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
[fpc-pascal] Get set IP Address
Exists there system calls to get the IP address of a computers network card (eth0, eth1, ...) And to set the IP Adress? Rainer ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] ann: new pascal magazine
Hey, his site is writen in PHP. :( --- Coco Pascal [EMAIL PROTECTED] wrote: Bee schreef: Hi all, There is a new pascal magazine at http://www.blaisepascal.eu/ It might a good place to promote FreePascal and its technologies, e.g. - fpc features and supported platforms - lazarus IDE - lazarus components - mobile programming (wince, symbian) - macOS support - web framework (powtils, fpweb) - db component (fcl-db) - pascal cross platform programming - morfik - etc. So, who's gonna start? ;) I noticed Lazarus already being promoted at the frontpage. Let's start with subscriptions (at only EUR 25) first! ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
[fpc-pascal] Re : function now shows bad date (-2 hours)
Got same issue. Problem on was my BIOS clock which were not at the correct time. This was hidden by the OS which showed correct hour (wrong timezone). Tom ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] ann: new pascal magazine
Hey, his site is writen in PHP. :( That makes pascal (fpc's) web framework should be the first article from us. ;) -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] fcl-db: oracle SP
That sqldb doesn't return data from a stored procedure is probably because it only tries to fetch data if the query starts with 'select' or 'show'. I'll have to add 'call' to that list for Oracle and do some tests. Where can I add 'call' for Oracle? TIA. -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] fcl-db: oracle SP
On Mon, 7 Apr 2008, Bee wrote: That sqldb doesn't return data from a stored procedure is probably because it only tries to fetch data if the query starts with 'select' or 'show'. I'll have to add 'call' to that list for Oracle and do some tests. Where can I add 'call' for Oracle? TIA. override TSQLConnection.StrToStatementType in TOracleCOnnection, and add it there. Michael. -Bee- has Bee.ography at: http://beeography.wordpress.com ___ 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] fcl-db: oracle SP
override TSQLConnection.StrToStatementType in TOracleCOnnection, and add it there. If I simply replace 'execute' with 'call' of StatementTokens constant within sqldb unit, then recompile FPC and Lazarus, would it work? It's just for testing to make sure it works before going further. -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] ann: new pascal magazine
Of course, just read the magazine and found anyone can contact them to publish an article. Maybe Lars can ask them to publish one of his own about Powtils. Leonardo. --- Bee [EMAIL PROTECTED] wrote: Hey, his site is writen in PHP. :( That makes pascal (fpc's) web framework should be the first article from us. ;) -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] fcl-db: oracle SP
No, because you would break other connection types. As I said, it's just for testing purpose and I don't use other connection type. But as far as I understand, it indeed doesn't work since stExecProcedure is never checked anyway. :( -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] fcl-db: oracle SP
override TSQLConnection.StrToStatementType in TOracleCOnnection, and add it there. I added this to oracleconnection.pp unit function TOracleConnection.StrToStatementType(s : string) : TStatementType; begin S:=Lowercase(s); if s = 'call' then exit(stSelect); result := inherited StrToStatementType(s); end; Recompiled my fpc 2.2.1, compilation went ok. Compile my test program, fine. Run the test program, it crashed. But now, instead of unknown AV, it raised a runtime error (EDatabaseError) with message: EDatabaseError : : Oracle returned error 24333:. The number means: ORA-24333: zero iteration count error. It's the same exact error message when I tried Zeos to access the same SP. I don't know what it means. I'm stucked, again. :( -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] fcl-db: oracle SP
override TSQLConnection.StrToStatementType in TOracleCOnnection, and add it there. BTW... 'select sf from dual' despite the syntax very common is still not working, raising an unhandled AV. I think it's more than just syntax or parsing problem. :( -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
[fpc-pascal] RSS?
Hi gents, Is this mailing list also available in RSS?? Thanks, Utku. ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] RSS?
On 07 Apr 2008, at 16:01, M. Utku Karataş wrote: Is this mailing list also available in RSS?? http://www.mail-archive.com/fpc-pascal@lists.freepascal.org/maillist.xml Jonas___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] fcl-db: oracle SP
BTW... 'select sf from dual' despite the syntax very common is still not working, raising an unhandled AV. I think it's more than just syntax or parsing problem. :( For a pipelined function, the syntax is : select * from table( sf() ) The other syntax ( 'select sf from dual' ) is for simple function , which returns single value. -- Inoussa O. ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] fcl-db: oracle SP
I'm new to Oracle. For a pipelined function, the syntax is : select * from table( sf() ) The other syntax ( 'select sf from dual' ) is for simple function , which returns single value. What's pipelined function? select * from table(sf()) seems to requires a table. Does an SF belong to a table? Ah, I need to dig more to Oracle manuals, obviously. :) -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] Why I?m choosing (Object) Pascal
Michael Van Canneyt [EMAIL PROTECTED] wrote: Hello, After a month (a bit more) of writing the above post, I finally released it in my blog: http://idkn.wordpress.com/2008/04/06/why-im-choosing-object-pascal/ Just one remark: Have a look at http://www.morfik.com/ - a great way to creat pascal web applications. No need for Perl/Ruby/Python. These tools are primitive when compared to what Morfik does for you. Michael. MS Windows only, otherwise it looks very interesting, although a bit pricey. No signs of support for other platforms? I must say that the very thought of creating web content with Pascal sounds like a dream compared to crappy languages like PHP. /Ingemar ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] Why I?m choosing (Object) Pascal
On Mon, Apr 7, 2008 at 7:04 PM, Ingemar Ragnemalm [EMAIL PROTECTED] wrote: Michael Van Canneyt [EMAIL PROTECTED] wrote: Hello, After a month (a bit more) of writing the above post, I finally released it in my blog: http://idkn.wordpress.com/2008/04/06/why-im-choosing-object-pascal/ Just one remark: Have a look at http://www.morfik.com/ - a great way to creat pascal web applications. No need for Perl/Ruby/Python. These tools are primitive when compared to what Morfik does for you. Michael. MS Windows only, otherwise it looks very interesting, although a bit pricey. No signs of support for other platforms? I must say that the very thought of creating web content with Pascal sounds like a dream compared to crappy languages like PHP. Yes, but I prefer open source over a company only product. I do not mind to pay for the tools, however, the past teaches us that business issues can effect badly needed tools, so at the end, you either have a product that does not follow the path you need, or a company that sopped making the product itself (someone killed it or something). /Ingemar ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal Ido -- http://ik.homelinux.org/ ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] fcl-db: oracle SP
2008/4/7, Bee [EMAIL PROTECTED]: I'm new to Oracle. For a pipelined function, the syntax is : select * from table( sf() ) The other syntax ( 'select sf from dual' ) is for simple function , which returns single value. What's pipelined function? select * from table(sf()) seems to requires a table. Does an SF belong to a table? A pipeline function is an Oracle way to create selectable SQL function , like the ones in MS SQL SERVER ( 2000+ ), or Firebird selectable stored procedure. Below is a simple Oracle sample : CREATE OR REPLACE TYPE TYPE_REC_A AS OBJECT( INT_FIELD NUMBER(6), STR_FIELD Varchar2(60) ) / CREATE OR REPLACE TYPE TYPE_TABLE_REC_A AS TABLE OF TYPE_REC_A / CREATE OR REPLACE FUNCTION FN_GET_LIST_A RETURN TYPE_TABLE_REC_A PIPELINED IS REC_ROW TYPE_REC_A ; BEGIN REC_ROW := TYPE_REC_A( 1, 'line 1' ); PIPE ROW ( REC_ROW ); REC_ROW := TYPE_REC_A( 2, 'line 2' ); PIPE ROW ( REC_ROW ); REC_ROW := TYPE_REC_A( 3, 'line 3' ); PIPE ROW ( REC_ROW ); RETURN; END; / select * from table( FN_GET_LIST_A() ) -- Inoussa O. ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] Why I?m choosing (Object) Pascal
On Mon, 7 Apr 2008, Ingemar Ragnemalm wrote: Michael Van Canneyt [EMAIL PROTECTED] wrote: Hello, After a month (a bit more) of writing the above post, I finally released it in my blog: http://idkn.wordpress.com/2008/04/06/why-im-choosing-object-pascal/ Just one remark: Have a look at http://www.morfik.com/ - a great way to creat pascal web applications. No need for Perl/Ruby/Python. These tools are primitive when compared to what Morfik does for you. Michael. MS Windows only, otherwise it looks very interesting, although a bit pricey. No signs of support for other platforms? I must say that the very thought of creating web content with Pascal sounds like a dream compared to crappy languages like PHP. Linux works (I did the port myself) but is still a bit rough on the deployment side, so they don't include it officially yet. And if linux works, the other platforms should work also (I took care of that during porting). Michael. ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] Get set IP Address
Rainer Stratmann yazmış: Exists there system calls to get the IP address of a computers network card (eth0, eth1, ...) And to set the IP Adress? Rainer ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal Synapse library would be useful for you I suppose. http://ararat.cz/synapse/doku.php This lib has some classes to achieve what you want if I remember correctly. Hope this helps.. Anil ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] Why I?m choosing (Object) Pascal
On 7 Apr 2008, at 20:07, Michael Van Canneyt wrote: On Mon, 7 Apr 2008, Ingemar Ragnemalm wrote: Linux works (I did the port myself) but is still a bit rough on the deployment side, so they don't include it officially yet. And if linux works, the other platforms should work also (I took care of that during porting). It looks very expensive still. $995 is a lot of money when compared to other frameworks (RAILS come to mind, and ASP.NET via Mono.) You also have to look at things like OpenLaszlo and Adobe Flex. If I was writing a RIA, Flex is the route I would take (passable IDE, nice enough language, very Powerful), runs on 90%+ of Intel based operating systems, including Mac OS X, LINUX and Windows. Also runs on many mobile phones and PDA's - N800/N810 (via full plugin), N series Symbian based phones and many others (via Flash Lite 3.0.) If you forgo the IDE, Flex is completely free. ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
Re: [fpc-pascal] Why I?m choosing (Object) Pascal
Linux works (I did the port myself) but is still a bit rough on the deployment side, so they don't include it officially yet. And if linux works, the other platforms should work also (I took care of that during porting). Wow! That's really a great news! How did you do the port, using Lazarus? If it's indeed run on Linux, I'll consider to purchase. Thanks, Michael. :) -Bee- has Bee.ography at: http://beeography.wordpress.com ___ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal