> gambas 3 (or 2.99), revision i can't see :-( svn info
> S = SF & "SQL = SQL " & Chr(34) & " user = '" & Chr(34) & " & mOPT.CurUser & > " & Chr(34) & "'," " & mOPT.CurUser & " is inside of quote marks?? Jussi > 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 > ------------------------------------------------------------------------------ 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
