jason
Fri Nov 21 15:19:27 CST 2003
Thanks Bob!! I was starting to give up hope there for a moment!
Just with regards definiing characters (and, I will chk online help too - I
assume you mean Microsoft online help?) if I was going to create a simple
query like this:
qry_insert_model
PARAMETERS pModel Text ( 255 );
INSERT INTO tblModel ( Model )
VALUES (pModel);
Would this put me on the right track:
CREATE PROCEDURE qry_insert_model
([pModel] character AS INSERT INTO
tblModel (Model)VALUES ([pModel])
...you see, I am concerned about the data type settings......is 'character'
the same as TEXT(255)?
One last thing: I have used ADO to navigate my online tables:
Dim objADOXDatabase
Set objADOXDatabase = Server.CreateObject("ADOX.Catalog")
objADOXDatabase.ActiveConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" &
Server.MapPath("../../database/listings.mdb")
Dim objTable, objColumn
For Each objTable in objADOXDatabase.Tables
If objTable.Type = "TABLE" then
Response.Write "<font color=red><STRONG>" & objTable.Name &
"</STRONG></font><br>"
For Each objColumn in objTable.Columns
Response.Write " " & objColumn.Name & "<br>"
Next
Response.Write "<p>"
End If
Next
Set objADOXDatabase = Nothing
............But how does one traverse ones queries?
Appreciated!!!
- Jason
- Jason
"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:eI8JgFHsDHA.424@TK2MSFTNGP11.phx.gbl...
> Ray at <%=sLocation%> wrote:
> > "jason" <jason@catamaranco.com> wrote in message
> > news:umWbLbFsDHA.2456@TK2MSFTNGP12.phx.gbl...
> >> Excuse confusion...
> >>
> >> The query analzyer from codetoad works great with simple select and
> >> delete queries.
> >>
> >> However, when it comes to ACTION queries I am at a loss as to how to
> >> CREATE eg:
> >>
> >> 1. A NEW QUERY (eg qry_insert_NewListing)
> >
> > Yeah, I'm not sure how you create queries with SQL in an Access
> > database. Where's Bob Barrows?
>
> You called?
>
> Jet 4.0 supports the use of CREATE VIEW and CREATE PROCEDURE statements. I
> have not been able to get these commands to work using the Access Query
> Builder. However, they seem to work fine when executed via ADO, so your
tool
> may be able to successfully run them. Here's an example:
>
> CREATE PROCEDURE qTest ([parm1] character,[parm2] character) AS INSERT
INTO
> sometable(col1, col2)VALUES ([parm1],[parm2])
>
> For more details see the Microsoft JetSQL help section in the Access
online
> help
>
> HTH,
> Bob Barrows
> --
> Microsoft MVP -- ASP/ASP.NET
> Please reply to the newsgroup. The email account listed in my From
> header is my spam trap, so I don't check it very often. You will get a
> quicker response by posting to the newsgroup.
>
>