FiveTech Software tech support forums

... YourTable table" ) RETURN(.F.) END TRY select 1 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() ...

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

Hi,

INDEX ON STR(VAL(MyDbf->Field1),LEN(MyDbf->Field1)) TO MyIndex

Yes this is going well ....

Enrico ...this is problem in FWH too if you use NTX index ...with CDX there is no problem.

Thanks to all,
Best regards,

... {"11","9","9999999999","99999999999","11111111111" } DbCreate( "MyDbf.dbf", { { "Field1", "C", 13, 0 } } ) USE MyDbf FOR i = 1 TO LEN( aData) DbAppend() REPLACE Field1 WITH aData[ i ] NEXT INDEX ON VAL(MyDbf->Field1) ...

Hi Tim; Could it be that what you are getting is a gpf? A way to test is to manually introduce semantics error such as; MsgInfo( nonexitant->field1 ) //where that work area is not in use. or local cText := "some text" if cText endif That should compile fine yet it would cause the ...

... ok and we shall see him soon here in this forum. As per your questions , i do this frequently 1. Load dbf into an array while ! eof() aadd(TVISU,{field1,file2,filed3,ctod(field4) ....}) // You can also transform field dates ..etc Browsing the array This is a sample where i browse certain fields ...

... (Alias). With other words: As far as I know, it’s not possible to alter the leading table, you can’t do something like this: Row 1: table1->Field1… n Row 2: table1->Field1…n … Row n: table2-> Field1…n … Row n+k: table1->Field1…n … So all informations you want to browse, must have ...

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

Rick Lipkin

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

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

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

... return(.f.) endif database->field := cValue unlock // reclock() select database if reclock( 5 ) // time-out else return(.f.) endif database->field1 := cValue unlock Hope this helps.. Rick Lipkin /* LOGICAL NETUSE( CDATABASE, LOPENMODE, NSECONDS )  CHARACTER CDATABASE      - NAME OF DATABASE  ...

... yes, of cause. The 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.

... ) RETURN So, 2 problems: 1. Border and scrollbar in ActiveX 2. Tab does not go from field1 to fields2 or in the sample from field1 to submit button. Tab is handled by the WINDOW instead of the ACTIVEX. I also tried to put the "oActiveX:nDlgCode ...

... {"+ cLine + "} }") Not perfect, but you could do it like this as a last resort : bLine:=&("{|| {MyBrwLine()} }") FUNCTION MyBrwLine() RETURN {Field1, Field2, Field3.... Field35} -------------------------------------------------------------------------------- Please look at the .JPG: ( WIN3.JPG ...