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 ...
... 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 ...
... 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 ...
... 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 ...
... 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 ...
... 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 ...
... 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 ...
... 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 ...
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 ...
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} ...
... 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() ...
... 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 ...