DBF TEMPORARY

[MarcoBoschi]

Dear Friends,
is just a thought and I would like to read your opinions.
Does exist the possibility to create a DBF only in memory (for instance with TEMPORARY clause) for special
purposes such as counting , statistics etc. etc.
It might be useful!
What do you think about that?
Does already exist?



Have a nice day!

[nageswaragunupudi]

HB_DBCreateTemp( cAlias, aStruct, cRDD ) --> lSuccess
... use cAlias like any other alias
CLOSE cAlias at the end

[MarcoBoschi]

Very interesting and Very useful
Many thank

Marco

[James Bott]

Another way to do this is with an array and an array class that emulates the database class.

I started on this years ago and I don't remember if I ever finished it.

James

[nageswaragunupudi]

Another way to do this is with an array and an array class that emulates the database class.

I started on this years ago and I don't remember if I ever finished it.

James

I made TArray long back for personal use. One of my friend programmer liked it and he uses extensively than me.
After I learnt about this dbftemp, I am advising him also to use this dbftemp instead of my TArray class. Dbf has more facilties like setting relations and a lot more.

[James Bott]

Rao,

I made TArray long back for personal use. One of my friend programmer liked it and he uses extensively than me.
After I learnt about this dbftemp, I am advising him also to use this dbftemp instead of my TArray class. Dbf has more facilties like setting relations and a lot more

.

I am going to give it a try. I wrote my TArray specifically so I could use the Report class with an array. It works well for that. I expect the dbftemp would work just as well I expect.

James

[nageswaragunupudi]

Rao,

I made TArray long back for personal use. One of my friend programmer liked it and he uses extensively than me.
After I learnt about this dbftemp, I am advising him also to use this dbftemp instead of my TArray class. Dbf has more facilties like setting relations and a lot more

.

I am going to give it a try. I wrote my TArray specifically so I could use the Report class with an array. It works well for that. I expect the dbftemp would work just as well I expect.

James

Having tried both, I advise you to try dbftemp.

[MarcoBoschi]

I'll test it very soon and then I'll know you if
it's faster than my current system based on an array that run on server

Many thanks

[nageswaragunupudi]

I'll test it very soon and then I'll know you if
it's faster than my current system based on an array that run on server

Many thanks

Nobody said it was faster than array.

[MarcoBoschi]

Yes of course

[zekasan]

example:

Code: Select all  Expand view

ARQ1:="mem:"+alltrim(NomeUsuario)+"1"

    aStruct_ARQ1:={{  "QTPD", "N", 05, 0 },;
                        {  "QTST", "N", 05, 0 },;
                        {  "QTCL", "N", 05, 0 },;
                        {  "QTD1", "N", 05, 0 },;
                        {  "VLR1", "N", 12, 2 },;
                        {  "QTD2", "N", 05, 0 },;
                        {  "VLR2", "N", 12, 2 },;
                        {  "QTD3", "N", 05, 0 },;
                        {  "VLR3", "N", 12, 2 },;
                        {  "QTD4", "N", 05, 0 },;
                        {  "VLR4", "N", 12, 2 },;
                        {  "VEND", "C", 14, 0 },;
                        {  "NOMV", "C", 40, 0 },;
                        {  "FILX", "C", 02, 0 },;
                        {  "FILI", "C", 02, 0 },;
                        {  "CTRL", "N", 04, 0 },;
                        {  "IMPR", "L", 01, 0 }}

    dbCreate( Arq1, aStruct_ARQ1, "DBFCDX")
   use &ARQ1 alias AREA1 new exclusiv
    inde on FILX+NOMV+VEND to &ARQ1

.
.
.
.
    AREA1->(dbclosearea())
    DBDROP(arq1)


 

[Carles]

Marco,

You can use arrayrdd, a rdd that works great for arrays and maybe it can use for your purposes

/*
* This is a Array RDD, or Memory RDD.
* It works only in memory and actually supports standard dbf commands
* excepts relations
*/

[James Bott]

Carles,

Tell us more about ArrayRDD?

Who wrote it?

Where can we get it?

Is there a fee for it?

Can we see an example of it's use?

It sounds interesting.

Regards,
James

[Enrico Maria Giordano]

James,

/*
* Harbour Project source code:
* ARRAY RDD
*
* Copyright 2006 Francesco Saverio Giudice <info / at / fsgiudice / dot / com>
* Copyright 2011-2013 Quique <quique@quiquesoft.com> (Index, locate and filter Support)

EMG

[Carles]

James,

You can see it in folder .\core-master\src\rdd\usrrdd\rdds\arrayrdd.prg and you can use it the same way other rdd