>I ran up into a problem.
>In a rdoResultset, i'm trying to add a new record.
>Example code:
>
>with rstemp
> .rdcolumns(1).value = field(1).text
> .rdcolumns(2).value = field(2).text
>end with
>
>the field 2 in the db is a date type kind of one.
>when i do .batchupdate, so it writes the changes to the database, i get a error, saying error in SQL statement, while doing INSERT INTO.
>I tried formatting the date value all possible ways, but i still get the error.
>How can I format the date value in field(2).text, so it will pass the sql insert into statement?
>
>Thanx to anyone who can answer this!
Well as it looks i can thank myself.
I found out what was wrong, after i tried to do the same thing in SQL in access.
The table structure looks like this:
field name field type
code autonumber
name text(25)
date date
The date word is as it looks reserved in SQL, that's why RDO and SQL didn't wonna work.
In case anyone runs into same problem, which ate 2 hours of my work, i hope this can help you!