FiveTech Software tech support forums

... corresponds to a numeric field with fieldlength 8 and fielddec 2. But this field is a character field. When TDatabase class opens a DBF, it copies DBSTRUCT() to oDbf:aStruct, extends the array and after examining each field stores (a) picture clause for numeric fields (only) in column 7, (b) index ...

... con oDbf := TDatabase():Open( , cPath+'CODGRUP' ,'DBFCDX' , .T. ) me da un error y el programa se cuelga !!! Necesito el oDbf para poder usar oDbf:Dbstruct() en un xbrowse. si le cambio el nombre a la DBF ej: CODIGOS.DBF lo anterior anda perfectamente ????? No se me ocurre que pueda estar pasando ...

... the exact date and time when the record was first created. Later on, this value is not changed and you shoud also not change it. When reading the DBSTRUCT(), Harbour displays this as "@" instead of 'T', but the functionality is the same. Nothing to worry about it.

Hello , I made some test with autoincrement field : DBCREATE(cDbfFile , {{"ID","+",10,0}} , "DBFCDX" , .T. ) DBG DbStruct() // gives ID , + , 4 , 0 ? FieldLen("ID") // 4 WHY TRUNCATED TO 4 ????????????????????????? FOR i := 1 TO 10001 DBAPPEND() NEXT ? ...

Hello , I made some test with autoincrement field : DBCREATE(cDbfFile , {{"ID","+",10,0}} , "DBFCDX" , .T. ) DBG DbStruct() // gives ID , + , 4 , 0 ? FieldLen("ID") // 4 WHY TRUNCATED TO 4 ????????????????????????? FOR i := 1 TO 10001 DBAPPEND() NEXT ? ...

... can use the function: FWAdoCreateTable( cTable, aCols, oConnectionObject, [lAddAutoInc] ) --> lSuccess where aCols is a structure exactly like DBSTRUCT() of DBF tables. This function detects the database from the "oConnectionObject" and chooses appropriate field types and specs and ...

... DBSort(<cDatabase>,<aFields>,[<bFor>],[<bWhile>],[<nNext>],[<nRecord>],[<lRest>])->lSuccess DBStruct()->aStruct DBTableExt()->cFileExtension DBTotal(<cDatabase>,<bExpression>,[<aFields>],[<bFor>],[<bWhile>],[<nNext>],[<nRecord>],[<lRest>])->lSuccess ...

... DBRLock DBRLockList DBRSelect DBRUnlock DBSeek DBSelectArea DBSetDriver DBSetFilter DBSetIndex DBSetOrder DBSetRelation DBSkip DBSkipper DBSort DBStruct DBTableExt DBTotal DBUnlock DBUnlockAll DBUpdate DBUseArea DBZap Default DefPath Deleted DeleteFile Descend DevOut DevOutPict DevPos DirChange ...

... Type: "A" ): Array containing field names of DBF 3. aStruct ( ReadOnly Type: "A" ): Structure of the table, similar to DBSTRUCT(). aStruct has additional columns 7 for picture and 8 for index tag. When programmer assigns an alternate name for a field using ::MapCol(), ...

... error with the following lines of code in MNUSELECT.PRG MENUITEM Upper( "FieldNames_" ) + Alias( 1 ) MENU SELECT ( Alias( 1 ) )->( DbStruct() ) LIMIT -1 COLUMNS 2, 1, 3 //, 4 ENDMENU MENUITEM Upper( "FieldNames_" ) + Alias( 1 ) + "_EXPAND" MENU SELECT ( Alias( ...

... entre código ya existente para aprovechar una tabla de las gordas y con muchos registros.            dbCreate( 'Prueba', Creditos->( dbStruct() ) )      USE Prueba NEW      /* __dbTrans( nDstArea, aFieldsStru, bFor, bWhile, nNext, nRecord, lRest ) -> <lSuccess> ...

1) After opening a table as rowset, we can use oRs:aStructure, which is like DBSTRUCT() for a DBF oRs := oCn:tablenameXBROWSER oRs:aStructure  2) Without opening a table we can use oCn:ListColumns( cTable, [lShow] ) //--> array of columns with ...

1) After opening a table as rowset, we can use oRs:aStructure, which is like DBSTRUCT() for a DBF oRs := oCn:tablenameXBROWSER oRs:aStructure  2) Without opening a table we can use oCn:ListColumns( cTable, [lShow] ) //--> array of columns with ...

... ). Also FWH function works on those RDBMs which do not fully support ADOX. FWAdoCreateTable( cTable, aStruct, oCn ) // aStruct is identical to DBSTRUCT() Usage: FWAdoCreateTable( "sales", { { BILLNO, 'N', 5, 0 }, ;              ...

... it is due that the user uses a data dictionary to order the columns of the table as it requires, so we can not show the table in the order of the DBSTRUCT() fields . Each user of the system orders the information in the way that it requires and also adds a color to the column ... We can not change ...