Zeoslib Portal

Sorry Mark, I saw the Team member and assumed. Well you know. Since SQL lite version 3 and above has these column affinities ( from the SQLITE3 Website ) ------------------------------------------------------------------------------------ NULL. The value is a NULL value. INTEGER. The value is a sign...

Is this a Test ? When you do the CREATE Statement Substitute TEXT for Any MEMO or anywhere you need to use a string longer than 255. I Found the Answer in the ZDbcSqLiteUtils.pas in the dbc directory. look at the ConvertSQLiteTypeToSQLType MEMO it not converted but TEXT is --------------------------...

Well thanks for all the help. One word did it TEXT instead of Memo.
at least i got it fixed.

Well i had a similar problem and if you read the Sqlite3 documentation its states you must write a NULL to the INTEGER PRIMARY KEY for it to update. Also i think it might be in the way you are creating that field it just need to read INTEGER PRIMARY KEY the NOT NULL and AUTOINCREMENT may be throwing...

I have checked with three different Sqlite Viewers and the memo is all there. but using a DBMemo only show the first 255 char ( or so ) are shown. I haven't seen this problem since I worked with Paradox PLEASE HELP I'm no novice but I feel like one right now ! I know this is going to be a slap on th...