RE: Prepare statement in 4gl

>uunet!bjudev!dwooster, in your mail you wrote: > [ sample code left out... ] >> >> ***** Here is the error I get when I run this ***** >> >> Program stopped at "listdb.4gl", line number 17. >> SQL statement error number -201. >> A syntax error has occurred. >> >> ***** Does anyone know what is wrong ????? >> >I sure do! The sql statement INFO is just that, an SQL statement. It is NOT >a valid 4GL statement, nor is it in the 4GL manuals. According to the 4gl Reference Manual, page 7-190, "Use the PREPARE statement to preprocess an SQL statement for later execution." Also on page 3-36, "You can PREPARE any SQL statements except these: ...." and INFO is NOT listed in the list of exceptions. Therefore, I concluded that I could use INFO in a prepare statement. Does any one have a list of which SQL statements can be used in a PREPARE? Dan Wooster uunet!bjudev!dwooster