FiveTech Software tech support forums

I am try this: Code: aRow := oCn:QueryResult( "select field1,field2 from states where code='WA'" ) if aRow == NIL // not found, then inserts aRow := { "aa","bb" } oCn:Upsert( "states", nil, { aRow } ) endif But ...

podria ser que: oCn:QueryResult( "select field1, field2 to my table where field3 = 'x' " ) // 0.21 seconds retorna un arreglo simple de datos y que oCn:Rowset( "select field1, field2 to my table where field3 = 'x' " ...

podria ser que: oCn:QueryResult( "select field1, field2 to my table where field3 = 'x' " ) // 0.21 seconds retorna un arreglo simple de datos y que oCn:Rowset( "select field1, field2 to my table where field3 = 'x' " ...

Hi all
Thank Vilian
is also possible : oCN:Execute("ALTER TABLE your_table ADD INDEX your_index(`field1`, `My_function()`)")

TO REMOVE
oCN:Execute("ALTER TABLE your_table DROP INDEX your_index")

TO CREATE
oCN:Execute("ALTER TABLE your_table ADD INDEX your_index(`field1`, `field2`)")

... both Table to "sync" :idea: --- as i know "older" SQL Version can create a "real" SLQ Index only from 1 x FIELD so FIELD1 + FIELD2 will not work like in xBase as IndexKey the Idea is to create a second Table sqlindex when create a Table sqlindex i can create a FIELD ...

... so he is doing a filter. Using a filter requires that you read the entire database across the network. Ideally, I would use a complex index, i.e. FIELD1+FIELD2+FIELD3. Then using this index you only need a SEEK then read (and write) the number of records that match. Thus, you only send those records ...

... so he is doing a filter. Using a filter requires that you read the entire database across the network. Ideally, I would use a complex index, i.e. FIELD1+FIELD2+FIELD3. Then using this index you only need a SEEK then read (and write) the number of records that match. Thus, you only send those records ...

... it, because you have been at the sessions. You must correct the header to: "UserName","WorkDate","TimeWorked", "Field1", "Field2","Field3","Field4" Sincerely Otto http://forums.fivetechsupport.com/viewtopic.php?f=3&t=33515 ...

Writing data: 1) In case you already opened the table into a RowSet, you can write your modifications in two ways: a) oRs:field1 := <value> oRs:fieldN := <value> ... oRs:Save() OR b) oRs:Update( cFieldList, aNewVAlues ) 2) Directly writing to table without opening as RowSet ...

Writing data: 1) In case you already opened the table into a RowSet, you can write your modifications in two ways: a) oRs:field1 := <value> oRs:fieldN := <value> ... oRs:Save() OR b) oRs:Update( cFieldList, aNewVAlues ) 2) Directly writing to table without opening as RowSet ...

@ r, c XBROWSE oBrw SIZE .................... DATASOURCE cAlias ; COLUMNS "FIELD3", "LEFT(FIELD1,10)", "RIGHT(FIELD1,10)", "FIELD4", ....; HEADERS ........... No podía imaginar que era tan fácil. Y supongo que otra duda que tengo también ...

@ r, c XBROWSE oBrw SIZE ....................
DATASOURCE cAlias ;
COLUMNS "FIELD3", "LEFT(FIELD1,10)", "RIGHT(FIELD1,10)", "FIELD4", ....;
HEADERS ...........

... de columnas con Header. Necesito indicarle, como lo hacía con Listbox, que un determinado campo me lo muestre en dos columnas distintas: LEFT(Field1,10) y RIGHT(Field1,10) como si fueran dos campos,y en otros que solo muestre los primeros 25 caracteres, LEFT(Field2,25), etc. Esto no sé hacerlo ...

Writing data: 1) In case you already opened the table into a RowSet, you can write your modifications in two ways: a) oRs:field1 := <value> oRs:fieldN := <value> ... oRs:Save() OR b) oRs:Update( cFieldList, aNewVAlues ) 2) Directly writing to table without opening as RowSet ...