Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsVB SyntaxEnterprise DevelopmentDatabase AccessControlsCOMWin APICrystal ReportDeploymentGeneralGeneral 2
Related Topics
VB.NET / ASP.NETMS SQL ServerMS AccessOther Database ProductsMore Topics ...

VB Forum / COM / April 2008



Tip: Looking for answers? Try searching our database.

Find field that origin a Ado recordset error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dedalus - 18 Apr 2008 15:04 GMT
I have this situation:

---------------------------------
dim sSqlSelect            As  String
dim vValues                As     Variant
dim vFields                As     Variant
dim rs                    As    AdoDb.Recordset
dim cnn                    As    AdoDb.Connection

set cnn=New AdoDb.Connection
...
set rs= New AdoDb.Recordset
with rs
    ...
    .Open sSqlSelect
end with

vFields=array("aField1","aField2","aField3")
vValues=array(aValue1,aValue2,aValue3)
rs.Update vFields,vValues
---------------------------------

For example, if the aFields it is a text field with size =2,
and aValue2 is a string with mora than 2 characters, the Update
method raise an error.
I can retrieve the exact field that raise the error?
Jan Hyde (VB MVP) - 18 Apr 2008 16:22 GMT
Dedalus <ulysse@email.it>'s wild thoughts were released on
Fri, 18 Apr 2008 07:04:54 -0700 (PDT) bearing the following
fruit:

>I have this situation:
>
[quoted text clipped - 22 lines]
>method raise an error.
>I can retrieve the exact field that raise the error?

You already have a thread here for this, please don't start
new ones.
--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde
Dedalus - 20 Apr 2008 11:50 GMT
On 18 Apr, 17:22, "Jan Hyde (VB MVP)"
<StellaDrin...@REMOVE.ME.uboot.com> wrote:

> You already have a thread here for this, please don't start
> new ones.
> --
> Jan Hyde
>
> https://mvp.support.microsoft.com/profile/Jan.Hyde

It is a no intentional error. I'm sorry.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.