FiveTech Software tech support forums

... != 0, ::oQry:c13 := If( x, 1, 0 ) ) }   :SetCheck(, .T. )ENDWITH  If field "c13" type is TinyInt, Set MYSQL_TINYINTASLOGICAL( .T. )  and then WITH OBJECT :acols[ 7 ]   :bEditValue := { | x | If( x ...

... tengo que hace búsqueda secuencial. Gracias JONSSSON RUSSI Nota: existe una documentación completa , diferente a esta que esta en el foro : MYSQL_TinyIntAsLogical( lOnOff ) --> lPrevSetting // Default False By default, BIT fields are used for Logical values. When set ON, TinyInt is used for ...

... bit(1) DEFAULT b'0', ADO always treats BIT fields as Boolean values ( Type 11 adBoolean ). ADO does not natively support treating TINYINT as LOGICAL. If we want, we need to handle this by ourselves in our application program. Please test with this sample program. Please use the ...

... set this field as BIT @ 5.7, 22 CHECKBOX oTable:Married PROMPT "Married"  UPDATE OF oDlg     //Line 51 But not matter if I switch BIT or TINYINT, I always get this error message Time from start: 0 hours 0 mins 16 secs Error occurred at: 21/08/2022, 13:06:04 Error description: Error BASE/1070 ...

Hi Rao

"C" : Creates VarChar
"c" : Creates Binary char field
"M" : Creates Long Text Field
"m" : Creates Long BLOB

where can you see all the options? Thank you

Saludos

::oCnx:DropTable( "tbsucursal" )aDatos := { ;            { "nombre", "C", 120, 0 } ;          }lValue := ::oCnx:createtable( "tbsucursal", aDatos )IF ( lValue )...

Hola.-     ::oCnx:DropTable( "tbsucursal" )      aDatos := { ;                  { "id", "n", 2, 0, "PRI" }, ;                  { "nombre", "c", 120, 0 } ;                }      lValue := ::oCnx:createta...

... hago la consulta todo me sale bien, me muestra toda el browse bien y los checbox salen perfecto. En mod_harbour, me toco cambiar de logico a Tinyint 0 es falso y 1 es verdadero. La consulta los valores lógicos falso sale vacío y verdadero sale un rectángulo, fue por eso que me toco cambiar ...

... los meses de enero a Diciembre, como bit, al generar la consulta me generaba en esa consulta falso vacío y verdadero un rectángulo, lo cambie a Tinyint 0 falso 1 verdadero. https://subir-imagen.com/i/RCI0m

... Mr. Rao, Can you confirm it? Thanks. Hello I've the same problem! is it the same coincidense? My field is in de 3rd position too This is id_categ TINYINT(2) UNSIGNED ZEROFILL NOT NULL I do this, before Edit, but the error repeat: oQryPly:SetDefault( "id_categ", 3, FALSE ), ;oPlayer ...

  MYSQL_TinyIntAsLogical( .t. )   aStru := { ;   { "start_date",   "D", 8, 0 }, ;   { "end_date",     "D", 8, 0 }, ;   { "text",       &...

... date DEFAULT NULL, `text` text DEFAULT NULL, `room` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `id` int(11) NOT NULL, `is_paid` tinyint(1) DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1;" oCn:Execute( cSql )

... date DEFAULT NULL, `text` text DEFAULT NULL, `room` int(11) DEFAULT NULL, `status` int(11) DEFAULT NULL, `id` int(11) NOT NULL, `is_paid` tinyint(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; Can someone please show me how I can create: Text, int(11) and tinyint(1). `text` text ...

MySQL returns "false AS lCheck" AS LONG INTEGER but not as TINYINT. There is no way you can return a TinyInt or Bit value from a Query, unless the field itself is TinyInt or Bit field. We need to instruct XBrowse to treat the numeric value as logical. ...

Hi Rao, The samples you provided works.. But the other query condition (expression) still not recognized as boolean (after MYSQL_TinyIntAsLogical ( .T. ) global declaration) as shown: with TinyInt column: http://i208.photobucket.com/albums/bb82/fraxzi/FWxHarbour/setcheck_02_zpsy9dqbfp2.png ...