Hi Paolo, I'm not familiar with the "go" command in MySQL. Please check the help for multiple commands in MySQL. This may help... http://dev.mysql.com/doc/refman/5.1/en/batch-mode.html
paolo mazza wrote: > > Hi Mark, you wrote: > >>With my experience using MS SQL, you define one statement (such as your >>UPDATE), then on the next line type in "go" (without the double quotes), >>then on the next line your next statement, then the "go" on the next line, >>etc. The program "throws" that to SQL and executes all the statements, >>sequentially. >>I haven't tried this from Rev, but we use this in our product whenever we >>deliver a "patch" for a customer to update/fix data - no problem. > > I tryed this. It does not work with the revExecuteSQL command. > I got this error message from the MySQL server: > "You have an error in your SQL syntax; check the manual that corresponds > to your MySQL server version for the right syntax to use near 'go ..." > > Ciao Paolo > > ****************************************** > > Paolo Mazza > NEOL SRL > Società partecipata da Università di Padova > via N. Tommaseo 84 > 35131 - Padova (Italy) > Tel 049- 2050147 - Fax 049-7964386 > www.neol.it > > _______________________________________________ > use-revolution mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-revolution > > -- View this message in context: http://www.nabble.com/revdb_execute-problem-tf4284430.html#a12505316 Sent from the Revolution - User mailing list archive at Nabble.com. _______________________________________________ use-revolution mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
