Tool for write querys through command line.

[epz]

There is any tool for write & test & execute querys via command line
like the old dbase IV style or the sql analyzer tool? (from the Sql
Server Database System)

Thanks.

Eric

[Rick Brandt]

epz wrote:

There is any tool for write & test & execute querys via command line
like the old dbase IV style or the sql analyzer tool? (from the Sql
Server Database System)

Thanks.

Eric

If you just want to write SQL instead of using the design grid open a new query
and switch to SQL view.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[epz]

Ok, you're right but i find a more 'fast' tool. I want to send the
execute command with a function key (or Control-Enter) and to view the
query & the results in the same window, like others sql frontends.

Do you know any addin that do this?

Many thanks for your reply!

Eric

On 31 ene, 13:23, "Rick Brandt" <[e-mail]:

epz wrote:

There is any tool for write & test & execute querys via command line
like the old dbase IV style or the sql analyzer tool? (from the Sql
Server Database System)

Thanks.

Eric

If you just want to write SQL instead of using the design grid open a new query
and switch to SQL view.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[Rick Brandt]

epz wrote:

Ok, you're right but i find a more 'fast' tool. I want to send the
execute command with a function key (or Control-Enter) and to view the
query & the results in the same window, like others sql frontends.

Do you know any addin that do this?

Many thanks for your reply!

Nope. One could build a form that did this though. SQL in a large TextBox
and showing the result in a datasheet subform.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[pietlinden]

On Jan 31, 12:30 pm, "Rick Brandt" <[e-mail]:

epz wrote:

Ok, you're right but i find a more 'fast' tool. I want to send the
execute command with a function key (or Control-Enter) and to view the
query & the results in the same window, like others sql frontends.

Do you know any addin that do this?

Many thanks for your reply!

Nope. One could build a form that did this though. SQL in a large TextBox
and showing the result in a datasheet subform.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

If I remember right, there's a form on the CD in Access Developer's
Handbook that does this. Basically a textbox at the top of the form
and a datasheet below it showing the query results.

[epz]

Many thanks!

On 31 ene, 20:32, "[e-mail]" <[e-mail]>
wrote:

On Jan 31, 12:30 pm, "Rick Brandt" <[e-mail]:

epz wrote:

Ok, you're right but i find a more 'fast' tool. I want to send the
execute command with a function key (or Control-Enter) and to view the
query & the results in the same window, like others sql frontends.

Do you know any addin that do this?

Many thanks for your reply!

Nope. One could build a form that did this though. SQL in a large TextBox
and showing the result in a datasheet subform.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

If I remember right, there's a form on the CD in Access Developer's
Handbook that does this. Basically a textbox at the top of the form
and a datasheet below it showing the query results.

[Albert D. Kallal]

"epz" <ep******@sanitatintegral.orgwrote in message
news:11**********************@a75g2000cwd.googlegr oups.com...

Ok, you're right but i find a more 'fast' tool. I want to send the
execute command with a function key (or Control-Enter) and to view the
query & the results in the same window, like others sql frontends.

Well, you can click on the ! mark...so, I don't know what is "more fast"
then ONE mouse click...

If you need a shortcut key, then simply right click on the tool bar, select
customize, and change the properties of the ! button to include image and
text. If you do that...note how the "run" text has the "R" underlined. So,
now, when you type in free hand sql...to view it..simply hit alt-r

If you want, you can also customize the "view" menu (if you don't..then
alt-v, then alt-q will flip back to sql view). You can make this ONE key
stroke if you drag the "SQL" view button to the menu bar..and again set the
button to image and text (then, alt-q, and alt-r will flip between the two
views).

Also, if you don't want to bother with the above..you can right click on the
top window bar...and you get a context menu that lets you flip between free
hand text (sql) view..and running the query....

I not really sure all of the above is much better then one mouse click, but
it does allow you to freehand between typing in sql, and viewing the
sql..and not having to use the mouse....

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com