Results 1 to 2 of 2

Thread: child command SQL

  1. Feb 4th, 2000, 01:22 AM #1
    DrewDog_21
    DrewDog_21 is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Columbia, SC USA
    Posts
    374

    Post

    Is it possible to change the SQL of a data environment child command at run time? I tried doing so with the .CommandText argument but that gives me an invalid procedure call error.

    Thanks

    Andrew
    Reply With Quote Reply With Quote
  2. Feb 4th, 2000, 04:27 PM #2
    Forest Dragon
    Forest Dragon is offline
    Addicted Member
    Join Date
    Oct 1999
    Posts
    253

    Post

    I recommend not using the Data Environment in such cases, but creating the SQL query at run-time by using the SHAPE command, and when you need to change it, just rewrite the query.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width