MSulchan Darmawan ha scritto:
> 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 Re
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
MSulchan Darmawan ha scritto:
> 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, r
MSulchan Darmawan ha scritto:
> 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, r
I'm glad it worked MSulchan,
That's why I love gambas cause it makes things so much easier :)
even more than VB6 ever would :)
Keep up the good work
Regards,
Dimitris
On Mon, Sep 7, 2009 at 3:54 AM, MSulchan Darmawan wrote:
> Pada Mon, 7 Sep 2009 03:41:35 -0600
> Dimitris Anogiatis menulis:
>
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
MSulchan,
Where is this coming from? Gambas or mysql?
can you try and do this insert in mysql in a terminal window?
if mysql doesn't return an error and accepts the insert command then
you might want to break the sql string like this
sSql = "INSERT INTO refPos(id,idpos,year,month,day, "
sSql &=
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,
