Default Value error

[Keith Clark-2]

I am using Base to connect to a remote MySQL server and everything was
working fine, until today.

On two different machines, with two different ISPs, and even two
different O/Ss, one of my forms no longer works because the default
values are not working on the fields.  I don't understand how this could
happen.  The database seems to be operating just fine on the website
that uses it.

Not sure how this could be.

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Alex Thurgood]

Hi Keith,

>
> On two different machines, with two different ISPs, and even two
> different O/Ss, one of my forms no longer works because the default
> values are not working on the fields.  I don't understand how this
> could
> happen.  The database seems to be operating just fine on the website
> that uses it.
>

My own experience with default fields on a mysql server using Base forms as a front end has been somewhat checkered because the behaviour of the forms have in the past been "erratic", in a similar way to using setting Boolean values, although things shouldn't have changed overnight unless you have either upgraded one or other of your main components, i.e. either OOo or the mysql server. Ultimately, I have resigned myself to hard coding default fields in the table create statement under mysql and not relying on Base to do the work for me.

Maybe you could fill us in a bit more on your setup ?

Alex

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Andreas Saeger]

Keith Clark wrote:

> I am using Base to connect to a remote MySQL server and everything was
> working fine, until today.
>
> On two different machines, with two different ISPs, and even two
> different O/Ss, one of my forms no longer works because the default
> values are not working on the fields.  I don't understand how this could
> happen.  The database seems to be operating just fine on the website
> that uses it.
>
> Not sure how this could be.
>
> Keith

There should be an option in
DB-menu:Edit>Database>AdvancedProperties:"Form checks for valid input"
(or similar)
Turn this off and the Base will send incomplete records to the database
which can substitute missing values by default values.


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Keith Clark-2]

On Sat, 2009-06-20 at 12:05 +0200, Andreas Saeger wrote:

> Keith Clark wrote:
> > I am using Base to connect to a remote MySQL server and everything was
> > working fine, until today.
> >
> > On two different machines, with two different ISPs, and even two
> > different O/Ss, one of my forms no longer works because the default
> > values are not working on the fields.  I don't understand how this could
> > happen.  The database seems to be operating just fine on the website
> > that uses it.
> >
> > Not sure how this could be.
> >
> > Keith
>
> There should be an option in
> DB-menu:Edit>Database>AdvancedProperties:"Form checks for valid input"
> (or similar)
> Turn this off and the Base will send incomplete records to the database
> which can substitute missing values by default values.
>

Andreas,

Thanks, that worked.  Strange that I have to suddenly change both
installations though to make them work again.

I consulted with my webhost and they told me that all they did was:

"We increased the cache size of MySQL and restarted the service
yesterday."

I don't see how this could drastically effect my Base installations.

Anyways, I'm back up and running for now.

Thanks again,

Keith



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...