Hi, off course I have tried directly too, that works, so it seems I get something weird from the DB.
I wrote those lines here, so I think my syntax is right in the app. I have written DB-apps since 25 years, so I am pretty clear over how to handle that. What is really strange to me: S=RS!objname (With Print both show data) IF S="Header" then STOP ENDIF is ignored. I will have to check the data and the structure, I think. Thank you and regards Dag-Jarle 2011/9/24 Caveat <gam...@caveat.demon.co.uk> > In your SQL statement, it looks like there's a single quote missing > between LC= and m.LC (at the end of the line you specifically add a > single quote after the content of m.LC). > > For the rest I don't have much clue what you're going on about. I wish > you'd state clearly what it is you're trying to achieve. I'm guessing > you're trying to set the title of the Form depending on what you get out > of the database? Just a thought, but have you tried a Me.Refresh after > setting the Form title? > > If you're having trouble setting the Form title, then you should forget > all the database nonsense for a minute and try something as simple as > Me.Caption = "Aanmelden"... does that work? If not, it's nothing to do > with your ResultSet, your database, or any IF clause... it has to be > something else... > > Kind regards, > Caveat > > On Sat, 2011-09-24 at 21:00 -0300, Dag-Jarle Johansen wrote: > > Well, here I am again, almost ashamed. > > > > I shorten the source to the main thing: > > > > Public sub ReafDB() > > > > Dim RS as result > > DIM S As string > > > > SQL="Select * From APCtrl Where Pseudo='J' AND LC=" & m.LC & "'" > > RS=msql.$ConU.Exec(SQL) > > RS.Movefirst > > (There is exactly on Record present, and with print RS!objname and Print > > RS!CtrlInhalt I can see the result, even so with S and S2) > > Now the strange: > > S=RS!objname > > IF S="Header" then > > S2=RS!CtrlInhalt > > ENDIF > > Me.Caption=S2 > > END > > S="Header", definitly > > S2="Anmelden", evenso > > > > (I used S and S2 to check the content of the data) > > > > I get the caption "Budget", which is the name of the project. The > programm > > ignores the IF at all, and I also tried without if, just Me.Caption=S2 - > is > > ignored, simply. > > > > I will be grateful for any help here, the work is blocked now. > > > > Regards > > Dag-Jarle > > > ------------------------------------------------------------------------------ > > All of the data generated in your IT infrastructure is seriously > valuable. > > Why? It contains a definitive record of application performance, security > > threats, fraudulent activity, and more. Splunk takes this data and makes > > sense of it. IT sense. And common sense. > > http://p.sf.net/sfu/splunk-d2dcopy2 > > _______________________________________________ > > Gambas-user mailing list > > Gambas-user@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/gambas-user > > > > > ------------------------------------------------------------------------------ > All of the data generated in your IT infrastructure is seriously valuable. > Why? It contains a definitive record of application performance, security > threats, fraudulent activity, and more. Splunk takes this data and makes > sense of it. IT sense. And common sense. > http://p.sf.net/sfu/splunk-d2dcopy2 > _______________________________________________ > Gambas-user mailing list > Gambas-user@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/gambas-user > ------------------------------------------------------------------------------ All of the data generated in your IT infrastructure is seriously valuable. Why? It contains a definitive record of application performance, security threats, fraudulent activity, and more. Splunk takes this data and makes sense of it. IT sense. And common sense. http://p.sf.net/sfu/splunk-d2dcopy2 _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user