Re: [Harbour] Re: RDDSQL Question.

2010-03-05 Thread Bruno Luciani
> >> OK, but how do you reaslise datacommits to database ?? >> > > Using RDDINFO( RDDI_EXECUTE, "UPDATE ...") > > 3. Modifying database .. .. The programmer must call SQL command explicitly to modify SQL tables. SSI provides a method to detect which cached rows was changed or appended.

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Mindaugas Kavaliauskas
Hi, Jacek Kubica wrote: May be could you post a working sample using this mix way of work using a browse etc etc MK> Sorry, I do not use browse(). I use our own GUI. OK, but how do you reaslise datacommits to database ?? Using RDDINFO( RDDI_EXECUTE, "UPDATE ...") Using ODBC, native clien

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Mindaugas Kavaliauskas
Itamar Lins wrote: Yes, I understand. Another problem we consider a table with 3Gib for example how to work with it via browse? because my system is 100% via browse style excel. This is syntaxe below is impraticable. DBUSEAREA(, "select * from my_table") How to calculate end of query and ru

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Mindaugas Kavaliauskas
Bruno Luciani wrote: well , some code sample would be usefull This "sample" is 73 files with implementation of all GUI app development environment. It will not work together, if you delete one file. I can send some 20 lines sample, but it gives nothing to you. But I won't share the whole cod

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Viktor Szakáts
> I already did some month ago ( search for "New SQL classes #1" ) but > everything "stopped" around class vs RDD. It was in 2008 October ;) So maybe the topic could need some actualization. Most importantly we have (thanks to Mindaugas) RDDSQL since (committed in 2008 December), which gives us

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Lorenzo Fiorini
On Wed, Mar 3, 2010 at 7:00 PM, Viktor Szakáts wrote: > For sure it'd be powerful addition, so pls feel free > to open the topic, I'm sure many are interested. I already did some month ago ( search for "New SQL classes #1" ) but everything "stopped" around class vs RDD. Even the programming styl

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Viktor Szakáts
>> Another problem we consider a table with 3Gib for example how to work with >> it via browse? because my system is 100% via browse style excel. >> >> This is syntaxe below is impraticable. >> >> DBUSEAREA(, "select * from my_table") >> >> How to calculate end of query and run SQL again using

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Lorenzo Fiorini
On Wed, Mar 3, 2010 at 4:07 PM, Itamar Lins wrote: > Another problem we consider a table with 3Gib for example how to work with > it via browse? because my system is 100% via browse style excel. > > This is syntaxe below is impraticable. > >  DBUSEAREA(, "select * from my_table") > > How to calcu

[Harbour] Re: RDDSQL Question.

2010-03-03 Thread Jacek Kubica
Hello Mindaugas, Wednesday, March 03, 2010, 2:37:04 PM, you wrote: MK> Bruno Luciani wrote: >> May be could you post a working sample using this mix way of work >> using a browse etc etc MK> Sorry, I do not use browse(). I use our own GUI. OK, but how do you reaslise datacommits to database ?? U

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Bruno Luciani
well , some code sample would be usefull Bruno 2010/3/3 Mindaugas Kavaliauskas > Hi, > > > > Bruno Luciani wrote: > >> May be could you post a working sample using this mix way of work >> using a browse etc etc >> > > Sorry, I do not use browse(). I use our own GUI. > > > > Regards, > Mindaugas

[Harbour] Re: RDDSQL Question.

2010-03-03 Thread Itamar Lins
Em 3/3/2010 10:25, Mindaugas Kavaliauskas escreveu: Hi, But if I for example use: My Browse() function and modify a field? Because I change only in temporary cache query. How to proceed for commit? In my code on edit dialog "OK" button, o do both actions: execute query and set field values.

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Mindaugas Kavaliauskas
Hi, Bruno Luciani wrote: May be could you post a working sample using this mix way of work using a browse etc etc Sorry, I do not use browse(). I use our own GUI. Regards, Mindaugas ___ Harbour mailing list (attachment size limit: 40KB) Harbour@ha

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Bruno Luciani
May be could you post a working sample using this mix way of work using a browse etc etc It is very interesting Bruno 2010/3/3 Mindaugas Kavaliauskas > Hi, > > > > But if I for example use: >> My Browse() function and modify a field? >> Because I change only in temporary cache query. >> How

Re: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Mindaugas Kavaliauskas
Hi, But if I for example use: My Browse() function and modify a field? Because I change only in temporary cache query. How to proceed for commit? In my code on edit dialog "OK" button, o do both actions: execute query and set field values. There is also my primary idea to store "dirty" fla

Res: [Harbour] Re: RDDSQL Question.

2010-03-03 Thread Fernando Athayde
___ De: Itamar Lins Para: harbour@harbour-project.org Enviadas: Quarta-feira, 3 de Março de 2010 9:53:49 Assunto: [Harbour] Re: RDDSQL Question. Hi! Thanks for response. But if I for example use: My Browse() function and modify a field? Because I change only in temporary cache qu

[Harbour] Re: RDDSQL Question.

2010-03-03 Thread Angel Pais
Hi Itamar. If you read the changelog you will notice rddsql is a readonly rdd by design. It works like a recordset but with all the advantages of dbf style handling. HTH Angel ___ Harbour mailing list (attachment size limit: 40KB) Harbour@harbour-p

[Harbour] Re: RDDSQL Question.

2010-03-03 Thread Itamar Lins
Hi! Thanks for response. But if I for example use: My Browse() function and modify a field? Because I change only in temporary cache query. How to proceed for commit? Best regards, Itamar M. Lins Jr. Em 3/3/2010 09:38, Mindaugas Kavaliauskas escreveu: Hi, Itamar Lins wrote: Can you create ex