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@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
