Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2009
    Posts
    15

    Unanswered: Pass a Date to a Timestamp Field Using SQL

    I am using MS FoxPro to insert data into db2 file the data I am sending is a date which I cast as a datetime value example 07/06/2010 12:00:00 AM.

    I get an sql error that token 12 in invalid.

    here is my sql syntax

    Code:
    insertSImain = "Insert Into webprddt7.qasimast(recseq, insptype, docno, partno," +;
    			" shipsetid, dwgrev, vendorcode, faiindex, lotqty, sampletype, sampleqty, accptdqty," +;
    			" rejdqty, inspdate, inspector, inspsource, rejtindex)" +;
    			" Values(" + ALLTRIM(STR(x)) +;
    			",1,'" + ALLTRIM(testconnQuery.docno) +;
    			"','" + ALLTRIM(testconnQuery.partno) +;
    			"','" + ALLTRIM(testconnQuery.jobno) +;
    			"','" + ALLTRIM(testconnQuery.revision) +;
    			"','" + ALLTRIM(testconnQuery.vendorcode) +;
    			"'," + ALLTRIM(STR(testconnQuery.faiindex)) +;
    			"," + ALLTRIM(STR(testconnQuery.lotsize)) +;
    			"," + ALLTRIM(STR(testconnQuery.sampletype)) +;
    			"," + ALLTRIM(STR(testconnQuery.cmss)) +;
    			"," + ALLTRIM(STR(testconnQuery.cmaa)) +;
    			"," + ALLTRIM(STR(testconnQuery.cmar)) +;
    			"," + TTOC(testconnQuery.inspectdt) +;
    			",'" + ALLTRIM(testconnQuery.inspectsna) +;
    			"',1," + ALLTRIM(STR(y)) + ")"
    			
    			? insertSImain
    			
    			If SQLEXEC(testconn, insertSImain) <> -1 Then
    				=SQLCOMMIT(testconn)
    			ELSE
    				If Aerror(odbcerrormsg) > 0 Then
    					MessageBox(odbcerrormsg(2))
    				EndIf
    			EndIF

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    So, what's the output of "? insertSImain"?

Posting Permissions

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