>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

You will need to use ADO to get data from Foxpro. There are several examples on Microsoft's Foxpro Website on how to do this.