FiveTech Software tech support forums

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

... results because nrec refers to previous recordset. ex2 nrec := recno() //actual recordset seek " 123" // index expression filed1 len(3) field2 len(5) 2 field in seek exp means new recordset with where clause. do while .... .... skip enddo resetseek() //returning to previous recordset ...

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

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

... Is Habour the same? Ive made relations in this way: If field related is only one :find in childs Otherwise Select in childs where field1 = and field2 = To avoid so many calls Im trying to save the last key and if the next its the same doesnt do anything. Can I use UR_RI_NEXT for this?

Cual es la diferencia entre.

"INSERT INTO clientes SET "
y
"INSERT INTO clientes ( field1. field2. field3) VALUES "

hablando concretamente de MySql y DOLPHIN


saludos..

hello try

cFor = 'test->field2 = "' alltrim( cSomeString ) + '"'

INDEX ON Test->Field1 TO C:\Test FOR &( cFor )


saludos

... especially if you want to open multiple copies of a database (and there are very good reasons to do so). Try: INDEX ON Field1 TO C:\Test FOR Field2 = &(cSomeString) James

Guys:

How can I print 2 fields on a oReport:Say( 4, field on line 1 + field on next line, , 1 ) ? With commands it goes like this:
COLUMN TITLE "Header 1", "Header 2" DATA Field1, Field2


Thank you very much.

... el proceso de carga aplicando el metodh Save(). Existe alguna fórmula para presentar la progress bar en un Query como INSERT INTO TABLE (field1, field2) VALUES (value1, value2)? Agradeceré mucho las respuestas.

... session not successfully initialized, aborting...") oOdbc:End() return nil Endif oDbf := oOdbc:Query( "SELECT T0.field1 'CODICE', T0.field2 'DESCRI' FROM CLIENTI T0") if oOdbc:IsError() oOdbc:ShowErrorList() oOdbc:aErrors := {} l1 := .f. endif oDbf:Open() <--------- Line 93 ...

... have also a find thad the user can find a record in a list with criteria on more than one field. With DBF I could do a locate for FIELD1 =.. .and. FIELD2=... How can I do this with ADO on a recordset. According to the info of the FIND-methode I can only specify 1 field. Required. The column name, ...

... en tu sistema enviar no mas de 1000 registros a la vez (dependiendo de la tabla) visto desde mysql seria algo asi insert into table (field1, field2, field3) values (value1, value2, value3), (value1, value2, value3), (value1, value2, value3) si te fijas en un solo insert se incluyen 3 registros ...

... string and use INSERT statements with multiple VALUES lists to insert several rows at a time. sql = "INSERT INTO your_table (field1, field2) VALUES ('string1', value1),('string2', value2),('string3', value3);" You can also use a free tool like dbf2sql: http://www.tkinformidia.net/uploads/1/2/0/0/12005968/dbf2sql-3.0.zip