Forum > Database

bigint trouble

(1/1)

jagnje:
not a strictly lazarus question but still... i wasnt able to create a table (trying both firebird 2.5 and 3.0rc2 and lazarus 1.6) where some fields were of bigint type. error message was very strange, like that data type is not supported... the strange thing was that before that i was able to use bigints without any hassle.

since i was in a hurry, i just changed the fields into char(10) and then had no problems whatsoever. still, i would like to know what i was doing wrong.

thanks

balazsszekely:
This works fine with Firebird 2.5/Lazarus Trunk/FPC 3.0.0. The table is created without any errors.

1. Drop a TSQLScript to your form, edit the script property:

--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---CREATE TABLE TEST (    ID           INTEGER NOT NULL,    NAME         VARCHAR(10),    BIGINT_TEST  BIGINT); ALTER TABLE TEST ADD CONSTRAINT PK_TEST PRIMARY KEY (ID);              
2.

--- Code: Pascal  [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---procedure TForm1.Button1Click(Sender: TObject);begin  SQLScript1.Execute;  SQLTransaction1.CommitRetaining;end;  

Navigation

[0] Message Index