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 endprocASP.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.