[Oledb-dev] Update support

[Konstantin Izmailov]

Victor,
make sure your MDAC version is 2.71 or later (e.g. download it from
http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displayLang=en
).

If it will not help let me know. I will try to reproduce and look at the
code.

Konstantin


On 4/22/06, Victor Snezhko <snezhko at indorsoft.ru> wrote:
>
> "Konstantin Izmailov" <kizmailov at gmail.com> writes:
>
> > I do not remember any particular article or doc that described
> > this. I used ADO source code when worked on similar project long
> > time ago. Unfortunately, the source is MS proprietary and not
> > available.
>
> Konstantin, one more question.
> I experience weird behaviour of ADO in rare circumstances, and don't
> know what to do with it. If a recordset contains boolean column, it
> can affect other columns updating (recent bug report shows this also
> happens with fetching, I can't reproduce it though).
>
> RS("varcharcol")="value"
> RS("booleancol")=true
> RS.Update
>
> When I execute such script, ADO fills the parameters incorrectly: it
> passes NULL instead of string value.
> If I change true to false, or reverse the order of assignment
> statements, string value is passed as is.
>
> This script works with MSSQL OLE DB provider.
>
> Can you suggest what can be wrong here?
>
> --
> WBR, Victor V. Snezhko
> E-mail: snezhko at indorsoft.ru
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://pgfoundry.org/pipermail/oledb-devel/attachments/20060422/a74bbe35/attachment.html