Search found 76 matches: field1

Return to advanced search

Re: Question about performance RowSet

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 ...
by nageswaragunupudi
Wed Mar 20, 2024 3:19 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 463

Re: Question about performance RowSet

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' " ...
by Eroni
Fri Mar 15, 2024 1:50 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 463

Re: Question about performance RowSet

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' " ...
by carlos vargas
Fri Mar 15, 2024 3:02 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Question about performance RowSet
Replies: 19
Views: 463

Re: MySql MariaDatase INDEX

Hi all
Thank Vilian
is also possible : oCN:Execute("ALTER TABLE your_table ADD INDEX your_index(`field1`, `My_function()`)")
by mauri.menabue
Wed Apr 19, 2023 9:49 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: MySql MariaDatase INDEX
Replies: 3
Views: 291

Re: MySql MariaDatase INDEX

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`)")
by vilian
Wed Apr 19, 2023 8:01 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: MySql MariaDatase INDEX
Replies: 3
Views: 291

SQL 2 Table Question

... 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 ...
by Jimmy
Sat Jan 22, 2022 4:24 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: SQL 2 Table Question
Replies: 2
Views: 288

Re: System info, Tips & Tricks, scharing project info

... 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 ...
by Marc Venken
Sun Jan 16, 2022 11:17 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: System info, Tips & Tricks, scharing project info
Replies: 20
Views: 1431

Re: System info, Tips & Tricks, scharing project info

... 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 ...
by James Bott
Sun Jan 16, 2022 1:48 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: System info, Tips & Tricks, scharing project info
Replies: 20
Views: 1431

Re: help for converting file

... 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 ...
by Otto
Tue Dec 15, 2020 7:23 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: help for converting file
Replies: 5
Views: 885

Re: Editar RowSet con dos tablas - At. Mr. Rao

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 ...
by Horizon
Wed May 27, 2020 12:00 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Editar RowSet con dos tablas - At. Mr. Rao
Replies: 15
Views: 2857

Re: Editar RowSet con dos tablas - At. Mr. Rao

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 ...
by Horizon
Wed May 27, 2020 11:59 am
 
Forum: FiveWin para Harbour/xHarbour
Topic: Editar RowSet con dos tablas - At. Mr. Rao
Replies: 15
Views: 2857

Re: "PROBLEMILLA" CON TCBROWSE FWH

@ 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 ...
by pacotre
Sat May 23, 2020 5:14 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: "PROBLEMILLA" CON TCBROWSE FWH
Replies: 20
Views: 2140

Re: "PROBLEMILLA" CON TCBROWSE FWH

@ r, c XBROWSE oBrw SIZE ....................
DATASOURCE cAlias ;
COLUMNS "FIELD3", "LEFT(FIELD1,10)", "RIGHT(FIELD1,10)", "FIELD4", ....;
HEADERS ...........
by nageswaragunupudi
Fri May 22, 2020 10:52 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: "PROBLEMILLA" CON TCBROWSE FWH
Replies: 20
Views: 2140

Re: "PROBLEMILLA" CON TCBROWSE FWH

... 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 ...
by pacotre
Fri May 22, 2020 10:45 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: "PROBLEMILLA" CON TCBROWSE FWH
Replies: 20
Views: 2140

Re: Editar RowSet con dos tablas - At. Mr. Rao

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 ...
by nageswaragunupudi
Thu Jul 11, 2019 1:06 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: Editar RowSet con dos tablas - At. Mr. Rao
Replies: 15
Views: 2857
Next

Return to advanced search