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
