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 [EMAIL PROTECTED] 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
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
