|
 |
access_asp thread: Allow Zero Length
Message #1 by jchristiana@k... on Mon, 23 Sep 2002 15:33:55
|
|
Hello. I am creating dynamic tables in access. Is there a book or other
resourses were I can find out how to toggle the Allow Zero Length to "YES"
Here is my code.
strTableName = "[" & dDate & "]"
Dim RS
SQLstmt = "CREATE TABLE " & strTableName & "("
SQLstmt = SQLstmt & "[ID] INT PRIMARY KEY ,"
SQLstmt = SQLstmt & "[DEPARTMENT] varchar(100) ,"
SQLstmt = SQLstmt & "[NAME] varchar(100) ,"
SQLstmt = SQLstmt & "[HOME] varchar(100) ,"
SQLstmt = SQLstmt & "[OFFICE] varchar(100) ,"
SQLstmt = SQLstmt & "[TYPE] varchar(100) ,"
SQLstmt = SQLstmt & "[NUMBER] varchar(100) ,"
SQLstmt = SQLstmt & "[CHANGED] varchar(100) ,"
SQLstmt = SQLstmt & "[WHO] varchar(100) ,"
SQLstmt = SQLstmt & "[OTHER] varchar(250) ,"
SQLstmt = SQLstmt & "[SELECT] varchar(100))"
Any help would be great.
Thanks.
Message #2 by "Daniel Groh" <daniel.groh@s...> on Mon, 23 Sep 2002 11:37:49 -0300
|
|
In the end of code enought to type "NOT NULL"
for example:
[CLI_FOR] [numeric](18, 0) NOT NULL
got it?
if it is false, contact me, it was I understood!!!
Daniel Andrade Groh
ICS - ASP / SQL
Fone: (11) 9527-7654
www.dgroh.hpg.com.br
----- Original Message -----
From: <jchristiana@k...>
To: Access ASP <access_asp@p...>
Sent: Monday, September 23, 2002 3:33 PM
Subject: [access_asp] Allow Zero Length
> Hello. I am creating dynamic tables in access. Is there a book or other
> resourses were I can find out how to toggle the Allow Zero Length to "YES"
>
>
> Here is my code.
>
> strTableName = "[" & dDate & "]"
> Dim RS
>
> SQLstmt = "CREATE TABLE " & strTableName & "("
> SQLstmt = SQLstmt & "[ID] INT PRIMARY KEY ,"
> SQLstmt = SQLstmt & "[DEPARTMENT] varchar(100) ,"
> SQLstmt = SQLstmt & "[NAME] varchar(100) ,"
> SQLstmt = SQLstmt & "[HOME] varchar(100) ,"
> SQLstmt = SQLstmt & "[OFFICE] varchar(100) ,"
> SQLstmt = SQLstmt & "[TYPE] varchar(100) ,"
> SQLstmt = SQLstmt & "[NUMBER] varchar(100) ,"
> SQLstmt = SQLstmt & "[CHANGED] varchar(100) ,"
> SQLstmt = SQLstmt & "[WHO] varchar(100) ,"
> SQLstmt = SQLstmt & "[OTHER] varchar(250) ,"
> SQLstmt = SQLstmt & "[SELECT] varchar(100))"
>
> Any help would be great.
>
> Thanks.
>
>
Message #3 by jchristiana@k... on Tue, 24 Sep 2002 14:32:09
|
|
I have used NOT NULL. It only changes the Required from yes to no.
My field is set to "No" already for being required.
The allow zero length field still stays at "No"
> In the end of code enought to type "NOT NULL"
for example:
[CLI_FOR] [numeric](18, 0) NOT NULL
got it?
if it is false, contact me, it was I understood!!!
Daniel Andrade Groh
ICS - ASP / SQL
Fone: (11) 9527-7654
www.dgroh.hpg.com.br
----- Original Message -----
From: <jchristiana@k...>
To: Access ASP <access_asp@p...>
Sent: Monday, September 23, 2002 3:33 PM
Subject: [access_asp] Allow Zero Length
> Hello. I am creating dynamic tables in access. Is there a book or other
> resourses were I can find out how to toggle the Allow Zero Length
to "YES"
>
>
> Here is my code.
>
> strTableName = "[" & dDate & "]"
> Dim RS
>
> SQLstmt = "CREATE TABLE " & strTableName & "("
> SQLstmt = SQLstmt & "[ID] INT PRIMARY KEY ,"
> SQLstmt = SQLstmt & "[DEPARTMENT] varchar(100) ,"
> SQLstmt = SQLstmt & "[NAME] varchar(100) ,"
> SQLstmt = SQLstmt & "[HOME] varchar(100) ,"
> SQLstmt = SQLstmt & "[OFFICE] varchar(100) ,"
> SQLstmt = SQLstmt & "[TYPE] varchar(100) ,"
> SQLstmt = SQLstmt & "[NUMBER] varchar(100) ,"
> SQLstmt = SQLstmt & "[CHANGED] varchar(100) ,"
> SQLstmt = SQLstmt & "[WHO] varchar(100) ,"
> SQLstmt = SQLstmt & "[OTHER] varchar(250) ,"
> SQLstmt = SQLstmt & "[SELECT] varchar(100))"
>
> Any help would be great.
>
> Thanks.
>
>
|
|
|
View Cart
