FiveTech Software tech support forums

SUCCESS!!!!!!!!!!!!!! For the oRs:ReSync( 1,2 ) option to work .. you MUST have a PRIMARY KEY set and NOT NULL checked. No other changes to the syntax need to be made. ReSync() works perfectically and will update the visability of a changed record to a local cached recordset ...

... the linking expression of the relation specified by <nRelation>. If there is no RELATION SET for <nRelation>, DBRELATION() returns a null string (""). Obviamente si en la expresion hay referencias a variables locales, creo que se va a complicar un poco. Lo ideal sería tener una funcion ...

... ) base->x1 := x1 base->x2 := x2 . . base->xN := xN y asi sucesivamente, ya que con archivos ADT existe los datos NULL

Amigo, talvez esse trecho de "RF" possa ajuda-lo: Otras cosas a tomar en cuenta: NULL no es lo mismo que vacío.... NULL es un valor que manejan muchas tablas SQL, un campo vacío en un archivo ADT no tiene un valor "vacío", sino que tiene un valor NULL, que es un ...

... Com ADSCDX funciona perfeitamente !!! Mas com ADSADT nao Funciona : ADSCDX : dtos(ctdo(" / / ")) = SPACE( 8 ) ADSADT : dtos(ctdo(" / / ")) = NULL Já tentei isso e nao funciona usando o scope -------------------------------------------------------------------------------- REQUEST ADS,ADSKeyno,ADSKeyCount ...

... =log Spools a string out the Initialized port cString must not be larger than 32k, and no smaller than 1 byte, it may contain imbeded null bytes. The cString must remain public and can not be cleared until the buffer is clear see OUTBUFSIZE() Returns False if another stream is still ...

... in for the NIL > parameter and writes that to the table. I need to be able to let a user > blank out a date and store it as BLANK or NULL in the SQL table .. > ctod("") gives an ADO run-time if you try to write that value to the MS > SQL table. This was fixed last Feb, 16th, ...

Ramon, checa si en la estructura de tu base de datos, tienes,

NOT NULL

De ser asi cambiale por NULL

saludos..

To All I have done several Google searches and not been able to find how to write a blank or null date to a datetime field in MS Sql server using ADO recordset update. Consider this example: |DATE | | null | dDATE := oRs:Fields("DATE"):Value // xHarbour sees a NULL date ...

... PARAMS ) { _retl( TrackPopupMenu( ( HMENU ) _parnl( 1 ), _parni( 2 ), _parni( 4 ), _parni( 3 ), _parni( 5 ), ( HWND ) _parni( 6 ), NULL ) ); } //----------------------------------------------------------------------------// HARBOUR HB_FUN_ENABLEMENUITEM( PARAMS ) { _retl( EnableMenuItem( ...

Al compilar el programa MEDIA.PRG que trae de ejemplo la FWPPC0705 me da estos errores: FiveCEC.lib(ACTX.obj) : error LNK2019: unresolved external symbol IID_IUnknown referenced in function "public: void __cdecl TActiveX::Add(char *)" (?Add@TActiveX@@QAAXPAD@Z) FiveCEC.lib(ACTX.obj) : error LNK...

SELECT * FROM libros WHERE area IS NULL

o algo asi:

Libros->( AdsSetAof( Empty( area ) ) )

... con el nuevo RDDADO, Como dice Fenando, tenemos que acoplarnos con el modelo ADO saludos, cordiales, sysctrl, La dfiferencia es en incluirle NOT NULL y NULL a la creación de las tablas. Si se le incluye NOT NULL, ahi es donde truena, con NULL no pasa nada, y funciona al 100%. la cantidad de registros ...

Esta tabla aun con una fila, truena. CREATE TABLE `archivo1` ( `clave` varchar(18) NOT NULL, `folio` varchar(14) NOT NULL, `fregistro` date NOT NULL, `nombre` varchar(30) NOT NULL, PRIMARY KEY (`clave`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 y está funciona bien. CREATE ...

... wildcards. Only the asterisk (*) and percent sign (%) wild cards are allowed, and they must be the last character in the string. Value cannot be null. Note To include single quotation marks (') in the filter Value, use two single quotation marks to represent one. For example, to filter on O'Malley, ...