>>Oh wait a min it's a free table. Then Datafolder is higher suspect:) Is it a fullpath or relative? For a free table you can connect to folder. ie:
>>string strConn = "Provider=VFPOLEDB.1;Data source=d:\\temp;"
>>
>>In your stored procedure add code to check where it's really adding. ie: After use line:
>>
>>StrToFile(dbf(),'c:\Info.txt')
>>
>
>I don't think you can use StrToFile() in Stored procedure called via Ole DB. I usually create a dummy .dbf for that purpose.
Dmitry,
Sorry you're of course right:) However still I think you can return info just to the caller with slight modification:
lcDBF = Dbf('aliashere')
...
return m.lcDBF
ASP.net add say a label named lblInfo.
OleDbCommand cmd = cn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "StoredProcName";
lblInfo.Text = (string)cmd.ExecuteScalar();
Cetin