Re: how compile sql
JDM wrote:
> >The sql query always needs to be run
> > in some sort of container (command interface or some program).
>
> hmmm
> its a pity...
> i write a macro in tacl wich one
> execute that query lots of time
> and it last to long...
> so i think if that query will be executeable
> all macro go much faster then now....
>
> jdm....
Idea: in your TACL macro...
Start SQLCI as an INLINE process.
Use the SQLCI PREPARE command to compile your query/stmt.
Use the SQLCI EXECUTE command multiple times without recompiling.
.
Relevant Pages
- RE: How to execute a select statement inside an Event Procedure?
... I am trying to execute the follow command inside the control source property: ... The NonCompliance is a query-field that I request the information. ... The Month-Process-Compliance-2 is a query. ...
(microsoft.public.access.formscoding) - Re: Which one is best performance?
... > it is then that would be the better performer. ... >> execute this command so that the datagrid gets its data. ... >> query from the C# or call a query from the Access dataBase? ...
(microsoft.public.dotnet.languages.csharp) - Re: NULL param for NOT NULL INT column fails execution
... > When i execute the above command with a NULL parameter, ... If you use ICommandWithParameters, your Execute ... The query plan for the ... possible that using the SQL Profiler to see what's sent to SQL Server ...
(microsoft.public.data.oledb) - RE: insert using sqlparameters
... write the query & then use execute. ... //execute command ...
(microsoft.public.dotnet.languages.csharp) - [Full-Disclosure] Advanced usage of system() function.
... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit ... Connection closed by foreign host. ... think what we want to execute. ...
(Full-Disclosure) |
|
