Much thanks for the intro, Vic. I am excited to put this into action.
Randy
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Friday, August 28, 2009 12:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ASP versus ASP.net
Randy,
Glad you like it. It's a super product... I knew zero about ASP and was
able to get up to speed quickly with it.
To answer your questions regarding ASPRunner...
1) The only location that I know where I can see the literal SQL query
is on the Query Designer page and there is a secondary tab at the top
where you can see the query and also the results.
2) I haven't modified any ASP code only because I guess I really never
needed to and I'm an ASP novice. But I have modified the underlying HTML
code. On the Visual Editor screen, on the toolbar at the top you can
flip between Design Mode and HTML mode. I've used the HTML editor to
insert a metatag that auto refreshes my webpage every X minutes. Also up
there on that toolbar you will see "Insert ASP Code Snippet". Perhaps
that'll work for you. Also in the Visual Editor you can click on any
field and set custom properties for individual fields.... For example if
the dollar amount is negative, change the font color to RED and bold it.
And on the last screen you can put code snippets in on certain events.
It's very flexible.
3) Yes, I've used Edit and Add. I have a few UD tables that I populate
from the ASP page and then I have a SQL script that grabs those records
and populates the proper Vantage tables on an hourly basis. It's safer.
I've also created an entire HAZMAT interface for Vantage using the
ASPRunner. I directly update/modify (no Add) the PART table *BUT* only
non-critical fields like some UD fields and other Hazmat related fields.
I would NOT recommend doing things like adding new parts, jobs,
contacts, etc with this as it's completely circumventing all Vantage
business logic.
Lastly, your SQL query is always better engineered when you do a JOIN on
Field=Field vs. using a Where clause as it only returns results from the
joined table that it needs vs the SQL engine having to process the Where
clause after the result set is returned. Albeit, the difference is very
insignificant in regards to performance with most of our databases but
if you had a 10 million row table joined to a 8 million row table then
you'd see a difference. But if you use sub-selects instead of JOINS then
you have no choice but to use Where clauses. For example:
Select JobNum, PartNum, (select sum(OhQty) from PartPlant PP where
PP.Partnum = JH.Partnum) from JobHead JH
I oftentimes prefer to use Subselects vs right or left joins. It's a
subjective preference. :-)
Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@... <mailto:vic.drecchio%40timco.aero>
Mobile: 704.530.3092
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Randy Weber
Sent: Friday, August 28, 2009 11:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ASP versus ASP.net
To Vic and all who previously replied to my ASP question.
Vic, Thanks - ASPRunnerPro is awesome. I will likely purchase it. I have
some questions if you please:
1- I was hoping to use it to help me generate some queries that I
would then paste into my own ASP Pages to give me a bit more control
over the page layout. Yet, after creating some ASP pages, I cannot find
a single line of code that has the queries. Do you know where they are?
2- Have you ever modified the code on an ASPRunner generated ASP
Page?
3- Have you dared to use Edit or Add with this? I tested it in ABC
table and it worked, but I think it would be dangerous to try anything
such as order entry considering all the work it would take to insure
data integrity.
Regarding some of the posts with SQL. Which is faster/better for
joining: "JOIN On field=field" or Where field = field.
Randy Weber
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Wednesday, August 26, 2009 11:52 AM
To: Randy Weber
Cc: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ASP versus ASP.net
Randy,
I have SQL Vantage.
I extensively use ASP for the exact reasons you list.
I've purchased ASPRunnerPro and it's been the best purchase I've ever
made. (www.xlinesoft.com). It's saved me so much time and you have a
professional, slick looking product within minutes. You can download a
trial for free.
If you are SQL I have some queries that I will share that I've turned
into SQL Views.
Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@... <mailto:vic.drecchio%40timco.aero>
<mailto:vic.drecchio%40timco.aero>
Mobile: 704.530.3092
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Randy Weber
Sent: Wednesday, August 26, 2009 12:34 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ASP versus ASP.net
V8.03.407C
I am just starting to use ASP to create some views of a variety of data
such as Part info, Customers, Orders, etc. I like using ASP because I am
familiar with the code and because I can easily allow any pc with a
browser to view lots of data quickly and with little training.
I am curious if anybody has done some extensive ASP queries that they
would like to share or if they are already posted. I looked in the files
area but did not see any ASP code.
I'd also like to hear from anybody who is using ASP extensively (with or
without supplying code) - what views do you provide? Are you linking
from one data result to another. Do you have any tricks for generating
ASP other than typing code.
Thanks in advance,
Randy Weber
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
Randy
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Vic Drecchio
Sent: Friday, August 28, 2009 12:23 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] ASP versus ASP.net
Randy,
Glad you like it. It's a super product... I knew zero about ASP and was
able to get up to speed quickly with it.
To answer your questions regarding ASPRunner...
1) The only location that I know where I can see the literal SQL query
is on the Query Designer page and there is a secondary tab at the top
where you can see the query and also the results.
2) I haven't modified any ASP code only because I guess I really never
needed to and I'm an ASP novice. But I have modified the underlying HTML
code. On the Visual Editor screen, on the toolbar at the top you can
flip between Design Mode and HTML mode. I've used the HTML editor to
insert a metatag that auto refreshes my webpage every X minutes. Also up
there on that toolbar you will see "Insert ASP Code Snippet". Perhaps
that'll work for you. Also in the Visual Editor you can click on any
field and set custom properties for individual fields.... For example if
the dollar amount is negative, change the font color to RED and bold it.
And on the last screen you can put code snippets in on certain events.
It's very flexible.
3) Yes, I've used Edit and Add. I have a few UD tables that I populate
from the ASP page and then I have a SQL script that grabs those records
and populates the proper Vantage tables on an hourly basis. It's safer.
I've also created an entire HAZMAT interface for Vantage using the
ASPRunner. I directly update/modify (no Add) the PART table *BUT* only
non-critical fields like some UD fields and other Hazmat related fields.
I would NOT recommend doing things like adding new parts, jobs,
contacts, etc with this as it's completely circumventing all Vantage
business logic.
Lastly, your SQL query is always better engineered when you do a JOIN on
Field=Field vs. using a Where clause as it only returns results from the
joined table that it needs vs the SQL engine having to process the Where
clause after the result set is returned. Albeit, the difference is very
insignificant in regards to performance with most of our databases but
if you had a 10 million row table joined to a 8 million row table then
you'd see a difference. But if you use sub-selects instead of JOINS then
you have no choice but to use Where clauses. For example:
Select JobNum, PartNum, (select sum(OhQty) from PartPlant PP where
PP.Partnum = JH.Partnum) from JobHead JH
I oftentimes prefer to use Subselects vs right or left joins. It's a
subjective preference. :-)
Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@... <mailto:vic.drecchio%40timco.aero>
Mobile: 704.530.3092
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Randy Weber
Sent: Friday, August 28, 2009 11:51 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ASP versus ASP.net
To Vic and all who previously replied to my ASP question.
Vic, Thanks - ASPRunnerPro is awesome. I will likely purchase it. I have
some questions if you please:
1- I was hoping to use it to help me generate some queries that I
would then paste into my own ASP Pages to give me a bit more control
over the page layout. Yet, after creating some ASP pages, I cannot find
a single line of code that has the queries. Do you know where they are?
2- Have you ever modified the code on an ASPRunner generated ASP
Page?
3- Have you dared to use Edit or Add with this? I tested it in ABC
table and it worked, but I think it would be dangerous to try anything
such as order entry considering all the work it would take to insure
data integrity.
Regarding some of the posts with SQL. Which is faster/better for
joining: "JOIN On field=field" or Where field = field.
Randy Weber
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Vic Drecchio
Sent: Wednesday, August 26, 2009 11:52 AM
To: Randy Weber
Cc: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] ASP versus ASP.net
Randy,
I have SQL Vantage.
I extensively use ASP for the exact reasons you list.
I've purchased ASPRunnerPro and it's been the best purchase I've ever
made. (www.xlinesoft.com). It's saved me so much time and you have a
professional, slick looking product within minutes. You can download a
trial for free.
If you are SQL I have some queries that I will share that I've turned
into SQL Views.
Vic Drecchio
ERP Administrator
TIMCO Aviation Services
Greensboro, NC
Email: vic.drecchio@... <mailto:vic.drecchio%40timco.aero>
<mailto:vic.drecchio%40timco.aero>
Mobile: 704.530.3092
-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of Randy Weber
Sent: Wednesday, August 26, 2009 12:34 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] ASP versus ASP.net
V8.03.407C
I am just starting to use ASP to create some views of a variety of data
such as Part info, Customers, Orders, etc. I like using ASP because I am
familiar with the code and because I can easily allow any pc with a
browser to view lots of data quickly and with little training.
I am curious if anybody has done some extensive ASP queries that they
would like to share or if they are already posted. I looked in the files
area but did not see any ASP code.
I'd also like to hear from anybody who is using ASP extensively (with or
without supplying code) - what views do you provide? Are you linking
from one data result to another. Do you have any tricks for generating
ASP other than typing code.
Thanks in advance,
Randy Weber
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
------------------------------------
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]