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')
Cetin
>>Dmitry,
>>For a check I quickly did this one (testdata.dbc):
>>
>>Procedure AddCustomer
>>USE testdata!customer In 0 Alias myCustomer
>>Append Blank in 'myCustomer'
>>replace cust_id with Right(Sys(2015),6),Company with ".Net company-"+Ttoc(Datetime(),1)
>>use
>>endproc
>>
>>
>>ASP.Net page with a single button to call procedure:
>>
>> protected void Button1_Click(object sender, EventArgs e)
>> {
>> string strConn = "Provider=VFPOLEDB.1;Data source=d:\\temp\\testdata.dbc;";
>> OleDbConnection cn = new OleDbConnection(strConn);
>> cn.Open();
>> OleDbCommand cmd = cn.CreateCommand();
>> cmd.CommandType = CommandType.StoredProcedure;
>> cmd.CommandText = "AddCustomer";
>> cmd.ExecuteNonQuery();
>> cn.Close();
>> }
>>
It worked. Each time I click I get a new customer.
>
>Cetin,
>
>You are amazing that you can create this code on-the-fly in just a few seconds. Thank you.
>
>On your other comment:
>
>>>
>DataFolder is my suspicion. I used myDBC!myTable style.
>>>
>
>my table is a FREE table so I can't use the syntax myDbf!myTable.
>
>But I will try your code with button click method.
>
>Thank you very much.