FiveTech Software tech support forums

... file to the main index file.

C. Adding a New File

I create a temporary index file with entries from the new file.

This temporary index file is appended to the main index file.

Why This Approach?

Simplicity: The approach is easy to understand and implement.

Consistency: By deleting and ...

... FILETIME( cDbf )

inkey(0)

RETURN


Does not work for me. Can I see your output? Anyway, you mixed the R lock flavor and the normal lock flavor. With DBRLOCK() you must use DBRUNLOCK(). And furthermore, APPEND BLANK operation locks the newly appended record so there is no need of another lock.

Jimmy

I create my own primary keys that way I control when a table is appended .. if you use auto increment an attacker could force an table append or "Inject" records into your tables and the database doesn't care .. the primary keys are generated automatically .. for me I create ALL my primary ...

Jimmy

I create my own primary keys that way I control when a table is appended .. if you use auto increment an attacker could force an table append or "Inject" records into your tables and the database doesn't care .. the primary keys are generated automatically .. for me I create ALL my primary keys ...

... the existing or blank FW_Record objec, simple call
oRec:Save() 
In case of existing records, the changes will be written to that record and in case of blank record, a new record will be appended to the rowset.

You can also use oRec:Edit()
or oQry:Edit()
or oQry:Edit( .t. )

Please try.

... editable, to show the array. The user sees it and can fill in the values. When you save it, upon completion, the array elements are recorded in appended daily records for each student.

Views and reports can then be created to see the data, and you can even build a routine to edit it when desirable ...

... editable, to show the array. The user sees it and can fill in the values. When you save it, upon completion, the array elements are recorded in appended daily records for each student.

Views and reports can then be created to see the data, and you can even build a routine to edit it when desirable ...

... paramter.
After execution record pointer is restored.

- New method FieldDefault( ncFld, uDefaultValue ): The default value
will be used in all appended records.

- Now this class can be used to read a batch of records from a DBF or MYSQL
table. These records can be edited in memory, appended and ...

... aStruct can be empty or Structure or list of fields.
The function returns an ADO recordset, not connected to any database, but
can be edited, appended, deleted and navigated like any other recordset.
At any time, array of data can be retrieved with aData := RsGetRows( oRs )
Source: \fwh\source ...

... will use the same process on their computers ( with different data ). When user A goes to add a customer, the number is assigned to the new/blank appended record and the counter advanced. The next person ( could be a fraction of a second later ), gets the next number. With this being done thousands ...

... system.

"ROWID" : Field Type "+"
Autoincrement numeric field. DBFCDX automatically increments the value in this field every time a new record is appended. Uniqueness and chronological continuity are assured even in multi-user environments. This field is read-only and we can not write this field or ...

Just a thought, but why not use the browse with it's search enabled. Start typing the data, and if you see no match, program a right click on the mouse to pop up an Edit screen, with a new record appended, where you can type in the data.

... next serial number in chronological order when the new record is saved in a multi-user environment. This can be known only when the new record is appended.

I remember very well that you refused all advices in this regard. Even at the risk of you blaming me also, I would reuest you once again re ...

... the buffers with blanks, then goes to the counter dbf, increments the proper number, saves the value back to the record, and saves it to the appended record. The interaction with the counters file takes a fraction of a second and that is never an issue in multi-user environments.


Even the ...

... the buffers with blanks, then goes to the counter dbf, increments the proper number, saves the value back to the record, and saves it to the appended record. The interaction with the counters file takes a fraction of a second and that is never an issue in multi-user environments.

It is ...