[Gambas-user] How To INSERT INTO in MySQL?

[Алексей Беспалов]

The string not finished! Gambas do not cut string. Print in one string.

Gambas не дает разрывать строки как VB. Пиши все в одну строку.

2012/2/6 abbat <abbat.81 at ...787...>

>
>
> http://old.nabble.com/file/p33270528/2012-02-06-123728_1440x900_scrot.png
>
>
> Caveat wrote:
> >
> > Here's some working code...
> >
> >   conn = DataAccess.getConnection()
> >   conn.Exec("delete from UTI001 where CLEF = &1", "Caveat")
> >   conn.Exec("insert into UTI001 (CLEF, Langue, Backup) VALUES (&1, &2,
> > &3)", "Caveat", "EN", "C:\\Temp")
> >   rSet = conn.Exec("select * from UTI001 where CLEF = &1", "Caveat")
> >   If rSet Not Null Then
> >     If rSet.Count > 0 Then
> >       rSet.MoveFirst
> >       Print rSet["CLEF"], rSet["Langue"]
> >     Endif
> >   Endif
> >
> > As expected, it prints:
> >
> > Caveat  EN
> >
> > Regards,
> > Caveat
> >
> > On Mon, 2012-02-06 at 09:21 +0100, Caveat wrote:
> >> On Mon, 2012-02-06 at 00:14 -0800, abbat wrote:
> >> >
> >> > but it not work
> >>
> >> <sigh>
> >>
> >> Can you at least tell us the error message you got?  Why do we have to
> >> try to GUESS why it's not working?
> >>
> >>
> >>
> ------------------------------------------------------------------------------
> >> Try before you buy = See our experts in action!
> >> The most comprehensive online learning library for Microsoft developers
> >> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> >> Metro Style Apps, more. Free future releases when you subscribe now!
> >> http://p.sf.net/sfu/learndevnow-dev2
> >> _______________________________________________
> >> Gambas-user mailing list
> >> Gambas-user at lists.sourceforge.net
> >> https://lists.sourceforge.net/lists/listinfo/gambas-user
> >
> >
> >
> >
> ------------------------------------------------------------------------------
> > Try before you buy = See our experts in action!
> > The most comprehensive online learning library for Microsoft developers
> > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> > Metro Style Apps, more. Free future releases when you subscribe now!
> > http://p.sf.net/sfu/learndevnow-dev2
> > _______________________________________________
> > Gambas-user mailing list
> > Gambas-user at lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/gambas-user
> >
> >
> http://old.nabble.com/file/p33270528/2012-02-06-123728_1440x900_scrot.png
> --
> View this message in context:
> http://old.nabble.com/How-To-INSERT-INTO-in-MySQL--tp33268576p33270528.html
> Sent from the gambas-user mailing list archive at Nabble.com.
>
>
>
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>



-- 
____
С уважением Алексей.