Hi, gambas 3 (or 2.99), revision i can't see :-( SQL is string S is STRING mOPT.CurUser is string
the code line is: S = SF & "SQL = SQL " & Chr(34) & " user = '" & Chr(34) & " & mOPT.CurUser & " & Chr(34) & "'," then write it with: Print #hf2, S Meanwhile I have solved it in another manner; because the last two lines of SQL adding a record are always the same (storing user and creation time), I just wrote a little textfile which I read here instead of putting together the strings with &, and that works fine. I still do not understand what is happening with the concatenation, but hope I will not drop into that any more. I make an SVN-Update tonight and hope for the best. thanks for your time and concern, regards Dag Am Mittwoch, den 03.02.2010, 21:30 +0200 schrieb Jussi Lahtinen: > I don't understand your problem. > What is your Gambas version and revision? > What are data types of SQL, S and mOPT.CurUser (I assume string)? > And what is the exact line of code that generates described error message? > With Gambas3 rev 2660 (@Ubuntu 9.10 64bit) I couldn't reproduce your problem. > > Jussi > > > On Wed, Feb 3, 2010 at 20:56, Dag Jarle Johansen > <dag.jarle.johan...@norarg.com> wrote: > > Hi all, > > > > I can't figure out what I have wrong here. I am generating subs and > > functions, and use a lot of string-handling. In just one line I become > > the error: Non terminated String, looks like this: > > > > (1) > > SQL = SQL & "user ='" & mOPT.CurUser & "'," > > > > the source generating is: > > (2) > > S = SF & "SQL = SQL " & Chr(34) & " user = '" & Chr(34) & " & > > mOPT.CurUser & " & Chr(34) & "'," > > > > SF is just 4 Spaces. > > > > if I (in 1) delete the space after "user='"_, here marked with an _, it > > works. I have many lines generated, everywhere else it works. > > > > to make it eaysier to see: > > > > SQL = SQL & "user ='"_& mOPT.CurUser & "'," > > the problem is here ^ > > > > > > does anyone have an idea? > > > > thanks and regards, > > Dag > > > > > > ------------------------------------------------------------------------------ > > 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@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > ------------------------------------------------------------------------------ > 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@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user ------------------------------------------------------------------------------ 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@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
