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

[abbat]

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.