Search found 3 matches

by mvniekerk
19.01.2006, 19:16
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Blob data edit / add problem
Replies: 4
Views: 1349

On reviewing I see my explanation was a bit vague. :oops: T is a TZQuery, initiated with T.SQL.Add("Select * from `actionlist`"); T.Active := True; Description as a variable is a TStrings variable. The error after the "post" command was 'Cannot insert table, field 'Description' c...
by mvniekerk
19.01.2006, 17:07
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Blob data edit / add problem
Replies: 4
Views: 1349

Blob data edit / add problem

Please look at the code. I'm trying to insert a record with blob data (actually a TMemoField). I get an error after the "Post' Command T.Insert; try T.Edit; MS := T.CreateBlobStream(T.FieldByName('Description'), bmWrite); Description.SaveToStream(MS); T.FieldValues['ID'] := ID; T.FieldValues['N...
by mvniekerk
11.12.2005, 19:48
Forum: 6.5.1 (alpha) - 6.6.x (beta)
Topic: Insert record error
Replies: 1
Views: 790

Insert record error

The code is trying to insert a record with the TZQuery.InsertRecord procedure into a blob field. There is a TZQuery datActions.sqlList. sqlList already has a blob field set up sqlListDescription (TMemoField); I'm using a pointer T to point to the sqlList TQuery and Q to link to the TMemofield, and M...