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

Алексей Беспалов bespalov.av at ...626...
Mon Feb 6 04:34:16 CET 2012


abbat, see exeple
http://gambas.pro/gambas/gambas_mysql_podkluchenie.htm

2012/2/6 Robert Juhasz <robert1juhasz at ...626...>

> On 02/06/2012 12:45 AM, abbat wrote:
> > I cant make to work the command for MySQL which works perfect on VB.NET
> >
> >   Dim COMMAND = New MySqlCommand("INSERT INTO statistic ("&
> >               "TimeCode, SessionStart, SessionEnd, Kluch, Comp) VALUES
> ('"&
> > T&  "', now(), now(),'"&  kluch&  "','"&  Nc&  "')")
> >
> > How to make it work?
> > Thanks
> >
> >
> Hello,
>
> If you have a connection (e.g. myCon) then you can use it's Exec
> function to execute mysql commands (e.g. myCon.Exec("CREATE VIEW....")).
> If your command is a query then returns the result r (called resultset
> in VB, I think), e.g. r=myCon.Exec("SELECT * FROM ...")
>
> Robi
>
>
> ------------------------------------------------------------------------------
> 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
>



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



More information about the User mailing list