Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 7 of 7 total |
3.30 and set Required of Field to False (can Null) |
Mon, Jan 18 2010 8:36 AM | Permanent Link |
durumdara | Hi!
I want to remove NOT NULL flag from a field - from SQL. But this is not working: alter table t redefine f null; The setting was this: alter table t redefine f not null; Thanks for your help: dd |
Mon, Jan 18 2010 11:10 AM | Permanent Link |
"Raul" | Don't have 3.x manuals handy but in 4.x I think the keyword is nullable so
try with that. Raul "durumdara" <durumdara@gmail.com> wrote in message news:5871827D-324D-40CE-BB6B-11A93E4DF06E@news.elevatesoft.com... > Hi! > > I want to remove NOT NULL flag from a field - from SQL. > But this is not working: > > alter table t redefine f null; > > The setting was this: > > alter table t redefine f not null; > > Thanks for your help: > dd > > > __________ Information from ESET NOD32 Antivirus, version of virus > signature database 4783 (20100118) __________ > > The message was checked by ESET NOD32 Antivirus. > > http://www.eset.com > > > __________ Information from ESET NOD32 Antivirus, version of virus signature database 4783 (20100118) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
Mon, Jan 18 2010 4:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | << I want to remove NOT NULL flag from a field - from SQL. >> You can't do so with DBISAM 3.30. You can do so with DBISAM 4.x, however, using the NULLABLE keyword. You'll have to use the code-based TDBISAMTable.RestructureTable method to do so. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Jan 18 2010 5:43 PM | Permanent Link |
"Robert" | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:1F014450-C786-41BB-8D2D-6B0059508071@news.elevatesoft.com... > > << I want to remove NOT NULL flag from a field - from SQL. >> > > You can't do so with DBISAM 3.30. You can do so with DBISAM 4.x, however, > using the NULLABLE keyword. > > You'll have to use the code-based TDBISAMTable.RestructureTable method to > do so. > or rename, add the field correctly, transfer the data, delete the old field. I know, I know, but it works. Robert |
Tue, Jan 19 2010 7:53 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Robert,
<< or rename, add the field correctly, transfer the data, delete the old field. I know, I know, but it works. >> Yes, that will also work. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Jan 20 2010 4:30 AM | Permanent Link |
durumdara | "Tim Young [Elevate Software]" wrote:
<< I want to remove NOT NULL flag from a field - from SQL. >> You'll have to use the code-based TDBISAMTable.RestructureTable method to do so. Can you show me a very-very little example? I can reset this field (named "A") property ("NULLABLE") on table "T". Thanks for it: dd |
Wed, Jan 20 2010 10:26 AM | Permanent Link |
"Raul" | Required property determines if field value has to exists - meaning can it be null or not. This was never done IDE, lacks any checking of T or A and assumes defaults in RestructureTable but could roughly be something like this : .... T.RestructureFieldDefs.Update; T.RestructureFieldDefs[T.RestructureFieldDefs.IndexOf('A')].Required := false; T.RestructureTable; .... Raul > Can you show me a very-very little example? > I can reset this field (named "A") property ("NULLABLE") on table "T". > > Thanks for it: > dd __________ Information from ESET NOD32 Antivirus, version of virus signature database 4790 (20100120) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |