Map TIntegerField max value

Asked Jan 29 '18 at 01:45

Active Jan 30 '18 at 05:16

Viewed 238 times

CREATE TABLE t1 (
   t1_id INTEGER PRIMARY KEY,
   TEST VARCHAR(50)
);

As we know Sqlite3 have range for INTEGER 0..9223372036854775807 and delphi with native conversion has integer range betwen -2147483648..2147483647 when value greater than 2147483647 value return to -1 any sugestion to fix this.

edited Jan 30 '18 at 05:16

asked Jan 29 '18 at 01:45

Dicky Tamara

Define your table column as `LONGLONGWORD` or `UINT64` then. – Victoria Jan 29 '18 at 01:52
it is posible to map this in Firedac Connection? – Dicky Tamara Jan 29 '18 at 01:56
[These are FireDAC specific pseudo-data types](http://docwiki.embarcadero.com/RADStudio/en/Using_SQLite_with_FireDAC#Mapping_SQLite_to_FireDAC_Data_Types). Are you going to create that table in your Delphi application, don't you? – Victoria Jan 29 '18 at 01:57
yes, and map rules not working with sqlite3 integer range. – Dicky Tamara Jan 29 '18 at 02:12
Then jump to the first comment here ;-) – Victoria Jan 29 '18 at 02:21
TLargeInteger quite enough? – Dicky Tamara Jan 29 '18 at 02:26
Yes, `TLargeintField` is big enough for the range you mention in your question. – Victoria Jan 29 '18 at 02:31
Please do not just repeat the tags in your question title. The tag system works extremely well here and doesn't need help. Removing that useless content from your title leaves Radstudio (no value, so remove) TIntegerField max value. – Ken White Jan 29 '18 at 13:53

Map TIntegerField max value

0 Answers0