Thanks to all of you! I was a totally idiot! I've commented out one part of
the querry text, where the WHERE clausule were defined.[?]
Csaba
<<338.gif>>--
The Planet: dedicated and managed hosting, cloud storage, colocation
> I'm slightly going angry.
>
> This excerpt shows the part of code which aims to give each file in the
> TreeView its thumbnail image:
>
> querry = "SELECT FPath,FName,FSubs FROM " & CD
> valasz = DBconX.Exec(querry)
> FOR EACH valasz
> fle.Add(valasz!"FName")
Don't use quote there. It is:
> > I'm almost there. Still I have a big problem and a possible bug:
> > When I do a querry:
> > querry="SELEC * FROM Thumbs WHERE fajl='b1.jpg' AND volume='ALPHA';"
> >
> > I'm getting 0 hits, although when I do the same querry in terminal, I
> > have exactly 1 shot, as it has to be.
> >
> > Struc
I'm slightly going angry.
This excerpt shows the part of code which aims to give each file in the
TreeView its thumbnail image:
querry = "SELECT FPath,FName,FSubs FROM " & CD
valasz = DBconX.Exec(querry)
FOR EACH valasz
fle.Add(valasz!"FName")
pth.Add(valasz!"FPath")
subs.Add(valasz!"FSubs")
tipu
The mistery goes on:
I managed to get the results with closing the connection in other part of
code:
altea.Type = "sqlite"
altea.Host = User.Home & "/.GamCat"
TRY altea.Open()
IF NOT altea.Databases.Exist(User.Home & "/.GamCat/ImageThumbs") THEN
altea.Databases.Add("ImageThumbs")
WAIT 0.5
altea.Cl
> I'm almost there. Still I have a big problem and a possible bug:
> When I do a querry:
> querry="SELEC * FROM Thumbs WHERE fajl='b1.jpg' AND volume='ALPHA';"
>
> I'm getting 0 hits, although when I do the same querry in terminal, I have
> exactly 1 shot, as it has to be.
>
> Structure of table:
Hi,
a BLOB is defined as a field for binary data, which only means, every
character is stored as is, this may be letters or the codes you get from
an image. So far clear. In MySQL one has to increase the
max_allowed_packet, because by default max. 1MB can be written in one
line (field). looking fo
This error was just typographic. Of course I was using SELECT in the
program.
But letting out the semicolon doesn't changes the situation.
Is it possible, that SELECT cannot handle records which are containing
BLOBS?
--
The
Hi,
depends on if you have copied your query-text from the source or wrote
it here:
querry="SELEC * FROM Thumbs WHERE fajl='b1.jpg' AND volume='ALPHA';"
SELECT rather than SELEC
and I am not so sure if it good to have the ";" at the end,
in MySQL Editor f. eks you should, using the same stateme
I'm almost there. Still I have a big problem and a possible bug:
When I do a querry:
querry="SELEC * FROM Thumbs WHERE fajl='b1.jpg' AND volume='ALPHA';"
I'm getting 0 hits, although when I do the same querry in terminal, I have
exactly 1 shot, as it has to be.
Structure of table:
Thumbs(fajl TE
Maybe this helps (it's part of a project i did)
' Gambas class file
rsD AS Result
rsK AS Result
rfield AS ResultField
ctrl AS Control
MColl AS NEW Collection
FHand AS File
p AS picture
Mandat AS String
PaTag AS String[]
Id AS Integer
PRIVATE CONST thumbSize AS Integer = 90
bigone AS Integer = 4
On Saturday 06 February 2010 21:02:57 M. Cs. wrote:
> I'm repeating my question, since the documentation is quite obsolete in
> this topic:
>
> How can I open a picture with Gambas2 ("/home/me/pic.jpg"), and put it into
> a sqlite database table as a blob?
> How can I use the picture stored in th
I'm repeating my question, since the documentation is quite obsolete in this
topic:
How can I open a picture with Gambas2 ("/home/me/pic.jpg"), and put it into
a sqlite database table as a blob?
How can I use the picture stored in the blob to display as a Picture?
Is this solvable at all?
Csaba
13 matches
Mail list logo
