FiveTech Software tech support forums

To All I see Silvo ( seems ) to have a similar problem ... What is the tDatabase equivalence of : oDbf:SetOrder( "CustID" ) // understand this already Set order to tag CustID Seek cCustID // <----- here oDbf:Seek cCustID ?? oDBf:GoTop() oDBf:Find cCustID ?? I would rather ...

... into it. // Also do all your indexes "for ! deleted()" // And you MUST USE the TAG clause! use customer index on chgno tag "custid" to customer for ! deleted() index on descrip tag "company" to customer for ! deleted() index on phone tag "phone" to ...

... "+", then the corresponding value is added to the existing value in case of updation. Example: oCn:Insert( "debtors", "custid,lastdate,due+", ; { CustID, dSaleDate, nSaleAmount }, .T. ) If the CustID does not already exist in the table, the entire row is inserted. ...

... q, r, s, ş, t, u, ü, v, w, x, y, z  There is no any problem on the server side. Because the Sql statement below returns the correct order. SELECT CUSTID,FIRST FROM test_trk ORDER BY FIRST

... ) Note: aStruct should consist of all other fields other than the autoinc field. In the above case, aStruct may contain all fields other than custid and oCn:CreateTable( cTableName, aStruct, "custid" ) Table will be created with custid as the first field as autoincrement primary ...

Mr.Rao c) To spcify primary key add one more element to the array with "PRI". Eg: { "custid", 'C', 5, 0, "PRI" } what are these elements ? " PRI " creates field primary key and how I create this same field as Auto Increment ? Thanks ...

... as amount DECIMAL( 12, 2 ) AS ( qty * price ), c) To spcify primary key add one more element to the array with "PRI". Eg: { "custid", 'C', 5, 0, "PRI" } d) Specify character set in extended element like { "custname", 'C', 30, 0, "utf8" } ...

... ntx's to the CreateDictionary()? because the names of my dbf's aren't related to the ntx's. Example... Customer.dbf Custname.ntx Custnbr.ntx Custid.ntx Payments.dbf Pmttype.ntx Pmtdate.ntx Notice on my sample code posted here how the table and indexes get added to the data dictionary using ...

... ntx's to the CreateDictionary()? because the names of my dbf's aren't related to the ntx's. Example... Customer.dbf Custname.ntx Custnbr.ntx Custid.ntx Payments.dbf Pmttype.ntx Pmtdate.ntx 2) How do I link in the ADS.ch? I have never "included" anything in Harbour yet. The following ...

... are. James 1: => CUSTOMERS NomeRDD: ADORDD ============================== RecNo RecCount BOF EOF 1 45 .F. .F. Índices em uso TagName CUSTOMERID CUSTID => COUNTRY DESC COUNTRY Relations Records locked

... fields with their alias, you end up with "ID" referring to different files depending on the current workarea. It would be better to use CUSTID, PARTID, INVOICEID, etc. However changing a fieldname in a legacy program is going to very difficult and tedious to debug. If you are using database ...

... CUSTID],[CUSTNAME],[CUSTREP],[COONAME],[COOCOUNTRY],[COOBODY],[DOCKBODY],[REP],[ACTUAL],[INVOICED],[INVOICE],[INVDATE],[INVUSER],[TRADELANE],[CUSTOM01],[CUSTOM02],[CUSTOM03],[CUSTOM04],[CUSTOM05],[BLDIVER],[FWBDATE],[FWBTIME],[FWBUSER],[FWBNO],[FHLDATE],[FHLTIME],[FHLUSER],[FHLNO],[ESTREVENUE],[UNKNOWN],[ITEM1],[ITEM2],[ITEM3] ...

... CUSTID],[CUSTNAME],[CUSTREP],[COONAME],[COOCOUNTRY],[COOBODY],[DOCKBODY],[REP],[ACTUAL],[INVOICED],[INVOICE],[INVDATE],[INVUSER],[TRADELANE],[CUSTOM01],[CUSTOM02],[CUSTOM03],[CUSTOM04],[CUSTOM05],[BLDIVER],[FWBDATE],[FWBTIME],[FWBUSER],[FWBNO],[FHLDATE],[FHLTIME],[FHLUSER],[FHLNO],[ESTREVENUE],[UNKNOWN],[ITEM1],[ITEM2],[ITEM3] ...

... ), `SITALDATE` DATE, `SITALTIME` VARCHAR ( 4 ), `CLOSED` BIT DEFAULT 0, `CLOSEDATE` DATE, `CLOSETIME` VARCHAR ( 5 ), `CLOSEUSER` VARCHAR ( 15 ), `CUSTID` VARCHAR ( 10 ), `CUSTNAME` VARCHAR ( 45 ), `CUSTREP` VARCHAR ( 10 ), `COONAME` VARCHAR ( 75 ), `COOCOUNTRY` VARCHAR ( 75 ), `COOBODY` TEXT, ...

... nLen := LEN(aCols) for nFor := 1 to nLen aCols[ nFor ]:nHeadBmpNo := 0 aCols[ nFor ]:cOrder := "" next do case case nAt==1 id1:=::odb1:custid ::odb1:cQuery:="select * from custm1 order by custid"+if(corder=="A"," desc","") ::odb1:refresh() ::obrow:refresh() ...