Gossamer Forum
Home : Products : DBMan : Customization :

Does DBMAN require a Key Field? Ramifications?

Quote Reply
Does DBMAN require a Key Field? Ramifications?
On One of the Sites I maintain, Using A form handler which can write all the fields to a DAtabase file. I created a DBMAN front end which is currently working.

Unfortunately, I have nothing set-up as a DB KEY field. I can't use any of the current fields as a key since, I'm prety sure there would be duplicates. Can't use a counter key either since the form that writes it to a file does not generate auto increment counters.

Can I leave is as it is? Would it cause any problems or degradation of performance? THe DB is pretty small, Just about 12 fields and big size memo/message field. Currently only has 100 records but I don't think it'll grow over 1000. If it does, we can archive it anyway.

Thanks.
Quote Reply
Re: Does DBMAN require a Key Field? Ramifications? In reply to
The database *must* have a key field. There is no way to do a whole lot of the functions unless there is a unique key for every record.

You could probably come up with a counter script that would add a field at the same time as the data is written to the .db file.


------------------
JPD