New topic: Linux : a request ok with sqlitebrowser but in the code
<http://forums.realsoftware.com/viewtopic.php?t=26180> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message bodamcity Post subject: Linux : a request ok with sqlitebrowser but in the codePosted: Sat Jan 24, 2009 5:00 am Joined: Fri Jan 23, 2009 5:58 pm Posts: 1 Hello, I use RB20085.1 on Linux ubuntu I' ve this request : select id,nom,prenom,naissance from adherents where id not in (select id_adherent from equipes where equipe='ADULTES') when i try in my program the result is 0 and when i cut and paste this request in sqlitebrowser to test. The result is 13 and that' s ok On first i believe it was a problem with the imbricated select and i test in many way. i try to change the clause where in the second select and i discover a strange thing. when i test a numeric colon the result is ok select id,nom,prenom,naissance from adherents where id not in (select id_adherent from equipes where id_adherent='1') when i test a string colon then imbricated select does not work Perhaps it' s a problem whit the ' or a " in the request i use it with Dim sqltest as string sqltest=select id,nom,prenom,naissance from adherents where id not in (select id_adherent from equipes where equipe='ADULTES')" I don' t know what to test else Is anybody has a idea Thank' s Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 900 classes with 18000 functions in one REALbasic plug-in. The Monkeybread Software Realbasic Plugin v8.1. <http://www.monkeybreadsoftware.de/realbasic/plugins.shtml> [email protected]
