Re: [Gambas-user] OOT: Email filtering for gambas issue

On Wed, 5 Jan 2011 17:37:11 +0200 Jussi Lahtinen wrote: > ? > Every message from gambas mailing list has [Gambas-user] in subject > line..? I see now Benoît using google code for gambas bug ticket, what I want to do is to filter the ticket appart from mailing list. So I propose [gb-issue] if it

[Gambas-user] OOT: Email filtering for gambas issue

Dear all, I did by filtering From header, but I saw someone accidently hit reply and send the email to mailing list instead of replying in google code. By doing that, the filter missed it. So I prefer to filter using Subject header, but maybe it is easier if there is special subject tag, such as

Re: [Gambas-user] too many operands

Pada Mon, 07 Sep 2009 13:19:32 +0200 Doriano Blengino menulis: >res = db.Create("refpos") ' append record in table named > refpos for i = 1 to 31 > res["Res" & i] = ... >next Does this means the field name is Res1, Res2, ..., Res31 ??? If so, wow this is great, I di

Re: [Gambas-user] too many operands

Pada Mon, 7 Sep 2009 03:41:35 -0600 Dimitris Anogiatis menulis: > Where is this coming from? Gambas or mysql? Gambas. > if mysql doesn't return an error and accepts the insert command then > you might want to break the sql string like this Thanks Dimitris, it work ! Well, at least it pass the

[Gambas-user] too many operands

Dear all, Any suggestion to simplify this code ? I had "Expression too complex, too many operands" warning :D I have 36 fields data to insert. sSql = "INSERT INTO refpos (id, idpos, year, month, day, " & "r1, r2, r3, r4, r5, r6, r7, r8, r9, r10, " & "r11,

Re: [Gambas-user] type mismatch: wanted integer, got string instead (solved)

Pada Fri, 28 Aug 2009 11:23:59 +0200 Fabien Bodard menulis: > IF NOT sRain THEN > IF InStr(LCase(sRain), "x") > 0 OR InStr(sRain, "-") > 0 THEN >fRain=0 > ELSE >TRY fRain = CFloat(sRain) >IF ERROR THEN fRain=-1 'Not a Valid Number > ENDIF > ELSE > fRain=-1 > ENDIF Thanks Fabien,

Re: [Gambas-user] type mismatch: wanted integer, got string instead (solved)

Pada Tue, 25 Aug 2009 04:29:32 -0600 Dimitris Anogiatis menulis: > give it a try MSulchan and tell me if it works for you Thank you Dimitris, after a little try and error, I change the code into like this : IF IsNull(Val(sRain)) = FALSE THEN IF InStr(LCase(sRain), "x") > 0 OR InSt

Re: [Gambas-user] type mismatch: wanted integer, got string instead

Pada Tue, 25 Aug 2009 00:50:52 -0600 Dimitris Anogiatis menulis: > I hope this helps a bit more Great... this is more reasonable... I'll try it first... Thank you guys... -- Cheers, [-Sulchan-] Terbang dengan claws-mail 3.7.2 Mendarat di hardy heron 8.04.3 LTS signature.asc Description: PGP

Re: [Gambas-user] type mismatch: wanted integer, got string instead

Pada Mon, 24 Aug 2009 23:00:07 -0600 Dimitris Anogiatis menulis: > this way iRain would always have an integer and you wouldn't have to > worry about > the mismatch error... assuming "0", "1", "2", "x", "-" and NULL are > the only values > used in your database. Thanks Dimitris and JY, Unfortun

[Gambas-user] type mismatch: wanted integer, got string instead

Dear sir, I have the following code : DIM sRain AS String DIM iRain AS Integer DIM iPos AS Integer DIM iYear AS String DIM iMonth AS String modMain.Connect hRes = modMain.$Con.Exec("SELECT * FROM table") FOR EACH hRes iPos = hRes!id iYear = hRes!yr iMonth = hRes!mn