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