CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 Launching a CCS app using vbscript

Print topic Send  topic

Author Message
Gavin Davidson
Posted: 11/18/2003, 5:32 PM

Hi,

Forgive me if this is a stupid question, but here goes.

Right now I do all my development work in Access and mainly work to do
add-ons for another software package. Once I have developed my access app I
am able to launch it from the other software package and pass information
through to it using something like this:

Option Explicit
Main
Private Sub Main
Dim appAccess, strOrder, strReceiver
StrOrder = ORDER_ID
StrReceiver = RECEIVER_ID
IF strReceiver = "" or isnull(strReceiver) then
if MsgBox("Unable to continue! Select a valid Receiver!",vbExclamation +
vbOkOnly, "Selection")= vbOk then
end if
ELSE
Set appAccess = CreateObject("Access.Application.9")
appAccess.OpenCurrentDatabase "C:\Visual\WizCode_DATCABLE.mdb", False
appAccess.Run "Do_the_job", StrOrder, StrReceiver
appAccess.Visible = True
Set appAccess = Nothing
END IF
End Sub

This basically passes the order id and receiver id to my access app so I can
use them again there without the user having to re-enter them.

So the question is, can I do the same sort of thing with a codecharge
developed app? Would it matter what language it was published in?

Thanks


__________________________________________________________________
Gavin Davidson
Cage Technologies Inc.
ICQ#: 148828879

Current ICQ status:
( Work Tel#: 416-720-5192
+ More ways to contact me
__________________________________________________________________

DonB
Posted: 11/18/2003, 7:58 PM

You can have your CCS application write to the Access database and save the
data values. Or you could write some code in a before show event of a CCS
page to pull values from the database and "do something" with them. Or in
the simplest case, define a CCS page with a form linked to the table where
those values are stored and display them on the form.

In any event, you want to think outside of the "Access" model - the purpose
of CCS is to have a client web browser interacting with a database (still
can be Access) on another computer. You generate code with CCS that reads
and writes the database, forming html pages that pass out to the client
browser, altogether different from the way you are used to working with
Access applications (which execute entirely on one computer).

You seem to be describing "state" information (transient data values that
persist and get shared between applications). You can do a similar sort of
thing with web apps like CCS, by creating "Session variables" that exist for
some period of time that you determine, and these allow you to pass data
values between pages of the web application (think of a web page as being
one of your applications and you'd be pretty close to doing the same thing
in either case).

--
DonB

http://www.gotodon.com/ccbth


"Gavin Davidson" <gavin@cagetechnologies.com> wrote in message
news:bpeh76$kg3$1@news.codecharge.com...
> Hi,
>
> Forgive me if this is a stupid question, but here goes.
>
> Right now I do all my development work in Access and mainly work to do
> add-ons for another software package. Once I have developed my access app
I
> am able to launch it from the other software package and pass information
> through to it using something like this:
>
> Option Explicit
> Main
> Private Sub Main
> Dim appAccess, strOrder, strReceiver
> StrOrder = ORDER_ID
> StrReceiver = RECEIVER_ID
> IF strReceiver = "" or isnull(strReceiver) then
> if MsgBox("Unable to continue! Select a valid Receiver!",vbExclamation +
> vbOkOnly, "Selection")= vbOk then
> end if
> ELSE
> Set appAccess = CreateObject("Access.Application.9")
> appAccess.OpenCurrentDatabase "C:\Visual\WizCode_DATCABLE.mdb", False
> appAccess.Run "Do_the_job", StrOrder, StrReceiver
> appAccess.Visible = True
> Set appAccess = Nothing
> END IF
> End Sub
>
> This basically passes the order id and receiver id to my access app so I
can
> use them again there without the user having to re-enter them.
>
> So the question is, can I do the same sort of thing with a codecharge
> developed app? Would it matter what language it was published in?
>
> Thanks
>
>
> __________________________________________________________________
> Gavin Davidson
> Cage Technologies Inc.
> ICQ#: 148828879
>
> Current ICQ status:
> ( Work Tel#: 416-720-5192
> + More ways to contact me
> __________________________________________________________________
>
>


   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Web Database

Join thousands of Web developers who build Web applications with minimal coding.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.