can't update the last field

Results 1 to 3 of 3

Thread: can't update the last field

  1. #1
    Join Date
    Dec 1969
    Posts
    147

    Default can't update the last field

    hi:)<BR><BR>i had a update function in my database but the last field(AREATYPE) in the form can only accept integers and not alphabets. if alphabets is keyed in, there will be this error:<BR><BR>Database Errors Occured<BR>UPDATE CUSTOVE1 SET Record=&#039 555&#039, TITLE=&#039djhoi&#039, CHRISTIAN=&#039kl7979&#039, SURNAME=&#039ljljljkkjl&#039, NAME=&#039yiuihhu&#039, DESIGNATIN=&#039tyrty&#039, DESIGDEPT=&#039ytry&#039, FOCUSAREA=&#039gdsgsdg&#039, COMPANY=&#039dfgdsfgdfg&#039, ADDRESS1=&#039gdfgds&#039, ADDRESS2=&#039dfg&#039, ADDRESS3=&#039fgdg&#039, PD=&#039dfgd&#039, TELEPHONE=&#039dfgds&#039, FAX=&#039dfgdgf&#039, DEPT=&#039dfg&#039, STATUS=&#039ddfg&#039, CUSTTYPE=&#039&#039, MAILTYPE=&#039&#039, MAILDEPT=&#039&#039, MAILCODE=&#039&#039, XMASCARDS=&#039&#039, NEWSLINK=&#039&#039, ANNUALREPORT=&#039&#039, BROCHURES=&#039e&#039, AREATYPE=i WHERE AU_ID=520<BR><BR>Error #-2147217904<BR><BR>Error desc. -> [Microsoft][ODBC Microsoft Access 97 Driver] Too few parameters. Expected 1.<BR><BR>can anyone help me?<BR>i had already set the data type as text in microsoft access.<BR><BR>thanks<BR>

  2. #2
    Join Date
    Dec 1969
    Posts
    511

    Default RE: can't update the last field

    Check to make sure you have put &#039&#039 around it as the error message has them missing, with out then it will assume that it is a number or varible.<BR><BR>Pete

  3. #3
    Join Date
    Dec 1969
    Posts
    147

    Default RE: can'update the last field

    thanks that have solved my problem:)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •