Hi Everyone

I hope someone can spot my error as I can not and this is driving me nuts


The above SQL code works on Windows VB.net but I can not seem to get it to work correct on Gambas could someone Please point out where i have gone wrong (as I have been working on this all day)

Thank-you

 i do not know SQL but this line is wrong…

$Query &= "Replace(linetext, ",, ", ", ") As Linetext "

the Replace is a vb command not a sql one

maybe…

$Query &= Replace(linetext, ",, ", ", ")

(just a guess, it's something like that)

BruceSteers said

i do not know SQL but this line is wrong…

$Query &= "Replace(linetext, ",, ", ", ") As Linetext "

the Replace is a vb command not a sql one

maybe…

$Query &= Replace(linetext, ",, ", ", ")

(just a guess, it's something like that)

i could be wrong and it is sql command in which case …
$Query &= "Replace(linetext, ",, ", ", ") As Linetext "

(backslash the quotes)

Like i say i do not know sql but understanding what that line is supposed to do and doing it the gambas way is the key to fixing the problem.

this might help you ;

https://forum.gambas.one/viewtopic.php?t=1336

Thanks Guys I shall have a read of that other forum tomorrow morning.

this is the same  this :


When building a string to query a SQL file and a little eraser to write  

I do alot of mysql with gambas. I would have to agree that we need some more information. If you can show us what the data in the table looks like along with what VB.net is returning then what you get on gambas I think I can help you.

 I suggest that you look at the gb.db.SQLRequest class if you have a lot of these to do.
It takes a bit of getting used to but in the end it makes building sql statements quite easy.
b

Are there any examples of how to use it .... sample programs ?