> > You were right, it was a problem of field definition. changing to > varchar(1000) it worked fine ! Thank you. > > But I thikn there is an inconsistency in the driver, because in the > update, the whole string is inserted, and in the select stmt > only 255 > chars are returned. >
This is more a SQLite issue. You pass pRequete to the database layer which sends it as is to SQLite. If pRequete contains a string which is too long for the column SQLite stores the excess data while other databases would truncate or generate an error. To read the data back, the driver uses the metadata to allocate memory to store the result set. Datasets can't work with variable length data other than blobs. If you would use tdataset to store the data instead of building your own query, the data would have been trunctated at the insertion also. If you want variable length strings, use the TEXT datatype in your table declaration. Most dbcontrols can't display memo fields but I noticed you fill in your own grid so that shouldn't be a problem. Ludo -- _______________________________________________ Lazarus mailing list [email protected] http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus
