MySQL help

[Sarah Reichelt]

Hi Larry,

I haven't time at the moment to give you a detailed answer, but if you  
download the stack "MySQLtests.rev from my web page, you can follow how  
to firstly connect to a database and then get data from a query using  
that connection. If you need any more help after that, please ask.

Cheers,
Sarah
sarahr at genesearch.com.au
http://www.troz.net/Rev/

On 15 Jul 2004, at 8:01 pm, Larry Koscianski wrote:

> I new to Revolution.   Used to work with HyperCard, many many years  
> ago.
> Lost most of it.
>
> I have a MySQL database running @ the office.
> I'm writing a Revolution screen to display one record.
> I can display a table - no problem.
>
> I want to enter a part#, press the button, and have the results of the  
> SQL Query fill my card fields.
> I'm building my SQL Query then executing it in the revQuerydatabase  
> command.  like this;
>
> on mouseup
>   put ("Select * from parts where partnumber='" & field  
> searchpartnumber & "'") into card field "sqlquery"
>   get revQueryDatabase (mcss, field "sqlquery",field  
> "partnumber",field "description",field "labor",field  
> "exchangeprice",field "stockprice")
> end mouseup
>
> Can you help????
>
> Thanks
> ----------------------------------------------------------------------- 
> -------------------
> Larry Koscianski