FiveTech Software tech support forums

... an old FiveWin-Clipper app. I used (until today in smal systems) to load the DBF into an Array and after the dialog, load it back to DBF (scatter & gather functions). Would be a lot of work rewrite it to use TDatabase In the newest systems, I am using TDatabase extesively. Regards, ...

... oCustomer:Address Which is pretty clear. Much more clear than something like cCUADR. Also, when using the above syntax, you eliminate all the scatter/gather code and just assign data directly to the database object. Note that the data is being assigned to a buffer so you can cancel the transaction ...

... but no error will occur. You can also pass a record number so that you can take 1 record and update another record in the same database. aData := scatter() // Select other database // Append blank or lock record gather( aData ) function scatter( nRecNo )   local nFldCount := ...

Hello Michel.
To 'copy' and ´paste' database records I use the array-field functions SCATTER & GATHER with option for field checking.
I you want, I can post them here.
HTH & regards, Euclides

... care of all. It may look simple, but you can find any postings seeking advice on these issues. Edit: All of us are used to implement some kind of scatter/gather systems to edit the field values in dialogs. Obviously these methods differ for different datasources. Now we have TDataRow class which ...

... of TDatabase class for ADO. TDataRow is completely generic for any datasource, be it DBF, Ado, etc. It is basically a class to handle Gather/Scatter mechanism to edit existing or new records and can be used transparently without regard to the underlying datasource. Lucas, actually while using ...

I suppose you are using FWH13.05 For scatter/gather FWH provides two alternatives. 1. You can use Tdatabase class. 2. If you continue using DBF directly, you can use TDataRow class. TDatabase class: For the problem you pointed out in this post ...

Then I should wait until your next release. It is impossible for me to do it that way since I have my own Scatter and Gather beside (and above) those provided by Odbf and it will be a nightmare to reload data and gather in my 230 variables anew (has to do with Dbase field limitations ...

Class TDataRow -------------- Class TDataRow simplifies the scatter/gather process of the field values of a single record of a table for purposes of editing/appending. This class can read all or specified field values from a single row of DBF table,ADO ...

Hi Rick

I have got my first little bit working - adding , deleting and updating records - I am trying to write
generic gather and scatter routines now. Any tips welcome. :- )

Cheers

Colin

Hi all; I use hashes a lot. Never had a problem. The sample Maurizzio shows is a good one. In essence, with his scatter you can refer to an array entry using syntax like : ?aVar[ LASTNAME ] to show what's in the buffer for oCust:LASTNAME. Clearly using the aforementioned syntax ...

MAurizio, I don't see where you are using a hash? Did you know that the equivalent of scatter and gather is built into database objects. And instead of refering to aVars[1], you can refer to oCust:name. This makes the code much easier to write and read. There are lots ...

Hello Otto I use Hash for manage the database Function Scatter() Local aVars := {=>} LOcal nField := FCount() LOcal nX := 1 FOR nX := 1 TO nField aVars[FIELDNAME(nX)] := FieldGet(nX) NEXT Return aVars Function Gather(aVars) lOCAL Nx := 1 FOR Nx := ...

... and to save the data from the variables into the record. cName:= field->name redefine get var cName A better and generic way is to use Scatter() and Gather() functions. Scatter puts data from all the fields of a record into an array and Gather puts all the data from the array into the ...

... "syntax error at '['" Error E0030 Syntax error: "syntax error at '['" Under Clipper 5.2e they compile with no problems. // Scatter / Gather #include "Dbstruct.ch" #translate Gather(<a>) => AEVAL(<a>, {|x, i| FIELDPUT(i, <a>\[i\]) }) FUNCTION ...