Pesquisar

Página 7 de 31. A exibir 307 resultados (0.253 segundos)

1. FieldPos

   () CreateTable() DBUseArea(.F., 'TOPCONN', cT1, (cT1), .F., .F.) if (cT1)->(FieldPos("FIELD_NAME") > 0 conout("Campo existe!") endif DBCloseArea() TCUnlink() RETURN Veja também TCLink TCUnlink DBUseArea DBCloseArea DBCreate
   TOTVSTEC • 18 jan, 2017

2. OrdName

   () Local cT1 := "T1" TCLink() DBCreate("T1", {{"FIELD_NAME", "C", 10, 0}, ; {"FIELD_TYPE", "C", 10, 0} }, "TOPCONN") DBUseArea(.F … T1INDEX1 no console DBCloseArea() TCUnlink() RETURN Veja também TCLink TCUnlink DBUseArea DBSetIndex DBCreateIndex DBCreate
   TOTVSTEC • 05 dez, 2017

3. OrdNumber

   } }, "TOPCONN") DBUseArea(.F., 'TOPCONN', cT1, (cT1), .F., .T.) DBCreateIndex("T1INDEX1", "FIELD_NAME", {|| FIELD_NAME }) DBCreateIndex("T1INDEX2 … console conout(OrdNumber("T1INDEX2")) // retorna 2 no console DBCloseArea() TCUnlink() RETURN Veja também TCLink TCUnlink DBUseArea DBSetIndex
   TOTVSTEC • 05 dez, 2017

4. DBCloseArea

   }, ; {"FIELD_NICK", "C", 10, 0}, ; {"FIELD_COL", "C", 10, 0}}, "TOPCONN") DBUseArea(.F., 'TOPCONN', cT1, (cT1), .F., .T.) // TODO DBCloseArea() TCUnlink() RETURN Veja também TCLink TCUnlink DBUseArea DBCreate favourite
   TOTVSTEC • 29 dez, 2016

5. DBCommit

   ", {{"FIELD_NAME", "C", 10, 0},; {"FIELD_TYPE", "C", 10, 0}}, "TOPCONN") DBUseArea(.F., 'TOPCONN', cT1, (cT1), .F., .T … () ) DBCloseArea() TCUnlink() RETURN Veja também TCLink TCUnlink DBUseArea DBCloseArea DBAppend favourite
   TOTVSTEC • 21 jun, 2017

6. Used

   }}, "TOPCONN") DBUseArea(.F., 'TOPCONN', cT1, (cT1), .F., .T.) lRet := Used() if lRet == .T. conout("Existe arquivo sendo usado!") endif DBCloseArea() TCUnlink() RETURN Veja também TCLink TCUnlink DBUseArea DBCreate DBCloseArea favourite
   TOTVSTEC • 29 dez, 2016

7. FCount

   ") DBUseArea(.F., 'TOPCONN', cT1, (cT1), .F., .T.) nRet := (cT1)->(FCount()) if nRet == 5 conout("Existe 5 Colunas") endif DBCloseArea() TCUnlink() RETURN Veja também TCLink TCUnlink DBUseArea DBCreate DBCloseArea favourite
   TOTVSTEC • 29 dez, 2016

8. DBNickIndexKey

   ") DBUseArea(.F., 'TOPCONN', cT1, (cT1), .F., .T.) (cT1)->(DBCreateIndex('T1_IND', 'FIELD_NAME', { || 'FIELD_NAME' })) (cT1 … DBUseArea DBCloseArea DBCreate DBCreateIndex
   TOTVSTEC • 16 nov, 2017

9. DBAppend

   () CreateTable() DBUseArea(.F., 'TOPCONN', cT1, (cT1), .F., .F.) (cT1)->( DBAppend( .F. ) ) (cT1)->FIELD_NAME := "name" (cT1)->FIELD_TYPE := "string" (cT1)->( DBCommit() ) DBCloseArea() TCUnlink() RETURN Veja também TCLink TCUnlink DBUseArea DBCloseArea DBCreate TCDelFile favourite
   TOTVSTEC • 23 dez, 2016

10. DBClearIndex

    }, ; {"FIELD_TYPE" , "C", 10, 0}}, 'TOPCONN') DBUseArea(.F., 'TOPCONN', cT1, (cT1), .F., .F.) (cT1)->(DBCreateIndex('T1_IND', 'FIELD_NAME … também TCLink TCUnlink DBUseArea DBCloseArea DBCreate DBCreateIndex DBSetIndex favourite
    TOTVSTEC • 01 dez, 2017