FiveTech Software tech support forums

Hello friends, I am currently working on a DBF editor that can be used for both Fivewin and mod harbour. A dbStruct() reads the database structure and then a dialog is automatically generated. On the right, there is an area where you can drag and drop the input fields and sort ...

... got "wrong Structure" https://i.postimg.cc/C5k5xXC8/fail-open-empty.jpg --- so i try to create Structure of Table, using DbStruct(), but go next Error about Structure of Excel Table   cQuery := "CREATE TABLE " + cTable + " ( "   iMax := LEN( aDbfStruct ...

... primary field. Programmer can choose different field names. FWH functions allow specifying the structure of a table using a structure like DBSTRUCT(). FWH creates the required SQL for creating the table using the structure internally and creates the table. Using FWH functions for creating ...

Me respondo, una forma que encontre es:

use customer
aCols := dbstruct()

? LEN( aCols ) // # de columnas del DBF

Si algo mejor, me cuentan por favor.

hi,

nageswaragunupudi wrote:Comma delimited
Eg: "FIRST,CITY,SALARY,..."

thx for Answer

nageswaragunupudi wrote:We can easily convert an array like DbStruct() to list like this:
FW_ArrayAsList( ArrTranspose( aStruct )[ 1 ] )

ah, that is nice

how does"cFieldList" look like and what Delimiter is used

Comma delimited
Eg: "FIRST,CITY,SALARY,..."

We can easily convert an array like DbStruct() to list like this:
FW_ArrayAsList( ArrTranspose( aStruct )[ 1 ] )

hi,

nageswaragunupudi wrote:

Code: Select all  Expand view

METHOD EditSource( lNew, cFieldList, lNavigate, aInitVals )

ah, ok thx for Answer

how does"cFieldList" look like and what Delimiter is used

would be nice if it also accept a Array with (reduce) Structure of DbStruct()

Interesting use of DBSTRUCT()   USE CUSTOMER   aCols := ArrTranspose( DBSTRUCT() )[ 1 ]   aCols := AShuffle( aCols, 2, 9 )   DEFINE WINDOW oWnd   @ 0,0 XBROWSE ...

... and specify the column names. Use the clause AUTOCOLS instead of COLUMNS .... clause. When we use AUTOCOLS clause, XBrowse itself reads the DBSTRUCT() and builds all the columns suitably, including the sort orders. Example: [code]@ r,c XBROWSE oBrw SIZE w,h PIXEL OF oDlg ;DATASOURCE ...

hi, i want to "pick" Name of FIELD from DBSTRUCT() an use it with XBROWSE now i have Names of FIELD in Array but how to pass it to XBROWSE :?: 90, 10 XBROWSE oBrw1 FIELDS One->First, One->Last ; this Style need to "know" ...

hi,

i have a XBROWSE using DbStruct() Array
i use oBrw:nEditTypes := EDIT_GET

but i only want to "edit" LEN and DEC of Structure
so how can i "block" Column 1 and 2 in XBROWSE

... ) I can do this... looking for more samples at the moment..... I found small samples like this, but they look more complex... We will see AEval( DbStruct(), { |a| cFieldList += "," + if(a[2]= "C","Alltrim("+a[ 1 ]+")",a[ 1 ]) } )

... 2015-02-08 13:19 UTC+0100 Przemyslaw Czerpak (druzus/at/poczta.onet.pl) // * src/rdd/workarea.c // + added support for field flags in dbCreate()/dbStruct(). // Flags can be passed in string with field type after ":", i.e. // "C:U" // means Unicode character field. // The following ...

... caFields, aValues, [nLockWaitSecs], [lAppend] ) --> nRecNo ( 0 if failure) ... 2)FW_CdxCreate( [caTagList] ) 3)FW_DBFSTRUCT( cDbfFile ) --> dbstruct() // without USEing the DBF FWH1709: * function FW_CdxCreate( [caTagList], [lMemory] ). Added new optional parameter lMemory to create indexes ...

Hola. usando harbour y Fwh la ultima. Me arroja estos errores: [1]:iLink32.Exe -Gn -q -aa -Tpe -x @testMaria.bcl Error: Unresolved external 'WinMain' referenced from X:\HARB\BCC7\LIB\C0W32.OBJ Error: Unresolved external '_hb_vmProcessSymbols' referenced from X:\PROYECTOS\TEST\MARIA\OBJ\MARIA.OBJ Err...