On Fri, December 2, 2016 9:18 am, Martin Collins via Lazarus wrote:
> The weird thing is that when creating my fields the visual database
> managers did not have the option of VARCHAR only TEXT (plus INTEGER, BLOB,
> REAL & NUMERIC), but I just found I can create a VARCHAR field by
> executing your
On 02/12/16 06:13, LacaK via Lazarus wrote:
>>
>> Casting it as a different type in the SQL statement worked!
> You are not required to that if you have declared table "mytable" as:
> CREATE TABLE "mytable" (
> FileName varchar(100),
> Date datetime
> )
>
> -Laco
Thank you Laco. Just tried that
Dňa 1.12.2016 o 21:40 Martin Collins via Lazarus napísal(a):
On 01/12/16 16:15, Martin Collins via Lazarus wrote:
From what I understand, SQLite TEXT type has no set length so db aware
components treat it as a memo. Therefore when I assign a TEXT field to a
db aware component, all that appears
On 01/12/16 16:15, Martin Collins via Lazarus wrote:
> From what I understand, SQLite TEXT type has no set length so db aware
> components treat it as a memo. Therefore when I assign a TEXT field to a
> db aware component, all that appears in the component is "(MEMO)", even
> though most of my TEXT
Hi,
Using SQLite3, Lazarus 1.6.2 & FPC 3.0.0 on Peppermint Linux 7.
I have a small problem when using the db aware components & sqlite.
After countless googling I understand why the components do this but can
not find a simple solution! (BTW I this is my first time working with
DBs & SQLite seeme
