[Gambas-user] Databases, please help me!

[Dag Jarle Johansen]

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 statement in Gambas I
rather let it out.

regards
Dag



Am Samstag, den 06.02.2010, 21:34 +0100 schrieb M. Cs.:
> 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 TEXT,volume TEXT,name BLOB,img BLOB)
> 
> Is it a bug?
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the business
> Choose flexible plans and management services without long-term contracts
> Personal 24x7 support from experience hosting pros just a phone call away.
> http://p.sf.net/sfu/theplanet-com
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user