Gossamer Forum
Home : Products : DBMan : Customization :

Can't search for delete and modify

Quote Reply
Can't search for delete and modify
Hi all,

Strange! I could perform searching smoothly but when i search for delete and modify, "no matching record" is resulted. Even if i chose list all at the top od delete and modify form, result is the same. Will somebody know why does it occur.

Kavis
Quote Reply
Re: Can't search for delete and modify In reply to
Sounds like you may have one of the following problems:

1) Database Tracking - need to have it set to 1 if you want to ensure that each record is distinct by a certain ID number or other field.

2) Your Fields are improperly numbered - make sure that you have the ID field or the first field in your database set to 0 and then each subsequent field set from 1 to whatever.

3) Corrupted Database File due to added fields or deleted fields - if you have added or deleted fields in your database without manually deleting your records (either off-line or in your web forms), then you will not be able to pull up records in the list all option because your database is corrupted. The fix to this problem is to manually add null values (|) to the new fields within your records or start over with a fresh database file.

These settings are found in your default.cfg file.

That is all I can think of for now. Hope this helps.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

[This message has been edited by Eliot (edited August 03, 1999).]

[This message has been edited by Eliot (edited August 03, 1999).]
Quote Reply
Re: Can't search for delete and modify In reply to
After modified the ID, it can search for delete and modify, list all is work too. BUT, strange, only one search item didn't work. When i choose "20MB - 30MB" for Storage, "no match records" showed up, both for delete and modify.

Do you think of any possible problem. Also, i'm going to check thru the "storage" code.
Quote Reply
Re: Can't search for delete and modify In reply to
I've found the problem!!

I incorrectly set the field_type to 'alpha', after i changed it to 'numer', it works.

Anyway, thanks for your help. ^.^
Quote Reply
Re: Can't search for delete and modify In reply to
Glad it worked.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us