ODBC database access

Steve Paris lists at paris-saigon.com
Sat Feb 12 08:06:22 EST 2005


Thanks Jan. It works!


Jan Schenkel wrote:

>
>Hi Steve,
>
>Welcome to Revolution -- you'll find it a great tool
>for interfacing with databases, even if it has a bit
>of a learning curve when you're used to doing this
>'the hypercard way' with backgrounds and cards.
>
>Try using single quotes for the strings in your
>SQL-suery, as in the following snippet :
>--
>put "SELECT * " & cr & \
>    "FROM Students " & cr & \
>    "WHERE Students.StudentID = '" & \
>    studentID & "'" into tSQL
>--
>
>Hope this helped,
>
>Jan Schenkel.
>
>=====
>Quartam - Tools for Revolution
><http://www.quartam.com>
>
>=====
>"As we grow older, we grow both wiser and more foolish at the same time."  (La Rochefoucauld)
>
>
>		
>__________________________________ 
>Do you Yahoo!? 
>Meet the all-new My Yahoo! - Try it today! 
>http://my.yahoo.com 
> 
>
>_______________________________________________
>use-revolution mailing list
>use-revolution at lists.runrev.com
>http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>
>  
>



More information about the Use-livecode mailing list