Inserting DATA from a QUERY into one variable 1

[Genotix]

Hi all,

I'm having some trouble inserting data from a recordset in a variable.

De default method like

Label1.Caption = RS!Number

always worked for mee.

But....
Now i've combined two tables (Path and Recipe) in which both tables have a Primary Key called "Number"
Logically i entered the following

Label1.Caption = RS!Path.Number

This results in a notification which says :
"Compile error : Method or data member not found"

Does anybody know what the right syntax is?

Linux IS userfriendly.
It's only very selective about who it's friends are.

 

[AEtherson]

use RS("Path.Number")

 

[Genotix]

Thanx for the info.

I just found that out myself also (just by trying).
It's a pitty that there is no consistence in this.

Linux IS userfriendly.
It's only very selective about who it's friends are.