Le 28/08/2013 22:18, Willy Raets a écrit :
> Hello all,
>
> I've been searching the Gambas mailing list archives and documentation
> for a answer to a problem I have. Tried all kinds of suggestions but
> haven't solved the problem yet.
>
> ...
>
> I have tried it like this in Gambas (rData being a Result and ConMyData
> being the connection)
>
> rData = ConMyData.Exec("SELECT &1 FROM IC", "'Actueel IC'")
>
The substitution syntax of Exec(), Find(), Edit()... substitutes
*values*, not fields.
Write that:
rData = ConMyData.Exec(Subst("SELECT &1 FROM IC",
ConMyData.Quote("Actueel IC")))
Regards,
--
Benoît Minisini
------------------------------------------------------------------------------
Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more!
Discover the easy way to master current and previous Microsoft technologies
and advance your career. Get an incredible 1,500+ hours of step-by-step
tutorial videos with LearnDevNow. Subscribe today and save!
http://pubads.g.doubleclick.net/gampad/clk?id=58040911&iu=/4140/ostg.clktrk
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
