I am trying to grab the value of a specific field where the record pointer is currently at in an asp page with the following javascript:


function Orders_onbeforeopen()
{
var strSQL = "SELECT * FROM material";
var strMcodenum = Material.fields.getValue('mcode_num');
strSQL += " WHERE (mcode_num = '" + strMcodenum + "')";
Orders.setSQLText(strSQL);
}


This code works fine with Access (BOO!!.. I know, I know). When I run this with FoxPro tables I get the following error returned to my browser:


Microsoft JScript runtime error '800a138f'

'Material.fields' is not an object


This is followed with a reference to the above function. Does anybody know the foxpro equiv. to the .fields reference? I don't know where to look something like this up. I'd appreciate any suggestions. Thanks.

-EB