FiveTech Software tech support forums

for modifying and editing you can use:

Code: Select all Expand view: oRs:descript := cNewValue oRs:fetcha := date() // ..... oRs:Save()

I found oRs:DESCRIP Works

Code: Select all Expand view: ? oRs:FieldGet( 5 ) // works ? oRs:DESCRIP // works. Case not sensitive ? oRs:Fields( "DESCRIP" ):Value // works. Ado syntax compatible

How can I recover values from a SELECT using the field name and not its position in th array? oCn :=maria_Connect( cHost,cUser,cDb,cPwd ) IF oCn=NIL msgwait("Error conectando con eventos en la nube","") return nil ENDIF cQwery:="SELECT ...

... (!$dbfHandle) { die("Error: Unable to open DBF file.");}// Get the number of records and fields$totalRecords = php4dbf_numrecords($dbfHandle);$totalFields = php4dbf_numfields($dbfHandle);// Initialize statistics$ageGroups ...

I have an object 'xbrowse', using tdolphin. The main query has a relationship between tables, which coincidentally has a field in the table with the same name: "key". But this field is not part of the query. SELECT p.key, p.data, c.name FROM orders AS p LEFT JOIN customers ...

MarcoBoschi wrote:Silvio,
have you some records in which the year of field named "data" is 2024
In the screenshot I see 1971

Bye

yes that is the beginning of the archive, I tried to make a filter in emagdbu

Silvio,
have you some records in which the year of field named "data" is 2024
In the screenshot I see 1971

Bye

... ORDER : to use an index when filling the combo, in this case it is a TAG of an index FOR : is for the data to be filled accoring a condition e.g. field->state = 'IL' TOOLTIP : no need to explain Important! The specification of ITEMFIELD and LISTITEM can be not only the name of the field, but ...

... utilice un indice en el llenado del combo, en este caso es un TAG de un indice FOR : es para los datos del llenado cumplan con esa condicion ej. field->state = 'IL' TOOLTIP : no es necesario explicar Importante! la especificacion del ITEMFIELD y LISTITEM no solo puede ser el nombre del campo, ...

... the edited row? Especially when it comes to a "query" that has "INNER JOIN" included... Do you need to edit and modify a field of a joined table? Try this sample: function EditJoin() local oCn, oRs, cSqlTEXT INTO cSqlSELECT C.ID, C.City, C.State, S.name AS StateName, ...

... you confirm, it is fast. Have you acode snipped where you use Xbrowse Header gets and use temp index instead of filter. You would make local ... Field Tag, Naam, Kleur Filter = "WIC" $ UPPER( TAG ) .AND. "POLO" $ UPPER( NAAM ) .AND. "WHITE" $ UPPER( KLEUR ) Index ...

... FoxPro introduced Rushmore technology and our present DBFCDX uses similar technology to optimize filters. Since we already have and index on the field "INVOICE", INCOICE="ABCDEF" is highly optimized. That means we can use filters instead of Scopes to limit visibility of parts ...

3) Is it possible to show the bitmap in a column ONLY when the cell is editable ? In my sample, the field is only editable when i add a new row and field->codprd is empty. i modified the Method PaintCell() of the class this way: original code: //----------------------------------------------------------------------------// ...

... OBJECT oBrw :nEditTypes := EDIT_GET :lFastEdit := .t. :lF2KeyToEdit := .t. :bPastEof := { || iif(!empty(field->codprd),dbappend(), ), oBrw:RefreshCurrent() } WITH OBJECT :aCols[ 1 ] :nEditType := EDIT_GET_BUTTON ...

FiveTech Software tech support forums

Search found 4301 matches: field

Re: Mysql recover values usaing field names

Re: Mysql recover values usaing field names

Re: Mysql recover values usaing field names

Mysql recover values usaing field names

Re: cloud or not cloud

xbrowse(autosort) + tdolphin - erro

Re: Problem with Filter and Tdatabase

Re: Problem with Filter and Tdatabase

a DBCOMBO review

Una revision de DBCOMBO

Re: FWH 24.09 y bOnPostEdit

Re: Extending SetScope()

Re: Extending SetScope()

Re: Edit cell IN xBrowse for nEditType EDIT_GET_BUTTON

Edit cell IN xBrowse for nEditType EDIT_GET_BUTTON