FiveTech Software tech support forums

... are your comments? When the programmer sets AGGR_MAX or AGGR_MIN he is also responsible to ensure that all values of the column should of same datatype or nil.

... a list of fields is provided the contents are copied into the fields specified in the list. It is the responsibility of the programmer to ensure datatype compatibility with the destination fields. 3) bProgress: Optional From the above you can see that the syntax you used for the button actions ...

Hola/Hello bpd2000,

debes usar el tipo de dato BLOB para guardar ese tipo de ficheros/you must use BLOB datatype to save these files.

https://www.sqlite.org/datatype3.html

Saludos/Best regards,

I presume the datatype for MyTime is Char ? .. I would place a msginfo() on your value to see if you are looking at a nil value or just " " Just to debug and test : cTime := odbf:Fields("MYTIME"):value Msginfo( ...

... TABLE sqltable_name CHANGE old_column_name new_column_name"  2. Add new ID field EX. "ALTER TABLE sqltable_name ADD COLUMN ID <DATATYPE>"  Now we have a AUTOINC field WHATEVER_ID and a ID with datatype you indicated. If the ID field in the dbf file is autoinc I ...

Works for those RDBMSs which support BIT datatype to represent boolean values, eg mssql, mysql, access, etc. that too if you choose BIT datatype for the field to represent boolean values. ADO recognizes these BIT fields as adBoolean, Well known ...

... from recno() its correct. Then when passing it to dbgoto() it gets to ado_gotoid() in adordd incorrect. Bookmark does not assure any specific datatype because it depends on the provider.

... .f. EditDlg( oRec ) But I do not advise this unsafe approach. Normal practice is to use "BIT" field type to create a BOOLEAN (logical) datatype in most sql databases, eg. MS Access, MS Sql, MySql, Sqlite3, etc., but not TINYINT. ADO recognizes BIT datatype as ADO Type adBoolean. FWH ...

... because I used FWH library functions. I tried many times. What saved me was that I used FWH function to create the table, which used the correct datatype, ie INT and not SMALLINT. Trust ADO and Trust FWH.

One of the advantages of SqLite is that we can store any datatype in a column of any datatype. This is like storing into and retrieving from an array. This advantage can also be dangerous pitfall at times. We are not sure at times what we accessed is ...

Manuel, Creo recordar que cambié el nombre de la clase que maneja los índices para evitar conflictos con otros fuentes (creo que los propios de FiveWin). Entre mis notas pata TDBF tengo lo siguiente: /* > 01/06/2006 C.Gelabert - A la funció Str() li he afegit Str(...,5 ,0) doncs en Harbour pren e...

... who are not providing defaults for NULL values, this modification is made. * Enhancement: Enhanced Class TDataRow. Now assignment of wronge datatype raises datatype error. Type check is relaxed for arrays and sqlite. If the programmer desires to relax type check he may set data :lTypeCheck ...

Thanks for your recommendation to use SetRDD before assigning DATA or codeblocks, that solves the problem due after executing SetRDD I can change the codeblocks, and Initiate will not run again SetRdd. That is how XBrowse is intended to be used. Any further developments assume xbrowse is used the w...

Hi, many thanks for your answer. Thanks for your recommendation to use SetRDD before assigning DATA or codeblocks, that solves the problem due after executing SetRDD I can change the codeblocks, and Initiate will not run again SetRdd. After reviewing the xBrowse class, another alternative is to defi...

... to manipulate that field without realizing it was NULL, your program will fail at run-time. 2) Also .. if you are using xHarbour .. there is a new dataType "T" for Date\Time and if you assign a DateTime value to a variable or try to manipulate that value like valtype "D" you ...