Read field from database into variable

[albel]

Hi, I simply wont to read one field in a databasetable into a variable.

dim text as string
text = table.field

How do I do that.
A beginner

[keystone_paul]

I'd recommend reading a tutorial on database access in the first instance.

Jmcilhinney's code bank article covers all you need to know to get you going.

[albel]

This is what I found on the internet but this is not working

Dim a As String
a = Me.dataset.tabel.row(1).field(1)

[jmcilhinney]

This is what I found on the internet but this is not working

Dim a As String
a = Me.dataset.tabel.row(1).field(1)

Have you followed the link provided? If you have then you've got the answer, so posting something else that doesn't work is of no value.

[Tom.Net]

This is what I found on the internet but this is not working

Dim a As String
a = Me.dataset.tabel.row(1).field(1)

You do not need to create and fill an entire dataset if all you are returning is a single value. Your using more resources then you need. Follow JMC's advice and also take a look at the command objects executescalar method for returning a single value.

[jmcilhinney]

Follow JMC's advice and also take a look at the command objects executescalar method for returning a single value.

Which is exactly what the first code example, entitled something like "Getting a single value", in my CodeBank thread does.

[Tom.Net]

Which is exactly what the first code example, entitled something like "Getting a single value", in my CodeBank thread does.

Awww I shouldve assumed as much...