When I try to modify a record, I am getting an error that reads:

recip can not contain the value ''

There is nothing in the recip field??? What can be causing this and how do I fix it?

Regards,

Richard

Richard Bilger
RBilger@MERGINET.com
MERGINET.com: Emergency Responders Web Site
http://www.merginet.com

That basically means that the field cannot be null or empty. If you don't want to require the column/field, edit the table properties to set that column to NULL, and then re-sync your definition file.
========================================
Buh Bye!

Cheers,
Me

The recip properties for Not Null were set to No. I changed it to Yes then resync and got the error that the field could not be left blank. So I switched it back, did another resync and get the same message as before. Any more ideas?

Richard Bilger
RBilger@MERGINET.com
MERGINET.com: Emergency Responders Web Site
http://www.merginet.com

Is that with the Links SQL PHP front end or with the Perl CGI?

Adrian

Perl CGI

Richard Bilger
RBilger@MERGINET.com
MERGINET.com: Emergency Responders Web Site
http://www.merginet.com

Take a look at your table properties again. Make sure you do not have a field mask, or something else requiring an input from the template. One way to help debug, is see if you set a template field to that what happens. Sometimes its the template parser, not the database, that is checking for the valid input. (well, technically, not the template parser itself, but the pre-connect-to-database validation codes on the input data).

I've finally got a few sites up, and am getting them tweaked (took ages for the DNS to switch over!) I'll have some test sites up soon, so I can check these things out in real time :)


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.