Recent content by wftjeremy

  1. W

    Toraclescript setting command

    Got it to work, some of the code is below... any body have a better way of doing it? //clear and assign the memo to the script script.lines.clear; script.lines := memo1.lines; //set the # of commands commands := script.Commands.count; //set the current memo line current := memo1.CaretPos.y...
  2. W

    Toraclescript setting command

    Hmmm, nope, that wouldn't work, I need to display the SQL so they can pick what they want to run, plus they always modify the SQL. The smart thing to do would be to build an entire new app to do it... but I'm a DBA...not a programmer, so editing is more time saving. I still need to relate a...
  3. W

    Toraclescript setting command

    I have an oracle script with about 20 commands in it (few hundred lines of sql). oraclescript runs this just fine, But I have had a request, the users want to be able to run a certain command in the script and not the rest, what I want to do is have the script in a memo field the user...
  4. W

    Cancellable queries

    An example would be great! I really don't understand the multi-threaded and something to go from would be great.
  5. W

    Cancellable queries

    I have gone through all of the examples I can find for cancellable queries... still can't get it to work. What I have is simple. I have a button that decides if entries in a memo field is a select statement or not. If it isn't a select statement the query is passed to a toraclescript and ran...
  6. W

    toraclescript data to a datasource

    I did that, kind of. I used the ONCOMMAND event instead. I was hoping to avoid the following: I pass the query off to a toracledataset and run and am able to get all everything I want. BUT the toraclescript is still processing the SQL, therefor the query is running twice when it doesn't need...
  7. W

    toraclescript data to a datasource

    I want to be able to have a memo that it's lines are assigned to a toraclescript, then executed. The none select commands work fine and I am happy with the output, but if there is a select statement in there I want the data to come into a dataset and then into a DBgrid. The only thing I can...
Back
Top