pervasive sql

Posted on 2006-03-20
Last Modified: 2012-06-21
Hi, thanks in advance

I have my application i created for a client. Now my client needs the invoices created in my app to be inserted into there accounting package called Pastel 2004.  
Im getting this error when I attemp to run my insert sql "

Run-Time error '12147217900(80040e14);
[Pervasive][Odbc Client Interface][LNA][Pervaiive][ODBC Engine Interface]Invalid date, time or timestamp value.

I get this when I attempt to bring in a date from a record soruce.  if I leave the data filed out the sql runs fine.  

please answer Me
Question by:Bachia
    LVL 75

    Accepted Solution

    You have already posted the Question here.. If the solutions given for that won't work, please post you comments..

    I think you need to format your date  in "YYYY-MM-DD" format
    LVL 23

    Expert Comment

    Hi Bachia,

    have you tried refering to for syntax?

    What does your SQL look like?

    LVL 23

    Expert Comment

    Bachia you have already posted a question, you might want to request one of these questions get deleted, and i also suggest you check your email!
    LVL 23

    Expert Comment

    sorry aneeshattingal, i didnt realise you had posted also :o)
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    now you need to delete the other question

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Join & Write a Comment

    Suggested Solutions

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how the fundamental information of how to create a table.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now