Re[2]: [Harbour] Re: How to simulate select ... where ... order by ...limit ... offset

2009-06-17 Thread Jacek Kubica
Hello Mindaugas, Tuesday, June 09, 2009, 4:47:35 PM, you wrote: >> Im looking also for example how to connect to Firebird using sddfb. MK>RDDINFO(RDDI_CONNECT, {"FIREBIRD",, user, password, database}) MK> I was writing SDDFB right after SDDMY, so I wanted to keep, form: MK>RDDINFO(RDDI_

Re: [Harbour] Re: How to simulate select ... where ... order by ...limit ... offset

2009-06-09 Thread Viktor Szakáts
RDDINFO(RDDI_CONNECT, {"FIREBIRD", database, user, password}) can be a good alternative. Opinions? AFAIR in FB the "database" string will include the server in '' format. Brgds, Viktor ___ Harbour mailing list Harbour@harbour-project.org http://list

Re: [Harbour] Re: How to simulate select ... where ... order by ...limit ... offset

2009-06-09 Thread Mindaugas Kavaliauskas
Hi, I`m trying to do it but without success ;-( using : ? "Connect:", RDDINFO( RDDI_CONNECT, { "ODBC", "Driver=Microsoft ODBC Driver for Oracle;SERVER=KS_172.16.0.13;Uid={user};Pwd={pass}" } ) Does this print ".F."? Actually I know nothing about ODBC :) , except that it accepts one long conn

Re: [Harbour] Re: How to simulate select ... where ... order by ...limit ... offset

2009-06-09 Thread Jacek Kubica
Hello Mindaugas, Tuesday, June 09, 2009, 2:12:39 PM, you wrote: MK> Horodyski Marek (PZUZ) wrote: >> Else // Oracle MK> Hi, Marek, MK> have you managed to use sddodbc on Oracle? MK> Regards, MK> Mindaugas I`m trying to do it but without success ;-( using : ? "Connect:", RDDINFO( RDDI_CONNECT,

[Harbour] Re: How to simulate select ... where ... order by ...limit ... offset

2009-06-09 Thread Alexander S.Kresin
Here isn't join, subselect, acces to remote table and many othes things. It doesn't support the keyword "JOIN" - probably, because this keyword wasn't included in SQL standard at the time when it was written, but it supports the join operation itself: select table1.num, table2.name, ... fr

Re: [Harbour] Re: How to simulate select ... where ... order by ...limit ... offset

2009-06-09 Thread Mindaugas Kavaliauskas
Horodyski Marek (PZUZ) wrote: Else // Oracle Hi, Marek, have you managed to use sddodbc on Oracle? Regards, Mindaugas ___ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour

RE: [Harbour] Re: How to simulate select ... where ... order by ...limit ... offset

2009-06-09 Thread Horodyski Marek (PZUZ)
>-Original Message- >From: Alexander S.Kresin [mailto:a...@belacy.belgorod.su] >Sent: Tuesday, June 09, 2009 1:03 PM >To: Harbour Project Main Developer List. >Subject: [Harbour] Re: How to simulate select ... where ... >order by ...limit ... offset > > > If

Re: [Harbour] Re: How to simulate select ... where ... order by ... limit ... offset

2009-06-09 Thread Vailton Renato
Very cool code!! Many thanks! Vailton ___ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour

Re: [Harbour] Re: How to simulate select ... where ... order by ... limit ... offset

2009-06-09 Thread Massimo Belgrano
Thanks it is instresting I invite anybody produce and post here any kind sample with this product 2009/6/9 Alexander S.Kresin : >  > If it's not a problem, you may send it to the list, probably >> >> it would be useful for other developers, or even for Harbour. >> > >  Attached. > > Regards, Alexa

Re: [Harbour] Re: How to simulate select ... where ... order by ... limit ... offset

2009-06-09 Thread Viktor Szakáts
Thanks a lot. Brgds, Viktor On 2009.06.09., at 13:03, Alexander S.Kresin wrote: > If it's not a problem, you may send it to the list, probably it would be useful for other developers, or even for Harbour. Attached. Regards, Alexander. ___ Harbour

[Harbour] Re: How to simulate select ... where ... order by ... limit ... offset

2009-06-09 Thread Alexander S.Kresin
Yes please. Sent to your private email. Regards, Alexander. ___ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour

Re: [Harbour] Re: How to simulate select ... where ... order by ... limit ... offset

2009-06-09 Thread Viktor Szakáts
Hi Alexander, If it's not a problem, you may send it to the list, probably it would be useful for other developers, or even for Harbour. Brgds, Viktor On Tue, Jun 9, 2009 at 11:56 AM, Lorenzo Fiorini wrote: > On Tue, Jun 9, 2009 at 9:53 AM, Alexander > S.Kresin wrote: > >>  I had wrote a set of

Re: [Harbour] Re: How to simulate select ... where ... order by ... limit ... offset

2009-06-09 Thread Lorenzo Fiorini
On Tue, Jun 9, 2009 at 9:53 AM, Alexander S.Kresin wrote: >  I had wrote a set of functions many years ago, which interprets the full > "select ..." query and executes it. The "LIMITS" clause isn't interpreted, > though, because I never heard about it. >  I can send you working source file, if you

[Harbour] Re: How to simulate select ... where ... order by ... limit ... offset

2009-06-09 Thread Alexander S.Kresin
Lorenzo, ... I know the index to use so I can use SET SCOPE to set the range, now I'm looking to the best way simulate WHERE ORDER BY and LIMIT start, limit. Any suggestion is welcome. I had wrote a set of functions many years ago, which interprets the full "select ..." query and execu