In the Access Database Table there is a parameter for each field stating =
whether the field can have a none zero length and another one stating =
whether the field is required. It's under the General tab, second and =
third from the bottom for text fields I know.
James A. Tucker
Internet Administrator
Century Telephone - Southern Region=20
-----Original Message-----
From: Andras Tudos - Computronic, C3 [SMTP:andras.tudos@computronic.hu]
Sent: Wednesday, July 23, 1997 5:51 AM
To: ntisp@emerald.iea.com
Subject: IDC and emty fields
Anyone has an idea how could I setup IDC files to accept empty form =
fields?
I get this error when trying to update a form which contains empty =
fields:
[State=3DS1000][Error=3D-3702][Microsoft][ODBC Microsoft Access 7.0 =
Driver] Field=20
'xxx' can't be a zero-length string.=20
I try to use the following update.idc (generated by Frontpage 97):
Datasource: bvfelh
Template: sikerult.htx
SQLStatement: UPDATE DISTINCTROW Felhasznalok_Webre SET
+Felhasznalo_neve =3D '%Felhasznalo_neve%',
...
+Interface_kabel =3D '%Interface_kabel%' where ID=3D%ID%;
It works only if all the fields are filled with data.
-----------------------------------------------------
Andras Tudos
Computronic, C3 http://tech.c3.hu
Budapest, Hungary http://www.computronic.hu
-----------------------------------------------------
----------------------------------------------------------
NTISP Mailing List listserver@emerald.iea.com
------ =_NextPart_000_01BC9751.4C18CC50
Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64
eJ8+IggPAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEkAYAsAEAAAEAAAAQAAAAAwAAMAIAAAAL
AA8OAAAAAAIB/w8BAAAASQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAG50aXNwQGVtZXJhbGQu
aWVhLmNvbQBTTVRQAG50aXNwQGVtZXJhbGQuaWVhLmNvbQAAAAAeAAIwAQAAAAUAAABTTVRQAAAA
AB4AAzABAAAAFgAAAG50aXNwQGVtZXJhbGQuaWVhLmNvbQAAAAMAFQwBAAAAAwD+DwYAAAAeAAEw
AQAAABgAAAAnbnRpc3BAZW1lcmFsZC5pZWEuY29tJwACAQswAQAAABsAAABTTVRQOk5USVNQQEVN
RVJBTEQuSUVBLkNPTQAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAAFgAAAG50aXNwQGVtZXJhbGQu
aWVhLmNvbQAAAAIB918BAAAASQAAAAAAAACBKx+kvqMQGZ1uAN0BD1QCAAAAAG50aXNwQGVtZXJh
bGQuaWVhLmNvbQBTTVRQAG50aXNwQGVtZXJhbGQuaWVhLmNvbQAAAAADAP1fAQAAAAMA/18AAAAA
AgH2DwEAAAAEAAAAAAAAArlaAQSAAQAYAAAAUkU6IElEQyBhbmQgZW10eSBmaWVsZHMAigcBBYAD
AA4AAADNBwcAFwAKAA8ABwADABUBASCAAwAOAAAAzQcHABcACgAHADkAAwA/AQEJgAEAIQAAADc4
RDQ1OERGNkMwM0QxMTFBOEIyMDA2MDk3Nzk4MEI2AAQHAQOQBgBoDAAAIQAAAAsAAgABAAAACwAj
AAAAAAADACYAAAAAAAsAKQAAAAAAAwAuAAAAAAADADYAAAAAAEAAOQDQ8Tg0e5e8AR4AcAABAAAA
GAAAAFJFOiBJREMgYW5kIGVtdHkgZmllbGRzAAIBcQABAAAAFgAAAAG8l3s0Bd9Y1HoDbBHRqLIA
YJd5gLYAAB4AHgwBAAAABQAAAFNNVFAAAAAAHgAfDAEAAAAZAAAAanR1Y2tlckBjZW50dXJ5aW50
ZXIubmV0AAAAAAMABhALR3s1AwAHEKwEAAAeAAgQAQAAAGUAAABJTlRIRUFDQ0VTU0RBVEFCQVNF
VEFCTEVUSEVSRUlTQVBBUkFNRVRFUkZPUkVBQ0hGSUVMRFNUQVRJTkdXSEVUSEVSVEhFRklFTERD
QU5IQVZFQU5PTkVaRVJPTEVOR1RIQU5EAAAAAAIBCRABAAAASAkAAEQJAADXFQAATFpGdQbLmPMD
AAoAcmNwZzEyNXIyDGBjMQMwAQcLYG6RDhAwMzMPFmZlD5JPAfcCpANjAgBjaArAc4RldALRcHJx
MgAAkioKoW5vElAgMAHQhQHQNg+gMDUwNBQh8wHQFBA0fQdtAoMAUAPU+xH/EwtiE+EUUBOyGPQU
0IsHExXkNhGOMjM4F1SiIAdtIENFFeQ3Gn+nFEAbrxy1eXIV5DkRjq8aUBYxHv8DgkcJ0WsCg98M
ASD/DlAiLwNzVAhwI9S7FjEhDTgaYSWfA4JCB0D+dA3gI9QlYRZsG3gHEx0G/xtwKv8etyyVIFUO
MBZOIej/LJQjiRphME4lZiyUJucdkb8wTSiXLJQqJgKRCOY7CW/qMDi/ZQ4wNTnqOwE6v/87yTnU
O/I6Xz4vPe09bzuf8znvEGAyOEO6RNFEj0WZ/znURcJEL0f/R71HP0VvSTR+OQ5QTIRN4UYDTeAC
gnOodHlsB5BoCeB0AABDE1AD8GRjdGwKsVxhUDhhZGp1T1AFEGfuaAVCFjIMAWMJwFBAAzDwc25l
eBcwB7AFsADAxQJzcwBQc2IyFFBPQNJhE/BcawngcAuQUB+vUIMIYFBwC4BlT4B2V0D/AUBRewww
UkQbkFUgBKALgKZnRdFSxmJhFxBkAiCfU4BTJk+wUXBZcSAxTxP/DlBUf1WPVp8AUVfcAKBSTv9a
X1tmTwQPwFxvXX9ejw5Qb1fPYO9h/1uTMwKCExBjP1RAaYFRcFuQKlBXcCBESQEQYXUqQCBQCsBh
wQnAYXBoIEYCIVQE6TARaS0PkDgBQFcQbhPrZO9Qg2ILIHIJUHAyFqDZcDJ3NEMhFwBwAdBrUn9R
n2h/aYZtsGxwBRACMC0rbRADYTopEG91kFN1FGJqBZB0dZBEYXT8ZTpUBBphbf9vD3AfcS//cjdP
oFuDDiFpgViWDlBzT810XlJXYRcBIEhbcQSQ/1QEHZF3b3h/eY96m1bve5+XD5CHUAjQYgqwdDhn
2n8PVGPwfZ9+pofgf7ALUHneL20gepALEYAlc1QEG5H/gS+CP4NPep9yP4lPil+LZH91snVUdokg
0I2vUS+HhDmHkX+Sj5iARG9jdQeA/wIwBdBs4DfhlrKWEJZQjzH9AYBudhAAYAnwa4Ca4AIBu1PA
fDJlAPCa4E9gcDxgpFx2CJB3awuAZB7A/56CBPAHQBBhAUAOAI8CW2J7n+UCEG8FQhchEvJ2oG1H
C1F2oB0AOlxcdOBvvWzBbW0QAxAHkKKQTQ3gyQNgc28BgCBPASAN4LWd0FykRkUAwAMQLmlQvnSb
sBcQllBTAYVSeAFAvZzhbk+wONCl5GwUYwMg5xLzAIAFkGx2X4FksA5w/1PAqHIBkAAgqQKe0Zsh
AcF/qHEW4A9wAABksAzQAZAg/i438qhoDlCpIipAlqCpn/+qr6u/D8BksAWBrV+ub69/dmwewGSw
bK0fsd+y5Skfq+wwELC/tZ+y1GIgKP8Ckba/qLMaYLRvuS+6P7tP/6jgHZC8kqlvvf+/D6vsG5D/
vJ/CH8MvxD+o4CDQwR/Gr3/Hv8jECvkDMJYPlx+YrXvaSQOgdE+wLIBjpIAEEf92gQGgaSEpEAGg
T4DRojjQ+iAEACCzMAqxowAXIASQeiCdUSBbcBbQ1JAIkGzvUwDKkSpQW7F3T7DTUtGj/9U0n3AD
oBbga9GzMBNQU0DkIHoEkG8gT4APcNGw/9PQnPDY4aEg1lLX8tWf1qcj07E40HF1aTjRLiB4IEl0
ABDb4KEg2dEg9nXLMdZ0RwnwBJAswQGR/izZ4AWR2QNTANGw3ABTAP8DUtGjBuACQN/R1KJ2oFNg
o9UkBCBJIGvOYS4KhW0KhUrUMQQgQdxAJuBjP1kxCoXRgNRhU0AFQEFk/m0LgAQA0BB2kAWwCoXN
hGfOT89fBUB7Q5shCHB5/ykQhYFs8NfypsJpIG0ABgDPhSGnEQOgf7BnaQIg4ob/5c2FUMuC5r/n
zwjBUtJTgCES8mJrbWvKkyBfp5tgAxDSYn0t8YJP0CHbC4AswU3SIWywZfGD5cv/zeaA3Y0A7T+O
n4+vhR+GL/+HP4hP0STvhnVTDIIsgJzw/2ygBCAm4GlQBCB1MAhQogAX+NADYAMAY96AQzMgwFtT
TVRQOtjx/qE2LukQ/wFABaD/hy5o/HVd8y/0NIyb9W/2f/eP75Cf0KwMIe+VU5sh/hQ4Aq3vpFc4
4FNAc+owed6APkpsQOlAG3DegCDAOTeQIDU6NQ6QQU3sBp8J2ZSRCt3pABaAcECh8OfeAtwwnpBh
LgGRDc8KYeN2BQrdSURD2OOh8E9g/+E1Ao/OIuz/7g8Ij9Ez7A/vFq8Xv+iT/nB51/IwwNPB/84w
G4BbcFtQG2DXIOqg1WHz4bAw8XVwE/OMsE+B0aD32GDU8KSAcKEwofEUolOx/eE1P+Is4bDysKEw
31HTwP/kkCeg1MDacdGR6TBboiBx/x+g6jCiQbMwIXPacP/wbQC/3sHSgM4gI6EhJOFTOuIsIwBg
2gFlPVP64l1bwkUj0j0tMzeJAClQ46OnKVBPREIUIKOo0fW0Ny79sERngH/RXaMhU9VSGgUneC3w
J9ciJ+2hMGLXotgyLdiFGIJ8gP/cQCI+JHEk04AB1pM4QDhQ/zWwW7ElFBDgG5DIMPKw3fL7dqBT
AGLpQHVR6QAaMPKw+iANICknphp/G4/n/TU//zZPN1/ok9Jio/DpIKSAdZDkYnahYGxoOLXpYKIE
+XWQc2lZMWxBAkCzADi1OFNRTCijmxJ1kFVQEERBVEVr8ElTVIBJTkNUUk9XbRCLPSFpIHryIW9r
XwvAowZg0dBTRVQ4tStBqVZfU0Br0T0t0CVDjiXUJyw4tS7iFivkY2wg+aSAX2vSkPkgRINHHUXQ
F9pi04EUAD1IQEQlO3siPSvAd9Sw8HDZoQyRaf5m09AyQNaI08HTgSART4D/UwA6INjBJTEREOIs
OLXxg/9QH1EvUhw4tf56OLX/blW/x1XxGNA0kDovL3ag1QDtESAzAkE4tUL+8Jtwo2DqdN6ASN0w
Zzjw6UBWb/53WrARIgHJT29c313vUp6fOLVcP2F/Yo9SrSBOQRDcU1CbUaVwamJM5UFV/Pf48BiA
gAByf9EQbszA8AYn6hHw2Ti2fQBqYAMAEBAAAAAAAwAREAAAAAADAIAQ/////0AABzCg/1s0epe8
AUAACDCg/1s0epe8AQsAAIAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwACgAggBgAAAAAA
wAAAAAAAAEYAAAAAEIUAAAAAAAADAAWACCAGAAAAAADAAAAAAAAARgAAAABShQAAtw0AAB4AJYAI
IAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguMAADACaACCAGAAAAAADAAAAAAAAARgAA
AAABhQAAAAAAAAsAL4AIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAwgAggBgAAAAAAwAAA
AAAAAEYAAAAAEYUAAAAAAAADADKACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AQYAIIAYA
AAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAEKACCAGAAAAAADAAAAAAAAARgAAAAA3
hQAAAQAAAAEAAAAAAAAAHgBDgAggBgAAAAAAwAAAAAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAB4A
PQABAAAABQAAAFJFOiAAAAAAAwANNP03AAC1Yw==
------ =_NextPart_000_01BC9751.4C18CC50--