J
J_J
Hi,
How can I try some SQL commans or codes with access?
Regards
J_J
How can I try some SQL commans or codes with access?
Regards
J_J
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Rick Brandt
J_J said:Hi,
How can I try some SQL commans or codes with access?
Regards
J_J
Open a new query and then switch to SQL view.
J
J_J
Thank you Rick,
But what I actually meant was not just to "look behind the coding" of
existing querry tables,
but to try my own SQL commands on a database using Access SQL facilities...
Regards
J_J
But what I actually meant was not just to "look behind the coding" of
existing querry tables,
but to try my own SQL commands on a database using Access SQL facilities...
Regards
J_J
R
Rick Brandt
J_J said:Thank you Rick,
But what I actually meant was not just to "look behind the coding" of
existing querry tables,
but to try my own SQL commands on a database using Access SQL
facilities... Regards
If you open a query in SQL view what you see is editable and therefore you can
do exactly what you are suggesting.
R
Randy Harris
J_J said:Hi,
How can I try some SQL commans or codes with access?
Regards
J_J
In addition to Rick's suggestion, there is an add-in, called SQL Scratchpad
that is included with the Access Developers Handbook, by Getz et al.
J
J_J
Can you give a d/l link for the add-in please?
Randy Harris said:In addition to Rick's suggestion, there is an add-in, called SQL
Scratchpad
that is included with the Access Developers Handbook, by Getz et al.
A
Albert D.Kallal
J_J said:Thank you Rick,
But what I actually meant was not just to "look behind the coding" of
existing querry tables,
but to try my own SQL commands on a database using Access SQL
facilities...
Regards
J_J
I must be miss-understanding something in the above?
Just type the the sql, and hit the ! to run the sql.....
How is the above not trying your own sql commands?
You can also type sql in the debug window also, but that would be silly when
you got the query builder....
in the debug window, you can execute action queries (that don't return
records) like
currentdb.Execute "update tblCusttomers set city = 'New York' where city =
'N.Y'"
Have you actually tried the sql view of the query builder?
J
J_J
Thank you Albert and Rick,
Albert D.Kallal said:I must be miss-understanding something in the above?
Just type the the sql, and hit the ! to run the sql.....
How is the above not trying your own sql commands?
You can also type sql in the debug window also, but that would be silly
when you got the query builder....
in the debug window, you can execute action queries (that don't return
records) like
currentdb.Execute "update tblCusttomers set city = 'New York' where city =
'N.Y'"
Have you actually tried the sql view of the query builder?
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.members.shaw.ca/AlbertKallal