Allow zero length
-
How to tell MS Access to allow zero lenght in the strings field using the CREATE TABLE command. Thanks in advance.
-
How to tell MS Access to allow zero lenght in the strings field using the CREATE TABLE command. Thanks in advance.
it is not possible. i think u want to use Char Value type for that field. if there will be a lot of zero length data in field, use varchar type. It doesnt consume your performanse. If u use Char, as if u save zero length data to field, it will reserve a n length place. (n, your charecter count as CHAR(5))
-
How to tell MS Access to allow zero lenght in the strings field using the CREATE TABLE command. Thanks in advance.
As far as I know MS Access doesn't have any DML DDL statements like CREATE TABLE. The closest you'll get it reading the Msys... hidden tables. If you go into the design view of the table, you will see the various options per field. I think Access allows zero length by default. Remember that zero length and null are different. Cheers, Simon sig ::
"Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
article :: animation mechanics in SVG blog:: brokenkeyboards
"Most of us are programmers, but a few use VB", Christian Graus -
As far as I know MS Access doesn't have any DML DDL statements like CREATE TABLE. The closest you'll get it reading the Msys... hidden tables. If you go into the design view of the table, you will see the various options per field. I think Access allows zero length by default. Remember that zero length and null are different. Cheers, Simon sig ::
"Don't try to be like Jackie. There is only one Jackie.... Study computers instead.", Jackie Chan on career choices.
article :: animation mechanics in SVG blog:: brokenkeyboards
"Most of us are programmers, but a few use VB", Christian GrausThanks, but I do create my tables with CREATE TABLE (OleDbCommmand.ExecuteNonQuery) and the problem is that I afterwards have to go into access and alter the settings from there. Allowing null I have no problems with. /Robert