Re: [libreoffice-users] Re: Base Field Defaut Disables Save

On Tue, May 3, 2011 at 3:05 AM, Alexander Thurgood
<alex.thurgood@gmail.com>wrote:

> Le 03/05/11 00:24, John Shabanowitz a écrit :
>
> Try the solution suggested in this thread :
>
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=26194
>
> i.e. Go to the Tools - SQL menu entry
>
> Enter an ALTER table command to set the default value for each field as
> you desire.
>
> e.g. alter table T2 alter column C2 set default 0;
>
>
> HTH,
>
> Alex
>
> Good Info.
 I thought it was a bug because of inconsistent behavior. When you connect
to a MySQL database using Base and Oracle's MySQL connector, you can ALTER,
CREATE, and DROP tables from the GUI in Base. I need to use a reference when
writing SQL so sometimes the GUI is the easiest way to get up to speed,
especially with complex queries.

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted