New topic: 

Problem with SQL statement

<http://forums.realsoftware.com/viewtopic.php?t=35654>

         Page 1 of 1
   [ 1 post ]                 Previous topic | Next topic          Author  
Message        Mike Leffler          Post subject: Problem with SQL 
statementPosted: Wed Sep 29, 2010 9:01 am                         
Joined: Mon Aug 04, 2008 8:25 am
Posts: 24                I'm sure this is something simple but I cant see it.

This statement gives me an error stating it expects a string but got int32.

SqlStatement = "Select * From FoodProbes Where ButtonNumber = " +  
FoundButtonNumber

ButtonNumber and FoundButtonNumber are both defined as integers.

Anybody see what is going on?  I have tried formatting this a dozen different 
ways with no luck.

F.Y.I. I build the SqlStatement as a string first then use it in the SqlSelect 
statement.  I found it to be easier with complex statements.

thanks,   
                             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 1500 classes with 29000 functions in one REALbasic plug-in collection. 
The Monkeybread Software Realbasic Plugin v9.3. 
http://www.monkeybreadsoftware.de/realbasic/plugins.shtml

[email protected]

Reply via email to