Search found 48 matches: field2

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

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

... 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 which ...
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

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

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

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

Re: "PROBLEMILLA" CON TCBROWSE FWH

... 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 con xBrowse. Como puedo condicionar los datos a mostrar en el Browse?. Teneis que disculparme, pero me he pasado ...
by pacotre
Fri May 22, 2020 10:45 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: "PROBLEMILLA" CON TCBROWSE FWH
Replies: 20
Views: 2140

Recordset filter question

... on a recordset. I already found on the SQL-sites that there ale problems with AND and OR combination In my case I have a table like Field1 = Char Field2 = Num Field3 = Num Field4 = Num Field5 = Num I want a filter like oRs.Filter:=Field1 = 'CL' AND ((Field2 = 2 AND Field3 = 3) OR (Field4 = 2 AND ...
by Marc Vanzegbroeck
Fri Aug 10, 2018 10:12 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: Recordset filter question
Replies: 2
Views: 583

Re: ADO : Building columns , NULL ... DEFAULT

... default values are (1) do not specify a value for the field or (2) specify DEFAULT as value for the field. Eg: INSERT INTO TestTable ( [field1], [field2] ) VALUES ( somevalue, DEFAULT ) or INSERT INTO TestTable( [field1] ) VALUES ( somevalue ) // We do not list ID and field2 here Now how to do ...
by nageswaragunupudi
Thu Sep 22, 2016 4:32 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO : Building columns , NULL ... DEFAULT
Replies: 7
Views: 1456

Re: ADO : Building columns , NULL ... DEFAULT

Rick

He is writing a generic DBU.
How does he know what value to be assigned?
oRs:Fields("Field2"):Value := "Fivewin power"

How does he know that the default value is "Fivewin power" ?
That is the question he is asking.
by nageswaragunupudi
Thu Sep 22, 2016 2:42 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO : Building columns , NULL ... DEFAULT
Replies: 7
Views: 1456

Re: ADO : Building columns , NULL ... DEFAULT

Rao , I am not sure that you answered the question . Building the table with CREATE TABLE TestTable ( ID COUNTER PRIMARY KEY , [FIELD2] CHAR(20) NOT NULL DEFAULT 'Fivewin power' , ... ) .... oRs:AddNew() FIELD2 must become the value "Fivewin power" . Will Ors:Fields("FIELD2"):Value ...
by Franklin Demont
Thu Sep 22, 2016 12:40 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO : Building columns , NULL ... DEFAULT
Replies: 7
Views: 1456

ADO : Building columns , NULL ... DEFAULT

Hello , Working with ADO i am trying to understand field definitions as : CREATE TABLE TestTable ( ID COUNTER PRIMARY KEY , [FIELD2] CHAR(20) NOT NULL DEFAULT 'Fivewin power' , [FIELD3] NUMERIC(10,0) DEFAULT 0 )    oRS:AddNew()   a := {1,nil,0}  ...
by Franklin Demont
Wed Sep 21, 2016 8:31 am
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO : Building columns , NULL ... DEFAULT
Replies: 7
Views: 1456

Re: xbrowse refresh with new recordset

... the same oLbx2 xBrowse .. here is the pseudo code : Create recordset oRs1 for the first xBrowse oLbx1 Create recordset oRs2... "Select Field1,Field2,Field3 where <some condition>" that ties back to the first recordset and xBrowse oLbx2 xbrowse 1 .. creates a new record oRs2:CLose() ...
by Rick Lipkin
Fri Jul 01, 2016 12:56 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: xbrowse refresh with new recordset
Replies: 7
Views: 1504

Re: ADS Índice Composto

... tables creating a multi-segmented index is done with the plus ( + ) operator. A multi-segmented index expression would look like this: Field1 + Field2 + Field3. If this type of index expression is used in an ADT table there are potential performance issues, as well as a possibility for unexpected ...
by MGA
Tue Jun 07, 2016 7:32 pm
 
Forum: FiveWin para Harbour/xHarbour
Topic: ADS Índice Composto ( SOLUCIONADO )
Replies: 3
Views: 607

Re: ADO Sort error

oRs:Sort := "field1,field2" is perfectly valid.
But oRs:Sort works only on client side recordsets
by nageswaragunupudi
Sat May 30, 2015 4:59 pm
 
Forum: FiveWin for Harbour/xHarbour
Topic: ADO Sort error
Replies: 3
Views: 572
Next

Return to advanced search