Guest jumper Report post Posted 04/06/2004 03:11 AM Hi, there One more question to get done with my phone order system . Which module shoul I use to deduct 1 in the product quantity database when customer press certain key to confirm the order? And what sql sentence should I choose? I'm useing mysql . Voiceguide is excellent. I just learn some basic of sql one month ago and I almost can use voiceguide to program all I want without any program lauguage knowlege. thanks. Share this post Link to post
SupportTeam Report post Posted 04/06/2004 05:09 AM you may want to retrieve the current value using one DB Query module, subtract from that value using an Evaluate Expression module, then save the new value to a database using another DB Query module. Or you may be able to write some SQL for database to do all this - this depends on database and if it can do stored procedures etc. Share this post Link to post
