FiveTech Software tech support forums

... esto? ... DROP TABLE IF EXISTS `prestamosdet`; CREATE TABLE `prestamosdet` ( `num_pres` mediumint(6) unsigned NOT NULL DEFAULT 0, `cuota_no` smallint(4) unsigned NOT NULL DEFAULT 0, `fecha_prog` date DEFAULT NULL, `valor_prog` decimal(10,2) unsigned NOT NULL DEFAULT 0.00, `fecha_real` date ...

... " + "'" + STR(norden,7,0) + "'" )  Nota: el número 7 lo ajustas dependiendo del tipo de campo (TINY, INTEGER, SMALLINT, etc etc) y longitud que hayas definido al crear la tabla, y recuerda que MySQL prácticamente todo lo almacena como alfabético. Saludos

... ///Variables Delphi ACR120libHandle frHandle: Smallint; fPuerto: Smallint; ACR120libHandle := LoadLibrary( "ACR120U.DLL") //Puerto del lector, es 0 si solo hay un lector conectado. fPuerto ...

... :={} &&: array[0..50] of Byte; local TagFound:=0 && Byte; Local SN:={450} && array[0..450] of Byte; local i:=0 &&smallint; local j:=0 &&smallint; Local snstr:=space(100) && string; Public frHandle:= 0, ACR120libHandle ,fretcode ACR120libHandle := ...

... expressions. This is only needed for numeric fields where the SQL type its without field len definition such as: AUTOINC, MONEY, DOUBLE, INT, SMALLINT, etc. Corrected Bugs: 1) ADOBEGINTRANS( nWA ) : without work are it starts a transaction in default adordd connection otherwise it starts in ...

... expressions. This is only needed for numeric fields where the SQL type its without field len definition such as: AUTOINC, MONEY, DOUBLE, INT, SMALLINT, etc. Corrected Bugs: 1) ADOBEGINTRANS( nWA ) : without work are it starts a transaction in default adordd connection otherwise it starts in ...

Hi Rao, I understand but SMALLINT runs well with xHarbour 1.2.1 rev 9656. What did you change from that version to 1.2.3 rev build 20141106 to affect smallint ? I know I can use ado but using a direct lib to access the db is quicker and ...

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

... Antonio, your sample work well but it is not my case. In my case the nDecimal value is loaded from a sqlite database. the field is "nDecimal smallint (2)" . I have also generated the sqlite library using last xharbour version but the problem is always in place. I will try to make a self ...

... 2 X 15 CM. (AZTECA ISSIS KOSMETICA),2.074001,BATELENGUAS DE MADERA (NAFARRETE),7.00  y mi tabla de prueba la hice asi: id smallint(2) nombre char(80) cantidad double(10,4) costo double(16,2) puedes hacer una prueba con esta info? nuevamente gracias por tu apoyo saludos ...

... this moment bitmaps in RC . Can this be done with bitmaps files instead RC ? MySql boolean type for column isn't strong define . I'm using "smallint" : 1 for true , 0 - false ... Thanks in advance ! :)

Avista,

I solved the problem by changing the type double to decimal, and than use Precision and NumericScale to detect the light and decimals.
For INT, SMALLINT,... I took the lenght that is defined by MySQL , and decimals zero

Marc Vanzegbroeck wrote:Enrico,

As you can see here, I have double of 4,1 and 15,5 and SMALLINT of 2 and 1.

I think that the tool you are using is not reporting the correct informations.

EMG

Enrico,

As you can see here, I have double of 4,1 and 15,5 and SMALLINT of 2 and 1.

... is not fixed, but just like I defined when I created them with tMySQL. I have type double, with Length 10 , Set 3 or Lengte 4, Set 1,... Also the smallint have different sizes. No, as an example, smallint is 2 bytes fixed length (-32768 to 32767). You have no way to extend its size. EMG