Re: question about "CONTAINS SQL"

2006-01-20 Thread Rhino
- Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]>; "wangxu" <[EMAIL PROTECTED]> Cc: "mysql" Sent: Friday, January 20, 2006 2:20 AM Subject: Re: question about "CONTAINS SQL"

Re: question about "CONTAINS SQL"

2006-01-20 Thread wangxu
SQL and see what happens at runtime. If it > >fails, as I strongly expect, change CONTAINS SQL to MODIFIES SQL > >DATA and your error will almost certainly go away. > > No, these characteristics are merely advisory. The server doesn't > impose any restraints based on t

Re: question about "CONTAINS SQL"

2006-01-19 Thread Paul DuBois
tics are merely advisory. The server doesn't impose any restraints based on them. Rhino - Original Message - From: "wangxu" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Sent: Thursday, January 19, 2006 2:54 AM Subject: Re: question about &qu

Re: question about "CONTAINS SQL"

2006-01-19 Thread wangxu
;. > > Of course the best way to be sure is to try this for yourself. Try the > routine with CONTAINS SQL and see what happens at runtime. If it fails, as I > strongly expect, change CONTAINS SQL to MODIFIES SQL DATA and your error > will almost certainly go away. &

Re: question about "CONTAINS SQL"

2006-01-19 Thread Rhino
uot; <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PROTECTED]> Sent: Thursday, January 19, 2006 2:54 AM Subject: Re: question about "CONTAINS SQL" If I create a routine with modification operation and not spectify characteristic in CONTAINS SQL | NO SQL | READS SQL DATA

Re: question about "CONTAINS SQL"

2006-01-18 Thread Rhino
5 AM Subject: Re: question about "CONTAINS SQL" But what is INSERT OR UPDATE need? - Original Message - From: "Rhino" <[EMAIL PROTECTED]> To: "wangxu" <[EMAIL PROTECTED]>; Sent: Tuesday, January 17, 2006 9:49 PM Re: question about "CON

Re: question about "CONTAINS SQL"

2006-01-18 Thread wangxu
But what is INSERT OR UPDATE need? > - Original Message - > From: "Rhino" <[EMAIL PROTECTED]> > To: "wangxu" <[EMAIL PROTECTED]>; > Sent: Tuesday, January 17, 2006 9:49 PM > Re: question about "CONTAINS SQL" > >

Re: question about "CONTAINS SQL"

2006-01-17 Thread Rhino
- Original Message - From: "wangxu" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 17, 2006 12:35 AM Subject: question about "CONTAINS SQL" I notice there are one section in the manual: CONTAINS SQL indicates that the routine does not contain statements that read or write data.