FiveTech Software tech support forums

... error on Local aAttivita := { TImage():Define( 'CHECK2' ), TImage():Define( 'CHECK3' ) } .... COLUMN TITLE "Predefinita" DATA IIF(cu->field1,"si","no") SIZE 30 IMAGE IMGDATA aAttivita[IIF(cu->field1,1,2) ] HEIGHT 1.2 ALPHALEVEL 128

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

... := "SELECT COUNT(*) AS NumRecs FROM customer WHERE state = 'NY'" oQry := oServer:Query( cSql ) Sql for summing fields: SELECT SUM( <field1> ) [AS <sum1>],.. FROM <table> [WHERE <condition>] Example: cSql := "SELECT SUM(salary) AS TotSalary FROM customer ...

hi thank you for your help
If I use codeblock, performance is very very slow.

I do not understand because If I use function 'dAAAAMMGGadata(DATA)' that works and with 'MRP00421(oYORD:Fields("FIELD1"):value,oCn)' not works

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

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

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

... names are with path on without this set the app wouldn't run. 3) SET ADO TABLES LOGICAL FIELDS LIST TO This array set is { { Tablename1, {Boolean field1, booleanfield2,...} },; { tablename2, .....} } To identify Boolean fields for engines that don't have Boolean type such as Oracle, Firebird, ...

Antonio F, Ok, thanks that is all very useful info. SELECT field ORDER BY field+IF( field1= ..., true, false) So could I then convert this UDF: FUNCTION icon3(icondate)   //icondate is idate+date   IF VAL(SUBSTR(icondate,1,2))< 80      RETURN ...

James, You can use If( in SELECT and in ORDER BY. SELECT field+IF( field1= ..., true expr, false expr) AS myfield FROM myTable ORDER BY myfield or SELECT field ORDER BY field+IF( field1= ..., true, false) You can also use CASE instead of IF. You can use also ...

oRs:Sort := "field1,field2" is perfectly valid.
But oRs:Sort works only on client side recordsets

I using ors:sort := "field1,field2" but I get a error.

DB Mysql CursorLocation = adUseClient.

Does anyone knows what might be the cause and how to solve it?

In that case please use bFilterExp instead of cFilterFld.

Eg:
oBrw:bFilterExp := { |cExp| Upper( cExp ) $ FIELD1 + FIELD2 }

With bFilterExp we can have any complex filter conditions:

Eg:
oBrw:bFilterExp := { |cExp| Upper( cExp ) $ FIELD1 .AND. .NOT. ( Upper( cExp ) $ FIELD2 ) }

... reason is that in order to enable seek expression like we do normally I had to add one more field to the selects that is INDEXKEY. ex: INDEX ON field1+field2+field3 TO xfile SET INDEX TO xfile when select SELECT *.xfile, (field1+field2+field3) AS INDEXKEY ORDER BY field1,field2,field3 if the ...

... in adorddd being tested. 2) ADO Find based on the initial select with a new column = to the fields used in the index expr. ex : index expr - field1+field2+field3 Initial select is then: SELECT ctable.*, (field1+field2+field3) AS INDEKEY FROM ctable ORDER BY field1+field2+field3 This allow ...