FiveTech Software tech support forums

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

... Use temp excl zap oRs:MoveFirst() Do while .not. oRs:eof Select temp append blank temp->field1 := oRs:Fields("field1"):Value temp->field2 := oRs:Fields("field2"):Value ... ... oRs:MoveNext() Enddo select temp dbCommit() oRs:Close() select temp //// use in your app Rick ...

Hi,

I never use numeric keys.
1st) In dates do not obtain good order; it's necessary dtos()
2st) Numerics do not permit add subkeys field1+ field2

I allways use character key expressions, are more controllables (length key) y expansives (subkeys)

Regards

Just an obvious question .. you are defining CliDes in your Select statement ? as in Select field1,field2,field3,CliDes .... or Select * ??

Rick Lipkin

... manera de adicionar, eliminar, modificar una fila en una tabla de access (MDB) es con las instrucciones de SQL INSERT INTO <tabla> (field1, field2, field2) (dato1, dato2, dato3) UPDATE <tabla> (field1, field2, field2) (dato1, dato2, dato3) WHERE field1 = 1234 DELETE <tabla> WHERE ...

... all the records across the network (but you would still only have one record in memory at a time). In the sample I do... select rut,nombre,field1,field2,field3 from clientes and "clientes" TABLE has 35 FIELDS, when I dobleclick the record, I do a new RECORDSET containing all the methods ...

... you want to show, then you can LOAD whatever you want... so NET traffic is reduced dramatically.... In the sample I do... select rut,nombre,field1,field2,field3 from clientes and "clientes" TABLE has 35 FIELDS, when I dobleclick the record, I do a new RECORDSET containing all the methods ...

... whole record buffer is written to file after record cursor is "touched". This helps to avoid multiple disk access on: FIELD1 := value1 FIELD2 := value2 ... FIELDn := valuen Use DBCOMMIT() (or move record pointer DBSKIP(), DBGOTO(), etc.) to force write of record buffer. EMG

... b) and in the fields clause use the handler number instead of the field name: REDEFINE LISTBOX.... FIELDS dbf->field, dbf->field2, IIF(deleted(),hBmp1,hBmp2),dbf->field3...... -------------------------------------------------------------------------------- Is it possible ...

... use appropriate connection string from http://www.connectionstrings.com ------------------------------- > oCol:bStrData := { || str(field1 + field2 + field3) } > it is not any more necessary in xbrowse to covert values as character values. Use of bStrData is deprecated according to documentation ...

How about something like:

oCol:bStrData := { || str(field1 + field2 + field3) }

... estoy haciendo pruebas y me gustaría saber ¿cómo puedo conocer la existencia de un data de una clase?, es decir. class myclass data field1 data field2 data field3 .... end class quiero saber si existe por ejemplo clase:field3. He probado: if type('clase:field3') == "UI",con valtype, pero no ...

... in the browse you wish to view .. SELECT * from table can get UGLY if you have a lot of records and lots of fields .. consider SELECT field1,field2,field3 from table order by field1... and I would highly consider you stay away from a full table scan and include a where clause for only those ...

... oRdd:Skip(1) field->Field3="test3" *field->Field3="test update2" *do while n <= 10 * n++ * oRdd:oOdbc:append() * field->field2=n *enddo browse() oRdd:End() return nil

... DO WHILE !(cDBFILE)->(EOF()) oSheet:Cells( nLine, 1 ):Value = (cDBFILE)->Field1 oSheet:Cells( nLine, 2 ):Value = (cDBFILE)->Field2 nLine:=nLine+1 (cDBFILE)->(DBSKIP(1)) ENDDO oExcel:Visible := .T.