|
-
Dec 17th, 2003, 04:05 AM
#1
Thread Starter
Lively Member
value in dataset: not resolved???
Hi, I'm here again
I found a code snippet to retrieve the value of the first row and the column 'RightsID' of the tblUsers in a dataset (DSUsers)
The Column RightsID is an integer in the underlying access database.
The strange thing is that I can show the requested value in a messagebox by the following code:
MsgBox(DSUsers.Tables("tblUsers").Rows(0)("RightsID"), MsgBoxStyle.Critical, "Bedrijf gevonden")
The shown value is '2' and this is correct.
But when I want to assign the value to a defined integer variable, the value is '0', which is not correct because it should be '2'
I used the following code:
dim UserRights as Integer
UserRights = DSUsers.Tables("tblUsers").Rows(0)("RightsID")
Is there anybody who can help me???
Thanx,
Tom
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
|