The select statement is in a field

Ok, I inherited this database and there is a field that stopres a select
statement. Is there anyway possible to execute the value of the field
within a select statement?

For example:

the table:
Name "george"
lookupForName "Select orders from Ordertable"

So maybe something like select name, execute(lookupforname) as orders

Sorry, I didn't design this, just inherited :)

george


.

Relevant Pages

  • Re: Open or ExecSql ?
    ... Execute doesn't return, for example insert just puts the values in the ... database and doesn't return any set back. ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • VBA Passwords across versions
    ... I recently deployed a database with the VBA pasworded. ... 2000 cannot execute any of the code, ... John ... Prev by Date: ...
    (microsoft.public.access.security)
  • GRANT SELECT or EXECUTE to ALL sprocs or views
    ... What is the syntax to allow a user to execute any stored procedure or select ... any view in a database? ... Prev by Date: ...
    (microsoft.public.sqlserver.setup)
  • GRANT permissions
    ... What is the syntax to allow a user to execute any stored procedure or select ... any view in a database? ... Prev by Date: ...
    (microsoft.public.sqlserver)
  • Re: Cross-database execution permissions with certificates and sch
    ... activated user cannot access objects in other schemas in this database. ... injection is defended against, however, the threat exists anywhere EXECUTE ... CREATE USER dispatcher ... the certificate is a trusted authenticator because you granted AUTHENTICATE ...
    (microsoft.public.sqlserver.security)
Loading