-
Jul 25th, 2014, 08:23 AM
#1
Thread Starter
New Member
Problem with Ado and Seek method
Info:
"PrimaryKey" = If as 4 columns
according to my code, I get an error-type error-
How to Search with a 4 column index?
Source Code:
dim db as new adodb.connection
dim tbData as new adodb.recordset
db.Provider = "Microsoft.ACE.OLEDB.12.0"
db.Open("Data Source=c:\MyDB.accdb)
With tbQua
.ActiveConnection = db
.CursorType = ADODB.CursorTypeEnum.adOpenKeyset
.LockType = ADODB.LockTypeEnum.adLockOptimistic
.CursorLocation = ADODB.CursorLocationEnum.adUseServer
.Open("Zahlen_Quadro_Temp", db, , , ADODB.CommandTypeEnum.adCmdTableDirect)
.Index = "PrimaryKey"
End With
aArr={1,2,3,4}
tbQua.seek (aArr, ADODB.SeekEnum.adSeekFirstEQ)
.....
Thanks
Andreas
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|