Table has no index order set.

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Table has no index order set.

Message

From

27/05/2003 04:39:19

Aashish Sharma
Enliten IT India
Mumbai, India

26/05/2003 16:35:13

Sergey Berezniker
New York, United States

General information

Forum:

Visual FoxPro

Category:

Databases,Tables, Views, Indexing and SQL syntax

Title:

Re: Table has no index order set.

Miscellaneous

Thread ID:

00792539

Message ID:

00792990

Views:

View Definition:
********************START****************************************
SELECT Product.name AS prodname, Customer.name AS custname,;
Supplier.name AS suppname, Category.name AS catname,;
Executive.name AS execname, Company.name AS compname, Company.code,;
Company.sname, Company.iecode, Company.rbicode, Company.address,;
Company.template1, Company.template2, Company.logo, Company.bondno,;
Company.bondstdate, Company.bondenddate, Company.bondlimit,;
Executive.code, Executive.frombranch, Supplier.code, Supplier.sname,;
Supplier.address, Supplier.citycode, Supplier.cntrycode, Supplier.telno1,;
Supplier.telno2, Supplier.telno3, Supplier.faxno1, Supplier.faxno2,;
Supplier.emailno1, Supplier.emailno2, Supplier.website, Supplier.counter,;
Supplier.lastupdate, Supplier.addedon, Supplier.isagent, Supplier.agent1,;
Supplier.agent2, Supplier.agentinfo, Supplier.profile,;
Supplier.profilefile, Customer.code, Customer.sname, Customer.address,;
Customer.citycode, Customer.cntrycode, Customer.telno1, Customer.telno2,;
Customer.telno3, Customer.faxno1, Customer.faxno2, Customer.emailno1,;
Customer.emailno2, Customer.website, Customer.counter,;
Customer.lastupdate, Customer.addedon, Customer.isagent, Customer.agent1,;
Customer.agent2, Customer.agentinfo, Customer.profile,;
Customer.profilefile, Product.code, Product.casno, Product.sname,;
Product.addedon, Product.lastupdate, Product.notes, Product.depbsrno,;
Product.depbpublicnoticeno, Product.depbrateofcreditfob,;
Product.depbnotes, Product.deecsrno, Product.deecnotes, Category.code,;
Category.type, Category.description, Indent.*, Indentlots.*;
FROM ;
mis!company,;
mis!executive,;
mis!supplier,;
mis!customer,;
mis!product,;
mis!category,;
mis!indent ;
LEFT OUTER JOIN mis!indentlots ;
ON Indent.code = Indentlots.indcode;
WHERE ( ( ( ( Indent.custcode = Customer.code;
AND Indent.suppcode = Supplier.code );
AND Indent.category = Category.code );
AND Indent.company = Company.code );
AND Indent.executive = Executive.code );
AND Indent.prodcode = Product.code;
ORDER BY Indent.indentno, Indent.inddate

DBSetProp(ThisView,"View","SendUpdates",.F.)
DBSetProp(ThisView,"View","BatchUpdateCount",1)
DBSetProp(ThisView,"View","CompareMemo",.T.)
DBSetProp(ThisView,"View","FetchAsNeeded",.F.)
DBSetProp(ThisView,"View","FetchMemo",.T.)
DBSetProp(ThisView,"View","FetchSize",100)
DBSetProp(ThisView,"View","MaxRecords",-1)
DBSetProp(ThisView,"View","Prepared",.F.)
DBSetProp(ThisView,"View","UpdateType",1)
DBSetProp(ThisView,"View","UseMemoSize",255)
DBSetProp(ThisView,"View","Tables","mis!company,mis!executive,mis!product,mis!category,mis!indent,mis!indentlots")
DBSetProp(ThisView,"View","WhereType",3)

DBSetProp(ThisView+".prodname","Field","DataType","C(200)")
DBSetProp(ThisView+".prodname","Field","UpdateName","mis!product.name")
DBSetProp(ThisView+".prodname","Field","KeyField",.F.)
DBSetProp(ThisView+".prodname","Field","Updatable",.F.)

DBSetProp(ThisView+".custname","Field","DataType","C(150)")
DBSetProp(ThisView+".custname","Field","UpdateName","mis!customer.name")
DBSetProp(ThisView+".custname","Field","KeyField",.F.)
DBSetProp(ThisView+".custname","Field","Updatable",.F.)

DBSetProp(ThisView+".suppname","Field","DataType","C(150)")
DBSetProp(ThisView+".suppname","Field","UpdateName","mis!supplier.name")
DBSetProp(ThisView+".suppname","Field","KeyField",.F.)
DBSetProp(ThisView+".suppname","Field","Updatable",.F.)

DBSetProp(ThisView+".catname","Field","DataType","C(50)")
DBSetProp(ThisView+".catname","Field","UpdateName","mis!category.name")
DBSetProp(ThisView+".catname","Field","KeyField",.F.)
DBSetProp(ThisView+".catname","Field","Updatable",.F.)

DBSetProp(ThisView+".execname","Field","DataType","C(150)")
DBSetProp(ThisView+".execname","Field","UpdateName","mis!executive.name")
DBSetProp(ThisView+".execname","Field","KeyField",.F.)
DBSetProp(ThisView+".execname","Field","Updatable",.F.)

DBSetProp(ThisView+".compname","Field","DataType","C(150)")
DBSetProp(ThisView+".compname","Field","UpdateName","mis!company.name")
DBSetProp(ThisView+".compname","Field","KeyField",.F.)
DBSetProp(ThisView+".compname","Field","Updatable",.F.)

DBSetProp(ThisView+".code_a","Field","DataType","C(10)")
DBSetProp(ThisView+".code_a","Field","UpdateName","mis!company.code")
DBSetProp(ThisView+".code_a","Field","KeyField",.F.)
DBSetProp(ThisView+".code_a","Field","Updatable",.F.)

DBSetProp(ThisView+".sname_a","Field","DataType","C(4)")
DBSetProp(ThisView+".sname_a","Field","UpdateName","mis!company.sname")
DBSetProp(ThisView+".sname_a","Field","KeyField",.F.)
DBSetProp(ThisView+".sname_a","Field","Updatable",.F.)

DBSetProp(ThisView+".iecode","Field","DataType","C(50)")
DBSetProp(ThisView+".iecode","Field","UpdateName","mis!company.iecode")
DBSetProp(ThisView+".iecode","Field","KeyField",.F.)
DBSetProp(ThisView+".iecode","Field","Updatable",.T.)

DBSetProp(ThisView+".rbicode","Field","DataType","C(50)")
DBSetProp(ThisView+".rbicode","Field","UpdateName","mis!company.rbicode")
DBSetProp(ThisView+".rbicode","Field","KeyField",.F.)
DBSetProp(ThisView+".rbicode","Field","Updatable",.T.)

DBSetProp(ThisView+".address_a","Field","DataType","M")
DBSetProp(ThisView+".address_a","Field","UpdateName","mis!company.address")
DBSetProp(ThisView+".address_a","Field","KeyField",.F.)
DBSetProp(ThisView+".address_a","Field","Updatable",.F.)

DBSetProp(ThisView+".template1","Field","DataType","C(200)")
DBSetProp(ThisView+".template1","Field","UpdateName","mis!company.template1")
DBSetProp(ThisView+".template1","Field","KeyField",.F.)
DBSetProp(ThisView+".template1","Field","Updatable",.T.)

DBSetProp(ThisView+".template2","Field","DataType","C(200)")
DBSetProp(ThisView+".template2","Field","UpdateName","mis!company.template2")
DBSetProp(ThisView+".template2","Field","KeyField",.F.)
DBSetProp(ThisView+".template2","Field","Updatable",.T.)

DBSetProp(ThisView+".logo","Field","DataType","G")
DBSetProp(ThisView+".logo","Field","UpdateName","mis!company.logo")
DBSetProp(ThisView+".logo","Field","KeyField",.F.)
DBSetProp(ThisView+".logo","Field","Updatable",.T.)

DBSetProp(ThisView+".bondno","Field","DataType","C(30)")
DBSetProp(ThisView+".bondno","Field","UpdateName","mis!company.bondno")
DBSetProp(ThisView+".bondno","Field","KeyField",.F.)
DBSetProp(ThisView+".bondno","Field","Updatable",.T.)

DBSetProp(ThisView+".bondstdate","Field","DataType","D")
DBSetProp(ThisView+".bondstdate","Field","UpdateName","mis!company.bondstdate")
DBSetProp(ThisView+".bondstdate","Field","KeyField",.F.)
DBSetProp(ThisView+".bondstdate","Field","Updatable",.T.)

DBSetProp(ThisView+".bondenddate","Field","DataType","D")
DBSetProp(ThisView+".bondenddate","Field","UpdateName","mis!company.bondenddate")
DBSetProp(ThisView+".bondenddate","Field","KeyField",.F.)
DBSetProp(ThisView+".bondenddate","Field","Updatable",.T.)

DBSetProp(ThisView+".bondlimit","Field","DataType","N(14,2)")
DBSetProp(ThisView+".bondlimit","Field","UpdateName","mis!company.bondlimit")
DBSetProp(ThisView+".bondlimit","Field","KeyField",.F.)
DBSetProp(ThisView+".bondlimit","Field","Updatable",.T.)

DBSetProp(ThisView+".code_b","Field","DataType","C(10)")
DBSetProp(ThisView+".code_b","Field","UpdateName","mis!executive.code")
DBSetProp(ThisView+".code_b","Field","KeyField",.F.)
DBSetProp(ThisView+".code_b","Field","Updatable",.F.)

DBSetProp(ThisView+".frombranch","Field","DataType","C(10)")
DBSetProp(ThisView+".frombranch","Field","UpdateName","mis!executive.frombranch")
DBSetProp(ThisView+".frombranch","Field","KeyField",.F.)
DBSetProp(ThisView+".frombranch","Field","Updatable",.T.)

DBSetProp(ThisView+".code_c","Field","DataType","C(10)")
DBSetProp(ThisView+".code_c","Field","UpdateName","mis!supplier.code")
DBSetProp(ThisView+".code_c","Field","KeyField",.F.)
DBSetProp(ThisView+".code_c","Field","Updatable",.F.)

DBSetProp(ThisView+".sname_b","Field","DataType","C(10)")
DBSetProp(ThisView+".sname_b","Field","UpdateName","mis!supplier.sname")
DBSetProp(ThisView+".sname_b","Field","KeyField",.F.)
DBSetProp(ThisView+".sname_b","Field","Updatable",.F.)

DBSetProp(ThisView+".address_b","Field","DataType","M")
DBSetProp(ThisView+".address_b","Field","UpdateName","mis!supplier.address")
DBSetProp(ThisView+".address_b","Field","KeyField",.F.)
DBSetProp(ThisView+".address_b","Field","Updatable",.F.)

DBSetProp(ThisView+".citycode_a","Field","DataType","C(10)")
DBSetProp(ThisView+".citycode_a","Field","UpdateName","mis!supplier.citycode")
DBSetProp(ThisView+".citycode_a","Field","KeyField",.F.)
DBSetProp(ThisView+".citycode_a","Field","Updatable",.F.)

DBSetProp(ThisView+".cntrycode_a","Field","DataType","C(10)")
DBSetProp(ThisView+".cntrycode_a","Field","UpdateName","mis!supplier.cntrycode")
DBSetProp(ThisView+".cntrycode_a","Field","KeyField",.F.)
DBSetProp(ThisView+".cntrycode_a","Field","Updatable",.F.)

DBSetProp(ThisView+".telno1_a","Field","DataType","C(20)")
DBSetProp(ThisView+".telno1_a","Field","UpdateName","mis!supplier.telno1")
DBSetProp(ThisView+".telno1_a","Field","KeyField",.F.)
DBSetProp(ThisView+".telno1_a","Field","Updatable",.F.)

DBSetProp(ThisView+".telno2_a","Field","DataType","C(20)")
DBSetProp(ThisView+".telno2_a","Field","UpdateName","mis!supplier.telno2")
DBSetProp(ThisView+".telno2_a","Field","KeyField",.F.)
DBSetProp(ThisView+".telno2_a","Field","Updatable",.F.)

DBSetProp(ThisView+".telno3_a","Field","DataType","C(20)")
DBSetProp(ThisView+".telno3_a","Field","UpdateName","mis!supplier.telno3")
DBSetProp(ThisView+".telno3_a","Field","KeyField",.F.)
DBSetProp(ThisView+".telno3_a","Field","Updatable",.F.)

DBSetProp(ThisView+".faxno1_a","Field","DataType","C(20)")
DBSetProp(ThisView+".faxno1_a","Field","UpdateName","mis!supplier.faxno1")
DBSetProp(ThisView+".faxno1_a","Field","KeyField",.F.)
DBSetProp(ThisView+".faxno1_a","Field","Updatable",.F.)

DBSetProp(ThisView+".faxno2_a","Field","DataType","C(20)")
DBSetProp(ThisView+".faxno2_a","Field","UpdateName","mis!supplier.faxno2")
DBSetProp(ThisView+".faxno2_a","Field","KeyField",.F.)
DBSetProp(ThisView+".faxno2_a","Field","Updatable",.F.)

DBSetProp(ThisView+".emailno1_a","Field","DataType","C(50)")
DBSetProp(ThisView+".emailno1_a","Field","UpdateName","mis!supplier.emailno1")
DBSetProp(ThisView+".emailno1_a","Field","KeyField",.F.)
DBSetProp(ThisView+".emailno1_a","Field","Updatable",.F.)

DBSetProp(ThisView+".emailno2_a","Field","DataType","C(50)")
DBSetProp(ThisView+".emailno2_a","Field","UpdateName","mis!supplier.emailno2")
DBSetProp(ThisView+".emailno2_a","Field","KeyField",.F.)
DBSetProp(ThisView+".emailno2_a","Field","Updatable",.F.)

DBSetProp(ThisView+".website_a","Field","DataType","C(100)")
DBSetProp(ThisView+".website_a","Field","UpdateName","mis!supplier.website")
DBSetProp(ThisView+".website_a","Field","KeyField",.F.)
DBSetProp(ThisView+".website_a","Field","Updatable",.F.)

DBSetProp(ThisView+".counter_a","Field","DataType","N(10)")
DBSetProp(ThisView+".counter_a","Field","UpdateName","mis!supplier.counter")
DBSetProp(ThisView+".counter_a","Field","KeyField",.F.)
DBSetProp(ThisView+".counter_a","Field","Updatable",.F.)

DBSetProp(ThisView+".lastupdate_a","Field","DataType","T")
DBSetProp(ThisView+".lastupdate_a","Field","UpdateName","mis!supplier.lastupdate")
DBSetProp(ThisView+".lastupdate_a","Field","KeyField",.F.)
DBSetProp(ThisView+".lastupdate_a","Field","Updatable",.F.)

DBSetProp(ThisView+".addedon_a","Field","DataType","T")
DBSetProp(ThisView+".addedon_a","Field","UpdateName","mis!supplier.addedon")
DBSetProp(ThisView+".addedon_a","Field","KeyField",.F.)
DBSetProp(ThisView+".addedon_a","Field","Updatable",.F.)

DBSetProp(ThisView+".isagent_a","Field","DataType","L")
DBSetProp(ThisView+".isagent_a","Field","UpdateName","mis!supplier.isagent")
DBSetProp(ThisView+".isagent_a","Field","KeyField",.F.)
DBSetProp(ThisView+".isagent_a","Field","Updatable",.F.)

DBSetProp(ThisView+".agent1_a","Field","DataType","C(10)")
DBSetProp(ThisView+".agent1_a","Field","UpdateName","mis!supplier.agent1")
DBSetProp(ThisView+".agent1_a","Field","KeyField",.F.)
DBSetProp(ThisView+".agent1_a","Field","Updatable",.F.)

DBSetProp(ThisView+".agent2_a","Field","DataType","C(10)")
DBSetProp(ThisView+".agent2_a","Field","UpdateName","mis!supplier.agent2")
DBSetProp(ThisView+".agent2_a","Field","KeyField",.F.)
DBSetProp(ThisView+".agent2_a","Field","Updatable",.F.)

DBSetProp(ThisView+".agentinfo_a","Field","DataType","M")
DBSetProp(ThisView+".agentinfo_a","Field","UpdateName","mis!supplier.agentinfo")
DBSetProp(ThisView+".agentinfo_a","Field","KeyField",.F.)
DBSetProp(ThisView+".agentinfo_a","Field","Updatable",.F.)

DBSetProp(ThisView+".profile_a","Field","DataType","M")
DBSetProp(ThisView+".profile_a","Field","UpdateName","mis!supplier.profile")
DBSetProp(ThisView+".profile_a","Field","KeyField",.F.)
DBSetProp(ThisView+".profile_a","Field","Updatable",.F.)

DBSetProp(ThisView+".profilefile_a","Field","DataType","C(200)")
DBSetProp(ThisView+".profilefile_a","Field","UpdateName","mis!supplier.profilefile")
DBSetProp(ThisView+".profilefile_a","Field","KeyField",.F.)
DBSetProp(ThisView+".profilefile_a","Field","Updatable",.F.)

DBSetProp(ThisView+".code_d","Field","DataType","C(10)")
DBSetProp(ThisView+".code_d","Field","UpdateName","mis!customer.code")
DBSetProp(ThisView+".code_d","Field","KeyField",.F.)
DBSetProp(ThisView+".code_d","Field","Updatable",.F.)

DBSetProp(ThisView+".sname_c","Field","DataType","C(10)")
DBSetProp(ThisView+".sname_c","Field","UpdateName","mis!customer.sname")
DBSetProp(ThisView+".sname_c","Field","KeyField",.F.)
DBSetProp(ThisView+".sname_c","Field","Updatable",.F.)

DBSetProp(ThisView+".address_c","Field","DataType","M")
DBSetProp(ThisView+".address_c","Field","UpdateName","mis!customer.address")
DBSetProp(ThisView+".address_c","Field","KeyField",.F.)
DBSetProp(ThisView+".address_c","Field","Updatable",.F.)

DBSetProp(ThisView+".citycode_b","Field","DataType","C(10)")
DBSetProp(ThisView+".citycode_b","Field","UpdateName","mis!customer.citycode")
DBSetProp(ThisView+".citycode_b","Field","KeyField",.F.)
DBSetProp(ThisView+".citycode_b","Field","Updatable",.F.)

DBSetProp(ThisView+".cntrycode_b","Field","DataType","C(10)")
DBSetProp(ThisView+".cntrycode_b","Field","UpdateName","mis!customer.cntrycode")
DBSetProp(ThisView+".cntrycode_b","Field","KeyField",.F.)
DBSetProp(ThisView+".cntrycode_b","Field","Updatable",.F.)

DBSetProp(ThisView+".telno1_b","Field","DataType","C(20)")
DBSetProp(ThisView+".telno1_b","Field","UpdateName","mis!customer.telno1")
DBSetProp(ThisView+".telno1_b","Field","KeyField",.F.)
DBSetProp(ThisView+".telno1_b","Field","Updatable",.F.)

DBSetProp(ThisView+".telno2_b","Field","DataType","C(20)")
DBSetProp(ThisView+".telno2_b","Field","UpdateName","mis!customer.telno2")
DBSetProp(ThisView+".telno2_b","Field","KeyField",.F.)
DBSetProp(ThisView+".telno2_b","Field","Updatable",.F.)

DBSetProp(ThisView+".telno3_b","Field","DataType","C(20)")
DBSetProp(ThisView+".telno3_b","Field","UpdateName","mis!customer.telno3")
DBSetProp(ThisView+".telno3_b","Field","KeyField",.F.)
DBSetProp(ThisView+".telno3_b","Field","Updatable",.F.)

DBSetProp(ThisView+".faxno1_b","Field","DataType","C(20)")
DBSetProp(ThisView+".faxno1_b","Field","UpdateName","mis!customer.faxno1")
DBSetProp(ThisView+".faxno1_b","Field","KeyField",.F.)
DBSetProp(ThisView+".faxno1_b","Field","Updatable",.F.)

DBSetProp(ThisView+".faxno2_b","Field","DataType","C(20)")
DBSetProp(ThisView+".faxno2_b","Field","UpdateName","mis!customer.faxno2")
DBSetProp(ThisView+".faxno2_b","Field","KeyField",.F.)
DBSetProp(ThisView+".faxno2_b","Field","Updatable",.F.)

DBSetProp(ThisView+".emailno1_b","Field","DataType","C(50)")
DBSetProp(ThisView+".emailno1_b","Field","UpdateName","mis!customer.emailno1")
DBSetProp(ThisView+".emailno1_b","Field","KeyField",.F.)
DBSetProp(ThisView+".emailno1_b","Field","Updatable",.F.)

DBSetProp(ThisView+".emailno2_b","Field","DataType","C(50)")
DBSetProp(ThisView+".emailno2_b","Field","UpdateName","mis!customer.emailno2")
DBSetProp(ThisView+".emailno2_b","Field","KeyField",.F.)
DBSetProp(ThisView+".emailno2_b","Field","Updatable",.F.)

DBSetProp(ThisView+".website_b","Field","DataType","C(100)")
DBSetProp(ThisView+".website_b","Field","UpdateName","mis!customer.website")
DBSetProp(ThisView+".website_b","Field","KeyField",.F.)
DBSetProp(ThisView+".website_b","Field","Updatable",.F.)

DBSetProp(ThisView+".counter_b","Field","DataType","N(10)")
DBSetProp(ThisView+".counter_b","Field","UpdateName","mis!customer.counter")
DBSetProp(ThisView+".counter_b","Field","KeyField",.F.)
DBSetProp(ThisView+".counter_b","Field","Updatable",.F.)

DBSetProp(ThisView+".lastupdate_b","Field","DataType","T")
DBSetProp(ThisView+".lastupdate_b","Field","UpdateName","mis!customer.lastupdate")
DBSetProp(ThisView+".lastupdate_b","Field","KeyField",.F.)
DBSetProp(ThisView+".lastupdate_b","Field","Updatable",.F.)

DBSetProp(ThisView+".addedon_b","Field","DataType","T")
DBSetProp(ThisView+".addedon_b","Field","UpdateName","mis!customer.addedon")
DBSetProp(ThisView+".addedon_b","Field","KeyField",.F.)
DBSetProp(ThisView+".addedon_b","Field","Updatable",.F.)

DBSetProp(ThisView+".isagent_b","Field","DataType","L")
DBSetProp(ThisView+".isagent_b","Field","UpdateName","mis!customer.isagent")
DBSetProp(ThisView+".isagent_b","Field","KeyField",.F.)
DBSetProp(ThisView+".isagent_b","Field","Updatable",.F.)

DBSetProp(ThisView+".agent1_b","Field","DataType","C(10)")
DBSetProp(ThisView+".agent1_b","Field","UpdateName","mis!customer.agent1")
DBSetProp(ThisView+".agent1_b","Field","KeyField",.F.)
DBSetProp(ThisView+".agent1_b","Field","Updatable",.F.)

DBSetProp(ThisView+".agent2_b","Field","DataType","C(10)")
DBSetProp(ThisView+".agent2_b","Field","UpdateName","mis!customer.agent2")
DBSetProp(ThisView+".agent2_b","Field","KeyField",.F.)
DBSetProp(ThisView+".agent2_b","Field","Updatable",.F.)

DBSetProp(ThisView+".agentinfo_b","Field","DataType","M")
DBSetProp(ThisView+".agentinfo_b","Field","UpdateName","mis!customer.agentinfo")
DBSetProp(ThisView+".agentinfo_b","Field","KeyField",.F.)
DBSetProp(ThisView+".agentinfo_b","Field","Updatable",.F.)

DBSetProp(ThisView+".profile_b","Field","DataType","M")
DBSetProp(ThisView+".profile_b","Field","UpdateName","mis!customer.profile")
DBSetProp(ThisView+".profile_b","Field","KeyField",.F.)
DBSetProp(ThisView+".profile_b","Field","Updatable",.F.)

DBSetProp(ThisView+".profilefile_b","Field","DataType","C(200)")
DBSetProp(ThisView+".profilefile_b","Field","UpdateName","mis!customer.profilefile")
DBSetProp(ThisView+".profilefile_b","Field","KeyField",.F.)
DBSetProp(ThisView+".profilefile_b","Field","Updatable",.F.)

DBSetProp(ThisView+".code_e","Field","DataType","C(10)")
DBSetProp(ThisView+".code_e","Field","UpdateName","mis!product.code")
DBSetProp(ThisView+".code_e","Field","KeyField",.F.)
DBSetProp(ThisView+".code_e","Field","Updatable",.F.)

DBSetProp(ThisView+".casno","Field","DataType","C(20)")
DBSetProp(ThisView+".casno","Field","UpdateName","mis!product.casno")
DBSetProp(ThisView+".casno","Field","KeyField",.F.)
DBSetProp(ThisView+".casno","Field","Updatable",.T.)

DBSetProp(ThisView+".sname_d","Field","DataType","C(20)")
DBSetProp(ThisView+".sname_d","Field","UpdateName","mis!product.sname")
DBSetProp(ThisView+".sname_d","Field","KeyField",.F.)
DBSetProp(ThisView+".sname_d","Field","Updatable",.F.)

DBSetProp(ThisView+".addedon_c","Field","DataType","T")
DBSetProp(ThisView+".addedon_c","Field","UpdateName","mis!product.addedon")
DBSetProp(ThisView+".addedon_c","Field","KeyField",.F.)
DBSetProp(ThisView+".addedon_c","Field","Updatable",.F.)

DBSetProp(ThisView+".lastupdate_c","Field","DataType","T")
DBSetProp(ThisView+".lastupdate_c","Field","UpdateName","mis!product.lastupdate")
DBSetProp(ThisView+".lastupdate_c","Field","KeyField",.F.)
DBSetProp(ThisView+".lastupdate_c","Field","Updatable",.F.)

DBSetProp(ThisView+".notes","Field","DataType","M")
DBSetProp(ThisView+".notes","Field","UpdateName","mis!product.notes")
DBSetProp(ThisView+".notes","Field","KeyField",.F.)
DBSetProp(ThisView+".notes","Field","Updatable",.T.)

DBSetProp(ThisView+".depbsrno","Field","DataType","N(10)")
DBSetProp(ThisView+".depbsrno","Field","UpdateName","mis!product.depbsrno")
DBSetProp(ThisView+".depbsrno","Field","KeyField",.F.)
DBSetProp(ThisView+".depbsrno","Field","Updatable",.T.)

DBSetProp(ThisView+".depbpublicnoticeno","Field","DataType","C(30)")
DBSetProp(ThisView+".depbpublicnoticeno","Field","UpdateName","mis!product.depbpublicnoticeno")
DBSetProp(ThisView+".depbpublicnoticeno","Field","KeyField",.F.)
DBSetProp(ThisView+".depbpublicnoticeno","Field","Updatable",.T.)

DBSetProp(ThisView+".depbrateofcreditfob","Field","DataType","N(10,2)")
DBSetProp(ThisView+".depbrateofcreditfob","Field","UpdateName","mis!product.depbrateofcreditfob")
DBSetProp(ThisView+".depbrateofcreditfob","Field","KeyField",.F.)
DBSetProp(ThisView+".depbrateofcreditfob","Field","Updatable",.T.)

DBSetProp(ThisView+".depbnotes","Field","DataType","M")
DBSetProp(ThisView+".depbnotes","Field","UpdateName","mis!product.depbnotes")
DBSetProp(ThisView+".depbnotes","Field","KeyField",.F.)
DBSetProp(ThisView+".depbnotes","Field","Updatable",.T.)

DBSetProp(ThisView+".deecsrno","Field","DataType","C(10)")
DBSetProp(ThisView+".deecsrno","Field","UpdateName","mis!product.deecsrno")
DBSetProp(ThisView+".deecsrno","Field","KeyField",.F.)
DBSetProp(ThisView+".deecsrno","Field","Updatable",.T.)

DBSetProp(ThisView+".deecnotes","Field","DataType","M")
DBSetProp(ThisView+".deecnotes","Field","UpdateName","mis!product.deecnotes")
DBSetProp(ThisView+".deecnotes","Field","KeyField",.F.)
DBSetProp(ThisView+".deecnotes","Field","Updatable",.T.)

DBSetProp(ThisView+".code_f","Field","DataType","C(10)")
DBSetProp(ThisView+".code_f","Field","UpdateName","mis!category.code")
DBSetProp(ThisView+".code_f","Field","KeyField",.F.)
DBSetProp(ThisView+".code_f","Field","Updatable",.F.)

DBSetProp(ThisView+".type","Field","DataType","C(1)")
DBSetProp(ThisView+".type","Field","UpdateName","mis!category.type")
DBSetProp(ThisView+".type","Field","KeyField",.F.)
DBSetProp(ThisView+".type","Field","Updatable",.T.)

DBSetProp(ThisView+".description","Field","DataType","M")
DBSetProp(ThisView+".description","Field","UpdateName","mis!category.description")
DBSetProp(ThisView+".description","Field","KeyField",.F.)
DBSetProp(ThisView+".description","Field","Updatable",.T.)

DBSetProp(ThisView+".code_g","Field","DataType","C(10)")
DBSetProp(ThisView+".code_g","Field","UpdateName","mis!indent.code")
DBSetProp(ThisView+".code_g","Field","KeyField",.F.)
DBSetProp(ThisView+".code_g","Field","Updatable",.F.)

DBSetProp(ThisView+".indentno_a","Field","DataType","C(20)")
DBSetProp(ThisView+".indentno_a","Field","UpdateName","mis!indent.indentno")
DBSetProp(ThisView+".indentno_a","Field","KeyField",.F.)
DBSetProp(ThisView+".indentno_a","Field","Updatable",.F.)

DBSetProp(ThisView+".inddate","Field","DataType","D")
DBSetProp(ThisView+".inddate","Field","UpdateName","mis!indent.inddate")
DBSetProp(ThisView+".inddate","Field","KeyField",.F.)
DBSetProp(ThisView+".inddate","Field","Updatable",.T.)

DBSetProp(ThisView+".contractno","Field","DataType","C(20)")
DBSetProp(ThisView+".contractno","Field","UpdateName","mis!indent.contractno")
DBSetProp(ThisView+".contractno","Field","KeyField",.F.)
DBSetProp(ThisView+".contractno","Field","Updatable",.T.)

DBSetProp(ThisView+".contractdate","Field","DataType","D")
DBSetProp(ThisView+".contractdate","Field","UpdateName","mis!indent.contractdate")
DBSetProp(ThisView+".contractdate","Field","KeyField",.F.)
DBSetProp(ThisView+".contractdate","Field","Updatable",.T.)

DBSetProp(ThisView+".custcode","Field","DataType","C(10)")
DBSetProp(ThisView+".custcode","Field","UpdateName","mis!indent.custcode")
DBSetProp(ThisView+".custcode","Field","KeyField",.F.)
DBSetProp(ThisView+".custcode","Field","Updatable",.T.)

DBSetProp(ThisView+".caddress","Field","DataType","M")
DBSetProp(ThisView+".caddress","Field","UpdateName","mis!indent.caddress")
DBSetProp(ThisView+".caddress","Field","KeyField",.F.)
DBSetProp(ThisView+".caddress","Field","Updatable",.T.)

DBSetProp(ThisView+".suppcode","Field","DataType","C(10)")
DBSetProp(ThisView+".suppcode","Field","UpdateName","mis!indent.suppcode")
DBSetProp(ThisView+".suppcode","Field","KeyField",.F.)
DBSetProp(ThisView+".suppcode","Field","Updatable",.T.)

DBSetProp(ThisView+".saddress","Field","DataType","M")
DBSetProp(ThisView+".saddress","Field","UpdateName","mis!indent.saddress")
DBSetProp(ThisView+".saddress","Field","KeyField",.F.)
DBSetProp(ThisView+".saddress","Field","Updatable",.T.)

DBSetProp(ThisView+".company","Field","DataType","C(10)")
DBSetProp(ThisView+".company","Field","UpdateName","mis!indent.company")
DBSetProp(ThisView+".company","Field","KeyField",.F.)
DBSetProp(ThisView+".company","Field","Updatable",.T.)

DBSetProp(ThisView+".executive","Field","DataType","C(10)")
DBSetProp(ThisView+".executive","Field","UpdateName","mis!indent.executive")
DBSetProp(ThisView+".executive","Field","KeyField",.F.)
DBSetProp(ThisView+".executive","Field","Updatable",.T.)

DBSetProp(ThisView+".category","Field","DataType","C(10)")
DBSetProp(ThisView+".category","Field","UpdateName","mis!indent.category")
DBSetProp(ThisView+".category","Field","KeyField",.F.)
DBSetProp(ThisView+".category","Field","Updatable",.T.)

DBSetProp(ThisView+".prodcode","Field","DataType","C(10)")
DBSetProp(ThisView+".prodcode","Field","UpdateName","mis!indent.prodcode")
DBSetProp(ThisView+".prodcode","Field","KeyField",.F.)
DBSetProp(ThisView+".prodcode","Field","Updatable",.T.)

DBSetProp(ThisView+".quantity","Field","DataType","N(14,2)")
DBSetProp(ThisView+".quantity","Field","UpdateName","mis!indent.quantity")
DBSetProp(ThisView+".quantity","Field","KeyField",.F.)
DBSetProp(ThisView+".quantity","Field","Updatable",.T.)

DBSetProp(ThisView+".units","Field","DataType","C(10)")
DBSetProp(ThisView+".units","Field","UpdateName","mis!indent.units")
DBSetProp(ThisView+".units","Field","KeyField",.F.)
DBSetProp(ThisView+".units","Field","Updatable",.T.)

DBSetProp(ThisView+".curr","Field","DataType","C(10)")
DBSetProp(ThisView+".curr","Field","UpdateName","mis!indent.curr")
DBSetProp(ThisView+".curr","Field","KeyField",.F.)
DBSetProp(ThisView+".curr","Field","Updatable",.T.)

DBSetProp(ThisView+".price","Field","DataType","N(14,2)")
DBSetProp(ThisView+".price","Field","UpdateName","mis!indent.price")
DBSetProp(ThisView+".price","Field","KeyField",.F.)
DBSetProp(ThisView+".price","Field","Updatable",.T.)

DBSetProp(ThisView+".fincharges","Field","DataType","N(14,2)")
DBSetProp(ThisView+".fincharges","Field","UpdateName","mis!indent.fincharges")
DBSetProp(ThisView+".fincharges","Field","KeyField",.F.)
DBSetProp(ThisView+".fincharges","Field","Updatable",.T.)

DBSetProp(ThisView+".nooflots","Field","DataType","N(3)")
DBSetProp(ThisView+".nooflots","Field","UpdateName","mis!indent.nooflots")
DBSetProp(ThisView+".nooflots","Field","KeyField",.F.)
DBSetProp(ThisView+".nooflots","Field","Updatable",.T.)

DBSetProp(ThisView+".marks","Field","DataType","M")
DBSetProp(ThisView+".marks","Field","UpdateName","mis!indent.marks")
DBSetProp(ThisView+".marks","Field","KeyField",.F.)
DBSetProp(ThisView+".marks","Field","Updatable",.T.)

DBSetProp(ThisView+".prodmemo","Field","DataType","M")
DBSetProp(ThisView+".prodmemo","Field","UpdateName","mis!indent.prodmemo")
DBSetProp(ThisView+".prodmemo","Field","KeyField",.F.)
DBSetProp(ThisView+".prodmemo","Field","Updatable",.T.)

DBSetProp(ThisView+".qtyunitmemo","Field","DataType","M")
DBSetProp(ThisView+".qtyunitmemo","Field","UpdateName","mis!indent.qtyunitmemo")
DBSetProp(ThisView+".qtyunitmemo","Field","KeyField",.F.)
DBSetProp(ThisView+".qtyunitmemo","Field","Updatable",.T.)

DBSetProp(ThisView+".currpricememo","Field","DataType","M")
DBSetProp(ThisView+".currpricememo","Field","UpdateName","mis!indent.currpricememo")
DBSetProp(ThisView+".currpricememo","Field","KeyField",.F.)
DBSetProp(ThisView+".currpricememo","Field","Updatable",.T.)

DBSetProp(ThisView+".totvaluememo","Field","DataType","M")
DBSetProp(ThisView+".totvaluememo","Field","UpdateName","mis!indent.totvaluememo")
DBSetProp(ThisView+".totvaluememo","Field","KeyField",.F.)
DBSetProp(ThisView+".totvaluememo","Field","Updatable",.T.)

DBSetProp(ThisView+".otherdetails","Field","DataType","M")
DBSetProp(ThisView+".otherdetails","Field","UpdateName","mis!indent.otherdetails")
DBSetProp(ThisView+".otherdetails","Field","KeyField",.F.)
DBSetProp(ThisView+".otherdetails","Field","Updatable",.T.)

DBSetProp(ThisView+".shipport","Field","DataType","C(50)")
DBSetProp(ThisView+".shipport","Field","UpdateName","mis!indent.shipport")
DBSetProp(ThisView+".shipport","Field","KeyField",.F.)
DBSetProp(ThisView+".shipport","Field","Updatable",.T.)

DBSetProp(ThisView+".arrivalport","Field","DataType","C(50)")
DBSetProp(ThisView+".arrivalport","Field","UpdateName","mis!indent.arrivalport")
DBSetProp(ThisView+".arrivalport","Field","KeyField",.F.)
DBSetProp(ThisView+".arrivalport","Field","Updatable",.T.)

DBSetProp(ThisView+".origin","Field","DataType","C(50)")
DBSetProp(ThisView+".origin","Field","UpdateName","mis!indent.origin")
DBSetProp(ThisView+".origin","Field","KeyField",.F.)
DBSetProp(ThisView+".origin","Field","Updatable",.T.)

DBSetProp(ThisView+".shipmode","Field","DataType","C(10)")
DBSetProp(ThisView+".shipmode","Field","UpdateName","mis!indent.shipmode")
DBSetProp(ThisView+".shipmode","Field","KeyField",.F.)
DBSetProp(ThisView+".shipmode","Field","Updatable",.T.)

DBSetProp(ThisView+".pterms","Field","DataType","C(150)")
DBSetProp(ThisView+".pterms","Field","UpdateName","mis!indent.pterms")
DBSetProp(ThisView+".pterms","Field","KeyField",.F.)
DBSetProp(ThisView+".pterms","Field","Updatable",.T.)

DBSetProp(ThisView+".awblastdate","Field","DataType","D")
DBSetProp(ThisView+".awblastdate","Field","UpdateName","mis!indent.awblastdate")
DBSetProp(ThisView+".awblastdate","Field","KeyField",.F.)
DBSetProp(ThisView+".awblastdate","Field","Updatable",.T.)

DBSetProp(ThisView+".negolastdate","Field","DataType","D")
DBSetProp(ThisView+".negolastdate","Field","UpdateName","mis!indent.negolastdate")
DBSetProp(ThisView+".negolastdate","Field","KeyField",.F.)
DBSetProp(ThisView+".negolastdate","Field","Updatable",.T.)

DBSetProp(ThisView+".totvalue","Field","DataType","N(14,2)")
DBSetProp(ThisView+".totvalue","Field","UpdateName","mis!indent.totvalue")
DBSetProp(ThisView+".totvalue","Field","KeyField",.F.)
DBSetProp(ThisView+".totvalue","Field","Updatable",.T.)

DBSetProp(ThisView+".filename","Field","DataType","C(200)")
DBSetProp(ThisView+".filename","Field","UpdateName","mis!indent.filename")
DBSetProp(ThisView+".filename","Field","KeyField",.F.)
DBSetProp(ThisView+".filename","Field","Updatable",.T.)

DBSetProp(ThisView+".exchrate","Field","DataType","N(7,2)")
DBSetProp(ThisView+".exchrate","Field","UpdateName","mis!indent.exchrate")
DBSetProp(ThisView+".exchrate","Field","KeyField",.F.)
DBSetProp(ThisView+".exchrate","Field","Updatable",.T.)

DBSetProp(ThisView+".commpercent","Field","DataType","N(5,2)")
DBSetProp(ThisView+".commpercent","Field","UpdateName","mis!indent.commpercent")
DBSetProp(ThisView+".commpercent","Field","KeyField",.F.)
DBSetProp(ThisView+".commpercent","Field","Updatable",.T.)

DBSetProp(ThisView+".islocal","Field","DataType","L")
DBSetProp(ThisView+".islocal","Field","UpdateName","mis!indent.islocal")
DBSetProp(ThisView+".islocal","Field","KeyField",.F.)
DBSetProp(ThisView+".islocal","Field","Updatable",.T.)

DBSetProp(ThisView+".indcode","Field","DataType","C(10)")
DBSetProp(ThisView+".indcode","Field","UpdateName","mis!indentlots.indcode")
DBSetProp(ThisView+".indcode","Field","KeyField",.F.)
DBSetProp(ThisView+".indcode","Field","Updatable",.T.)

DBSetProp(ThisView+".indentno_b","Field","DataType","C(20)")
DBSetProp(ThisView+".indentno_b","Field","UpdateName","mis!indentlots.indentno")
DBSetProp(ThisView+".indentno_b","Field","KeyField",.F.)
DBSetProp(ThisView+".indentno_b","Field","Updatable",.F.)

DBSetProp(ThisView+".lotno","Field","DataType","N(3)")
DBSetProp(ThisView+".lotno","Field","UpdateName","mis!indentlots.lotno")
DBSetProp(ThisView+".lotno","Field","KeyField",.F.)
DBSetProp(ThisView+".lotno","Field","Updatable",.T.)

DBSetProp(ThisView+".lotqty","Field","DataType","N(14,2)")
DBSetProp(ThisView+".lotqty","Field","UpdateName","mis!indentlots.lotqty")
DBSetProp(ThisView+".lotqty","Field","KeyField",.F.)
DBSetProp(ThisView+".lotqty","Field","Updatable",.T.)

DBSetProp(ThisView+".terms","Field","DataType","C(2)")
DBSetProp(ThisView+".terms","Field","UpdateName","mis!indentlots.terms")
DBSetProp(ThisView+".terms","Field","KeyField",.F.)
DBSetProp(ThisView+".terms","Field","Updatable",.T.)

DBSetProp(ThisView+".creditdays","Field","DataType","N(3)")
DBSetProp(ThisView+".creditdays","Field","UpdateName","mis!indentlots.creditdays")
DBSetProp(ThisView+".creditdays","Field","KeyField",.F.)
DBSetProp(ThisView+".creditdays","Field","Updatable",.T.)

DBSetProp(ThisView+".lcpending","Field","DataType","C(3)")
DBSetProp(ThisView+".lcpending","Field","UpdateName","mis!indentlots.lcpending")
DBSetProp(ThisView+".lcpending","Field","KeyField",.F.)
DBSetProp(ThisView+".lcpending","Field","Updatable",.T.)

DBSetProp(ThisView+".lcno","Field","DataType","C(30)")
DBSetProp(ThisView+".lcno","Field","UpdateName","mis!indentlots.lcno")
DBSetProp(ThisView+".lcno","Field","KeyField",.F.)
DBSetProp(ThisView+".lcno","Field","Updatable",.T.)

DBSetProp(ThisView+".lcopendate","Field","DataType","D")
DBSetProp(ThisView+".lcopendate","Field","UpdateName","mis!indentlots.lcopendate")
DBSetProp(ThisView+".lcopendate","Field","KeyField",.F.)
DBSetProp(ThisView+".lcopendate","Field","Updatable",.T.)

DBSetProp(ThisView+".lcexpdate","Field","DataType","D")
DBSetProp(ThisView+".lcexpdate","Field","UpdateName","mis!indentlots.lcexpdate")
DBSetProp(ThisView+".lcexpdate","Field","KeyField",.F.)
DBSetProp(ThisView+".lcexpdate","Field","Updatable",.T.)

DBSetProp(ThisView+".lcvalue","Field","DataType","N(14,2)")
DBSetProp(ThisView+".lcvalue","Field","UpdateName","mis!indentlots.lcvalue")
DBSetProp(ThisView+".lcvalue","Field","KeyField",.F.)
DBSetProp(ThisView+".lcvalue","Field","Updatable",.T.)

DBSetProp(ThisView+".openingbank","Field","DataType","M")
DBSetProp(ThisView+".openingbank","Field","UpdateName","mis!indentlots.openingbank")
DBSetProp(ThisView+".openingbank","Field","KeyField",.F.)
DBSetProp(ThisView+".openingbank","Field","Updatable",.T.)

DBSetProp(ThisView+".benificiarybank","Field","DataType","M")
DBSetProp(ThisView+".benificiarybank","Field","UpdateName","mis!indentlots.benificiarybank")
DBSetProp(ThisView+".benificiarybank","Field","KeyField",.F.)
DBSetProp(ThisView+".benificiarybank","Field","Updatable",.T.)

DBSetProp(ThisView+".expecdateship","Field","DataType","D")
DBSetProp(ThisView+".expecdateship","Field","UpdateName","mis!indentlots.expecdateship")
DBSetProp(ThisView+".expecdateship","Field","KeyField",.F.)
DBSetProp(ThisView+".expecdateship","Field","Updatable",.T.)

DBSetProp(ThisView+".daduedate","Field","DataType","D")
DBSetProp(ThisView+".daduedate","Field","UpdateName","mis!indentlots.daduedate")
DBSetProp(ThisView+".daduedate","Field","KeyField",.F.)
DBSetProp(ThisView+".daduedate","Field","Updatable",.T.)

DBSetProp(ThisView+".daexpdate","Field","DataType","D")
DBSetProp(ThisView+".daexpdate","Field","UpdateName","mis!indentlots.daexpdate")
DBSetProp(ThisView+".daexpdate","Field","KeyField",.F.)
DBSetProp(ThisView+".daexpdate","Field","Updatable",.T.)

DBSetProp(ThisView+".lcdadetails","Field","DataType","M")
DBSetProp(ThisView+".lcdadetails","Field","UpdateName","mis!indentlots.lcdadetails")
DBSetProp(ThisView+".lcdadetails","Field","KeyField",.F.)
DBSetProp(ThisView+".lcdadetails","Field","Updatable",.T.)

DBSetProp(ThisView+".shippending","Field","DataType","C(3)")
DBSetProp(ThisView+".shippending","Field","UpdateName","mis!indentlots.shippending")
DBSetProp(ThisView+".shippending","Field","KeyField",.F.)
DBSetProp(ThisView+".shippending","Field","Updatable",.T.)

DBSetProp(ThisView+".shiporflightdate","Field","DataType","D")
DBSetProp(ThisView+".shiporflightdate","Field","UpdateName","mis!indentlots.shiporflightdate")
DBSetProp(ThisView+".shiporflightdate","Field","KeyField",.F.)
DBSetProp(ThisView+".shiporflightdate","Field","Updatable",.T.)

DBSetProp(ThisView+".blorawbno","Field","DataType","C(20)")
DBSetProp(ThisView+".blorawbno","Field","UpdateName","mis!indentlots.blorawbno")
DBSetProp(ThisView+".blorawbno","Field","KeyField",.F.)
DBSetProp(ThisView+".blorawbno","Field","Updatable",.T.)

DBSetProp(ThisView+".vesselorflightno","Field","DataType","C(20)")
DBSetProp(ThisView+".vesselorflightno","Field","UpdateName","mis!indentlots.vesselorflightno")
DBSetProp(ThisView+".vesselorflightno","Field","KeyField",.F.)
DBSetProp(ThisView+".vesselorflightno","Field","Updatable",.T.)

DBSetProp(ThisView+".invoiceno","Field","DataType","C(20)")
DBSetProp(ThisView+".invoiceno","Field","UpdateName","mis!indentlots.invoiceno")
DBSetProp(ThisView+".invoiceno","Field","KeyField",.F.)
DBSetProp(ThisView+".invoiceno","Field","Updatable",.T.)

DBSetProp(ThisView+".shipdetails","Field","DataType","M")
DBSetProp(ThisView+".shipdetails","Field","UpdateName","mis!indentlots.shipdetails")
DBSetProp(ThisView+".shipdetails","Field","KeyField",.F.)
DBSetProp(ThisView+".shipdetails","Field","Updatable",.T.)

DBSetProp(ThisView+".commpending","Field","DataType","C(3)")
DBSetProp(ThisView+".commpending","Field","UpdateName","mis!indentlots.commpending")
DBSetProp(ThisView+".commpending","Field","KeyField",.F.)
DBSetProp(ThisView+".commpending","Field","Updatable",.T.)

DBSetProp(ThisView+".suppcreditno","Field","DataType","C(20)")
DBSetProp(ThisView+".suppcreditno","Field","UpdateName","mis!indentlots.suppcreditno")
DBSetProp(ThisView+".suppcreditno","Field","KeyField",.F.)
DBSetProp(ThisView+".suppcreditno","Field","Updatable",.T.)

DBSetProp(ThisView+".ourdebitno","Field","DataType","C(20)")
DBSetProp(ThisView+".ourdebitno","Field","UpdateName","mis!indentlots.ourdebitno")
DBSetProp(ThisView+".ourdebitno","Field","KeyField",.F.)
DBSetProp(ThisView+".ourdebitno","Field","Updatable",.T.)

DBSetProp(ThisView+".commpercentage","Field","DataType","N(5,2)")
DBSetProp(ThisView+".commpercentage","Field","UpdateName","mis!indentlots.commpercentage")
DBSetProp(ThisView+".commpercentage","Field","KeyField",.F.)
DBSetProp(ThisView+".commpercentage","Field","Updatable",.T.)

DBSetProp(ThisView+".commduedate","Field","DataType","D")
DBSetProp(ThisView+".commduedate","Field","UpdateName","mis!indentlots.commduedate")
DBSetProp(ThisView+".commduedate","Field","KeyField",.F.)
DBSetProp(ThisView+".commduedate","Field","Updatable",.T.)

DBSetProp(ThisView+".commamt","Field","DataType","N(14,2)")
DBSetProp(ThisView+".commamt","Field","UpdateName","mis!indentlots.commamt")
DBSetProp(ThisView+".commamt","Field","KeyField",.F.)
DBSetProp(ThisView+".commamt","Field","Updatable",.T.)

DBSetProp(ThisView+".commrecdamt","Field","DataType","N(14,2)")
DBSetProp(ThisView+".commrecdamt","Field","UpdateName","mis!indentlots.commrecdamt")
DBSetProp(ThisView+".commrecdamt","Field","KeyField",.F.)
DBSetProp(ThisView+".commrecdamt","Field","Updatable",.T.)

DBSetProp(ThisView+".commwriteoff","Field","DataType","N(14,2)")
DBSetProp(ThisView+".commwriteoff","Field","UpdateName","mis!indentlots.commwriteoff")
DBSetProp(ThisView+".commwriteoff","Field","KeyField",.F.)
DBSetProp(ThisView+".commwriteoff","Field","Updatable",.T.)

DBSetProp(ThisView+".chequeno","Field","DataType","C(20)")
DBSetProp(ThisView+".chequeno","Field","UpdateName","mis!indentlots.chequeno")
DBSetProp(ThisView+".chequeno","Field","KeyField",.F.)
DBSetProp(ThisView+".chequeno","Field","Updatable",.T.)

DBSetProp(ThisView+".chequedate","Field","DataType","D")
DBSetProp(ThisView+".chequedate","Field","UpdateName","mis!indentlots.chequedate")
DBSetProp(ThisView+".chequedate","Field","KeyField",.F.)
DBSetProp(ThisView+".chequedate","Field","Updatable",.T.)

********************END****************************************

>What's VFP version/SP? Can you post view definition (SQL)?
>
>>Hi Friends,
>>
>>I am opening a Local SQL View like this
>>
>>Open database MIS Shared
>>Use IndentDet In 0 Alias RepTab1 --- Generates Error
>>
>>Error No 26
>>Table has no index order set.
>>
>>Any ideas why this error for ?
>>
>>Aashish

--
--
Aashish Sharma
Tele Nos: +1-201-490-5405
Mobile: +91-9821053938
E-Mail:
aashish@aashishsharma.com
write2aashish@gmail.com

You better believe in yourself... if you don't, who else will ?
TODAY is a gift, that's why it's called PRESENT

Map

View

Click here to load this message in the networking platform