UPDATION OF DATE DATE FIELD IN PERVASIVE SQL THROUGH VB6 1

[ZABARVAN]

HI,

We are using ACCPAC with Pervasive SQL 2000 in NOVEL Environment.
I am trying to update/modify date field of assest table in AM module through VB. But it seems Pervasive SQL might be using some different syntex to record date fields. I tried various combinations but did't work. Can anybody provide some help to write code in VB for date updation.
Shall be gateful for your help.

Thanking you

ZAB

 

[zemp]

I have found that in order to use a date within an SQL statement with Pervasive (2000i was the database I used) I had to format the date as below,

Format(myDateVar, "YYYY-MM-DD&quot

Take Care,

zemp

"If the grass looks greener... it's probably because there is more manure."

 

[CustomMedia]

You are asking for trouble if you update fields in the tables directly. It is very easy to create a corrupt database. Is this worth what you are trying to do?