Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sintiax error in sql (2000 sr 1)

    i have set this string to call the filed of mdb.
    But the cript go in error... peraphs because the filed C/C have a "/"? If yes how to set corrrectly thath param without change the fileld in my MDB??
    Dim strSQL As String
    strSQL = "SELECT DATA_CONT, DIP, C/C, COD_BATCH, NOMINATIVO, CAUS, DARE, AVERE, VAL, SPORT_MIT, ANOM, DESCR, CRO, ABI, CAB, PAG_IMP, NR_ASS, MT, SERVIZIO, NOTE_BOU, SPESE, DATA_ATT, COD, NOTA_LIB " & "FROM TOTALE ORDER BY NR_ASS"

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: sintiax error in sql (2000 sr 1)

    Try putting [ ] brackets around the c/c.

    [c/c]
    Regards
    John



  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sintiax error in sql (2000 sr 1)

    many tks.

Posting Permissions

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