FiveTech Software tech support forums

... XBrowse builds the picture from that column's cDataType, nDataLen and nDataDec. In turn, XBrowse takes this informatin from ::oOrders:aStruct. It appears that XBrowse is reading the structure of the field 'wrkdat' from ::oorders as { "WRKDAT", "N", 6, 0 }. Surprising. ...

... FWAdoStruct(objRS) work only on "active" Record :?: Please post a DBF Structure here so that we both work on the same structure Local aStruct := {                        ;   { "TEST_C"      ,"C" ,        10,         0 } ,;   { "TEST_N" ...

...  End try --- than i open a existing *.XLSx and look at Structure   objRS := FW_OpenADOExcelSheet( cPathcFile, cSheet, cRange, lHeaders )   aStruct := FWAdoStruct( objRS )fwlog var2char(aStruct) and got var2char(aStruct) = "{{ARTNR, C, 255, 0, 202, .T.}, {ARTIKEL, C, ...

hi, i have used from c:\fwh\source\function\pgsuport.prg function GetSerialCol( oQry, aStruct ) to get PRIMARY KEY and change to   cSeq := GetSerialCol( oQry, ::aStructPG )   n := ASCAN(::aStructPG,{|x| x[1] = cSeq } )   IF n > ...

... i found in c:\fwh\source\function\pgsuport.prg function FWPG_PrimaryKeys( oQry, cTable ) or #ifdef UNUSEDFUNCS static function GetSerialCol( oQry, aStruct ) it would be nice if METHOD SavePQQ() use these Function for WHERE

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 ] )

METHOD FieldType( n, c ) INLINE If( c == nil, ::aStruct[ n ][ 2 ], ::aStruct[ n ][ 2 ] := c )

... return array For now, glad this works. This is a multi-dim array of the same data. Check xbrowse oProd and make sure. Immediately after that, run aStruct := oCn:Execute()   again without any parameters. Very likely you will get aStructure as an array Check "xbrowser aStruct" ...

... "+" as field type. Before or without actually creating table, you can check the table creation sql by ? oCn:CreateTableSQL( cTableName, aStruct ) Example:   aStru :=  { ;               { "codgru",    "+",  3, 0 }, ; // '+' : AutoInc Primary Key      ...

... in order to match these of the dbf. The dbf fields are defined, but the exels that I get are always differend than the dbf. The sollution maybe : aStruct := {} DBF EXEL COLUMN AADD(aStruct, { "Code" , "art_nummer"}) // link to Code AADD(aStruct, { "Code" , "art_code"}) ...

... )  Instead of writing SQL statements for creation of tables on our own, we recommend using FWH function FWAdoCreateTable( cTable, aStruct, oCn, [lAddAutoInc := .t.] )  aStruct is a normal DBF style structure array we are all very familiar with. Data type "M" ...

... se abre en modo exclusivo. Es necesario cerrar el objeto de conexión poco después de su uso. * FWMariaConnection: Los métodos CreateTable( cTable, aStruct, ... ) y CreateTableSQL( cTable, aStruct, ... ) están modificando la matriz aStruct. Sin embargo, los métodos se ejecutan correctamente, el ...

... is opened in exclusive mode. It is necessary to close the connection object soon after use. * FWMariaConnection: The methods CreateTable( cTable, aStruct, ... ) and CreateTableSQL( cTable, aStruct,... ) are modifying the array aStruct. Though, the methods execute correctly, using the modified ...

... 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 tag corresponding ...