[Harbour] Test

2008-01-14 Thread Jerry Finuliar
please ignore Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs___ Harbour mailing list Harbour@harbour-project.org http://lists.harbour

Re: [Harbour] Experiences with sqlite?

2008-01-14 Thread WenSheng
> > I have to say that I don't like the idea to get the query result and put it > into a .dbf file (like sqlite3 for xharbour does); and given the ability of > sqlite to step through the query it could be possible to handle a big result > without creating a huge array (or a huge .dbf). > > My 2c

[Harbour] Harbour hbpgsql

2008-01-14 Thread elart
I made some test with hbpgsql on Linux i found with the harbour/contrib/hbpgsql/tests/test.prg to make test.prg working with postgresql 8.x i must change the row: res := PQexec('drop table products') to res := PQexec(conn, 'drop table products') res := PQexec('create table products ( product_n

RE: [Harbour] 2008-01-14 19:35 UTC+0100 Przemyslaw Czerpak (druzus/at/priv.onet.pl)

2008-01-14 Thread Jorge A. Giraldo
Hi Przemek, Solved, thank you a lot. Jorge A. > Date: Mon, 14 Jan 2008 19:35:55 +0100 > From: [EMAIL PROTECTED] > To: harbour@harbour-project.org > Subject: [Harbour] 2008-01-14 19:35 UTC+0100 Przemyslaw Czerpak > (druzus/at/priv.onet.pl) > > 2008-01-14 19:35 UTC+0100 Przemyslaw Czerpa

Re: [Harbour] 2008-01-14 19:35 UTC+0100 Przemyslaw Czerpak (druzus/at/priv.onet.pl)

2008-01-14 Thread Przemyslaw Czerpak
On Mon, 14 Jan 2008, Randy Portnoff wrote: > Hi Przemek, > > * harbour/source/rdd/dbcmd.c > >* changed hb_retnl() in LASTREC() to hb_retnint() to increase maximum > > record number to 2^32 - unsigned 32bit integer instead of signed one. > Do any of the other record-related functions need

Re: [Harbour] 2008-01-14 19:35 UTC+0100 Przemyslaw Czerpak (druzus/at/priv.onet.pl)

2008-01-14 Thread Randy Portnoff
Hi Przemek, * harbour/source/rdd/dbcmd.c * changed hb_retnl() in LASTREC() to hb_retnint() to increase maximum record number to 2^32 - unsigned 32bit integer instead of signed one. Do any of the other record-related functions need to be updated also? (eg. DBGOTO()/GO, RECNO(), DBR

[Harbour] 2008-01-14 19:35 UTC+0100 Przemyslaw Czerpak (druzus/at/priv.onet.pl)

2008-01-14 Thread Przemyslaw Czerpak
2008-01-14 19:35 UTC+0100 Przemyslaw Czerpak (druzus/at/priv.onet.pl) * harbour/common.mak * replaced TAB with SPACEs * harbour/source/rdd/dbcmd.c * changed hb_retnl() in LASTREC() to hb_retnint() to increase maximum record number to 2^32 - unsigned 32bit integer instead of signe

Re: RE: [Harbour] six driver

2008-01-14 Thread Przemyslaw Czerpak
On Mon, 14 Jan 2008, Jorge A. Giraldo wrote: > Hi Przemek, > I don't have SIX3, but I am reading the guides in > http://www.ousob.com/ng/six3/index.php > DBFdecrypt doesn't use a parameter as you said. > As I can see I should use SetPass instead. > But at least for me this code doesn't work, > the

[Harbour] Re: [xHarbour-developers] 32-bit RECNO limit HIT!

2008-01-14 Thread Maurilio Longo
Przemyslaw, I stand corrected! :) Thanks. Maurilio. Przemyslaw Czerpak ha scritto: > > On Mon, 14 Jan 2008, Maurilio Longo wrote: > > PS. But, if you have more than 2 billion records... how big is that .dbf? I > > think .dbf has a 2Gb size limit. > > 1. It's not DBF - Jacke wa talking about M

Re: [Harbour] Experiences with sqlite?

2008-01-14 Thread Petr Chornyj
Maurilio Longo wrote: > > But, :some_var could be a problem because it is the way in which you > reference > a method property inside a with object clause. > > So, maybe, we could end up with a different prefix which is then > translated in > the .c low level interface. > > I mean > > with o

Re: [Harbour] six driver

2008-01-14 Thread Przemyslaw Czerpak
On Mon, 14 Jan 2008, Chen Kedem wrote: > Przemyslaw Czerpak wrote: > > sx_DBFdecrypt() does not accept password as parameter but uses > > current table password > According to source/rdd/hbsix/sxtable.c, both SX_DBFENCRYPT() > and SX_DBFDECRYPT() get one paramter which is used as the password > lat

[Harbour] Re: [xHarbour-developers] 32-bit RECNO limit HIT!

2008-01-14 Thread Przemyslaw Czerpak
On Mon, 14 Jan 2008, Maurilio Longo wrote: > PS. But, if you have more than 2 billion records... how big is that .dbf? I > think .dbf has a 2Gb size limit. 1. It's not DBF - Jacke wa talking about MEDNTX RDD which uses SQL tables 2. DBF does not have 2GB size limits and never had. It was only M

[Harbour] Re: [xHarbour-developers] 32-bit RECNO limit HIT!

2008-01-14 Thread Przemyslaw Czerpak
[poniedziałek, 14 styczeń 2008], Jacek Potempa napisał(a): > Hi All, > One of our customers have just hit a limit of possible number of records > in a single table. This limit is a 32-bit "signed int" which gives us > 2,147,483,647 records per table. It's the maximum value HB_IT_LONG can > hold

Re: [Harbour] six driver

2008-01-14 Thread Szakáts Viktor
These are the function skeletons in original SX3 docs: Sx_DBFencrypt( [cKey] ) -> Logical Sx_DBFdecrypt() -> Logical Brgds, Viktor On 2008.01.14., at 15:45, Chen Kedem wrote: Przemyslaw Czerpak wrote: sx_DBFdecrypt() does not accept password as parameter but uses current table password Acco

RE: [Harbour] six driver

2008-01-14 Thread Jorge A. Giraldo
Hi Przemek, I don't have SIX3, but I am reading the guides in http://www.ousob.com/ng/six3/index.php DBFdecrypt doesn't use a parameter as you said. As I can see I should use SetPass instead. But at least for me this code doesn't work, the table remains encrypted, sorry if I miss something:

[Harbour] six driver

2008-01-14 Thread Chen Kedem
Przemyslaw Czerpak wrote: > sx_DBFdecrypt() does not accept password as parameter but uses > current table password According to source/rdd/hbsix/sxtable.c, both SX_DBFENCRYPT() and SX_DBFDECRYPT() get one paramter which is used as the password later in source/rdd/dbf1.c hb_TableCrypt() I don't h

Re: [Harbour] Experiences with sqlite?

2008-01-14 Thread Maurilio Longo
Petr, I do understand only right now that _you_ wrote minigui sqlite interface! :) I think that we could restrict what is accepted by this new bind_all() function. In particular we could say that it works only for the :some_var type of place-holder. But, :some_var could be a problem because it

Re: [Harbour] six driver

2008-01-14 Thread Przemyslaw Czerpak
On Sun, 13 Jan 2008, Jorge A. Giraldo wrote: > Hi All, > The following code will encrypt a file, but will not decrypt it > (Only de header as long as I can see). > When encrypted, the name becomes unreadable... Have you tested this code with Clipper and SIX3? It gives the same results. sx_DBFdecr

Re: [Harbour] Experiences with sqlite?

2008-01-14 Thread Petr Chornyj
Maurilio Longo wrote: > > > I think it would be better, if possible, to have a single call to which we > pass all the variables needed for a query and which does the binding, > something like > > text into csql >insert into t1( name, age) values( :name, :age ) > endtext > > (here the col

Re: [Harbour] Experiences with sqlite?

2008-01-14 Thread Lorenzo Fiorini
On Jan 14, 2008 11:06 AM, Maurilio Longo <[EMAIL PROTECTED]> wrote: > Then, having a good low level api we can add a higher level object class to > handle the result from the query. This can be a start. We can create ONE low level hbsqlite.c and call it from differents high level interfaces. > I

Re: [Harbour] Experiences with sqlite?

2008-01-14 Thread Rafa (TESIPRO)
Another implemtation; This is implementation the API Sqlite 3 for compilers [x]Harbour. Copyright 2007 WenSheng Copyright 2007 Rafa Carmona <[EMAIL PROTECTED]> License: Library General Public License (GNU) * Based in job of : Copyright 2003 Alejandro de Gárate <[EMAIL PROT

Re: [Harbour] Experiences with sqlite?

2008-01-14 Thread Petr Chornyj
Lorenzo Fiorini-2 wrote: > > > There is a wrapper for Harbour at > http://www.geocities.com/SiliconValley/Board/5300/sqlite/hbsqlite_en.htm > but it's not updated. > > Maybe you can see and other solution: SQLite3 for xHarbour(*mdy:2007.10.19) version 3.5.1 http://www4.zzz.com.tw/phpbb2/vi

Re: [Harbour] Experiences with sqlite?

2008-01-14 Thread Maurilio Longo
Hi, so we have at least three different .c bindings; at a first sight it seems to me that hwgui low level api bindings is the best one. but it has a few sqlite3_bind_xxx() functions to bind values to a prepared query which are 'ugly' to use. I think it would be better, if possible, to have a sin

Re: [Harbour] Experiences with sqlite?

2008-01-14 Thread Lorenzo Fiorini
On Jan 14, 2008 9:34 AM, Petr Chornyj <[EMAIL PROTECTED]> wrote: > Maybe you can see and other solution: Thanks for the info. best regards, Lorenzo ___ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/h

Re: [Harbour] HB_LONG_LONG_OFF in OS/2

2008-01-14 Thread Maurilio Longo
David, I've removed it in xharbour, just look at xharbour hbdefs.h best regards. Maurilio. David Arturo Macias Corona ha scritto: > > Przemek: > > This is a request/answer I made to Maurilio Longo recently: > > --- > > > On other subject: > > > xharbou