How do you set the "Allow Zero Length" option for an access field during
an sql create query?
an sql create query?
-
-
Re: Allow Zero Length field
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
If you mean CREATE TABLE (...), you can't in Access SQL (DDL). You have
to modify the TableDef property (this assumes you're using .mdb file
types).
--
MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQJF7OIechKq OuFEgEQKsiACgu4 tIA4W+fn2cOUpfr caR6gH5XAYAoMHK
m394dmewntLuu52 PAkSXq8/G
=4+wr
-----END PGP SIGNATURE-----
William Kossack wrote:
[color=blue]
> How do you set the "Allow Zero Length" option for an access field during
> an sql create query?
>[/color]
-
Re: Allow Zero Length field
any suggestions on how to accomplish it?
ps I'm doing this in cold fusion
MGFoster wrote:
[color=blue]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> If you mean CREATE TABLE (...), you can't in Access SQL (DDL). You have
> to modify the TableDef property (this assumes you're using .mdb file
> types).
>
> --
> MGFoster:::mgf0 0 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBQJF7OIechKq OuFEgEQKsiACgu4 tIA4W+fn2cOUpfr caR6gH5XAYAoMHK
> m394dmewntLuu52 PAkSXq8/G
> =4+wr
> -----END PGP SIGNATURE-----
>
> William Kossack wrote:
>[color=green]
> > How do you set the "Allow Zero Length" option for an access field during
> > an sql create query?
> >[/color][/color]
Comment
Comment