[Webinar] Streamline your web hosting managementRegister Today


pervasive sql

Posted on 2006-03-20
Medium Priority
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
  • 3
  • 2
LVL 75

Accepted Solution

Aneesh Retnakaran earned 2000 total points
ID: 16234689
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

ID: 16234696
Hi Bachia,

have you tried refering to http://www.pervasive.com/support/technical/psqlv8_docs.asp for syntax?

What does your SQL look like?

LVL 23

Expert Comment

ID: 16234700
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

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

Expert Comment

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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ready to get certified? Check out some courses that help you prepare for third-party exams.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
Suggested Courses

591 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