error in sqlite database (not edit)
lazarus / 16-Databases

----------------------------------------------------------------------
soymoe · 2019-01-04 22:31

hi, I am creating a database application with sqlite and the fields
appear with the text "memo" and I can not edit it, what will be the
reason?
http://subirimagen.me/uploads/20190104163129.png

----------------------------------------------------------------------
Jurassic Pork · 2019-01-04 23:24

hello,
if you want to edit a memo , you can use a TDbmemo component : see the
field Notes in my database example coming with lazarus  : Deadly
Mushrooms.

Friendly, J.P

----------------------------------------------------------------------
soymoe · 2019-01-05 01:25

Thanks for replying, the fields I want to edit are first and last
name, which are of the text type, not memo

----------------------------------------------------------------------
Jurassic Pork · 2019-01-05 08:08

hello,
you must use the varchar type for simple text , the text type is for
memo.
Example for my deadly mushrooms database :
Code: SQL  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i BEGIN
TRANSACTION;CREATE TABLE `DeadlyMushrooms`-- This table created by
Jurassic Pork-- for Free Pascal Lazarus-- Create date:2013-08-05
23:55:09(       ID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,     
 Scientific_Name VARCHAR NOT NULL,       Common_Name VARCHAR, `Order`
 VARCHAR, `Genus`  VARCHAR, `Notes`  TEXT, `Picture`  BLOB,
`Image_Link`  VARCHAR);
friendly, J.P