Page 1 of 4
DBF TEMPORARY
Posted: Thu Jul 09, 2015 11:50 am
by 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!
Re: DBF TEMPORARY
Posted: Thu Jul 09, 2015 12:35 pm
by nageswaragunupudi
HB_DBCreateTemp( cAlias, aStruct, cRDD ) --> lSuccess
... use cAlias like any other alias
CLOSE cAlias at the end
Re: DBF TEMPORARY
Posted: Thu Jul 09, 2015 3:52 pm
by MarcoBoschi
Very interesting and Very useful
Many thank
Marco
Re: DBF TEMPORARY
Posted: Thu Jul 09, 2015 7:21 pm
by 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
Re: DBF TEMPORARY
Posted: Fri Jul 10, 2015 12:53 am
by nageswaragunupudi
James Bott wrote: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.
Re: DBF TEMPORARY
Posted: Fri Jul 10, 2015 2:17 am
by 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
Re: DBF TEMPORARY
Posted: Fri Jul 10, 2015 3:43 am
by nageswaragunupudi
James Bott wrote: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.
Re: DBF TEMPORARY
Posted: Fri Jul 10, 2015 7:17 am
by 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
Re: DBF TEMPORARY
Posted: Fri Jul 10, 2015 10:34 am
by nageswaragunupudi
MarcoBoschi wrote: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.
Re: DBF TEMPORARY
Posted: Fri Jul 10, 2015 11:34 am
by MarcoBoschi
Yes of course
Re: DBF TEMPORARY
Posted: Sun Jul 12, 2015 4:05 am
by zekasan
example:
Code: Select all
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)
Re: DBF TEMPORARY
Posted: Mon Jul 13, 2015 5:20 am
by 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
*/
Re: DBF TEMPORARY
Posted: Mon Jul 13, 2015 1:57 pm
by 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
Re: DBF TEMPORARY
Posted: Mon Jul 13, 2015 2:37 pm
by 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
Re: DBF TEMPORARY
Posted: Mon Jul 13, 2015 3:13 pm
by 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