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

2011-01-05 Thread MSulchan Darmawan
On Wed, 5 Jan 2011 17:37:11 +0200 Jussi Lahtinen jussi.lahti...@gmail.com 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

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

2011-01-04 Thread MSulchan Darmawan
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

2009-09-07 Thread MSulchan Darmawan
Pada Mon, 7 Sep 2009 03:41:35 -0600 Dimitris Anogiatis dos...@gmail.com 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

Re: [Gambas-user] too many operands

2009-09-07 Thread MSulchan Darmawan
Pada Mon, 07 Sep 2009 13:19:32 +0200 Doriano Blengino doriano.bleng...@fastwebnet.it 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,

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

2009-08-25 Thread MSulchan Darmawan
Pada Tue, 25 Aug 2009 00:50:52 -0600 Dimitris Anogiatis dos...@gmail.com 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

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

2009-08-25 Thread MSulchan Darmawan
Pada Tue, 25 Aug 2009 04:29:32 -0600 Dimitris Anogiatis dos...@gmail.com 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),

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

2009-08-24 Thread MSulchan Darmawan
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

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

2009-08-24 Thread MSulchan Darmawan
Pada Mon, 24 Aug 2009 23:00:07 -0600 Dimitris Anogiatis dos...@gmail.com 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,