FiveTech Software tech support forums

... to know if expression has more than one field mentioned on it. As I investigate and test :find only allows one mentioned field. Thus LOCATE FOR field1 = "???" AND field1 = "whatever" its not :find valid so we must send it to filter instead. Ill change ado_locate to overcome ...

... in this case? 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 ...

Cual es la diferencia entre.

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

hablando concretamente de MySql y DOLPHIN


saludos..

... past with TXT files. Generate the PDF using whatever tool you have and include in it keywords for the fields you want to insert--something like [*field1*] (including the brackets and asterisks). This will be your form. Then load the entire file into a memory variable using memoread() or the binary ...

hello try

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

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


saludos

... aliases creates problems, 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.

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

... a log file, at the same time that you save the data to the DBF, in example: LogFile( "log.txt", { value1, ..., valueN } ) alias->field1 := value1 etc... so we can see if the same error appears in log.txt

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

... DBF to ADO. I 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. ...

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

... to a temporary 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

Enrico, all, solved!! I use database fields to make the title of the main window, like a->field1+a->field2, perhaps it has spaces in the field, not finding the window title, after use a constant as name of the main window, it worked. I think that all solutions posted ...

Dear friends: Can somebody post a small sample about how use fields names on variables? Something like this: cField := "FIELD1" oServer:Query("INSERT INTO MyTable ( '"+ cField + "') VALUES ('"+ cField + "' + '100.00') ,") I got: Sintaxis error ...