CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 What wrong with this code

Print topic Send  topic

Author Message
Tuong Do
Posted: 07/22/2002, 7:20 PM



Function EMPLOYER_AfterInsert() 'EMPLOYER_AfterInsert @2-98859DC0

'Custom Code @10-73254650
' -------------------------
CCExecSQL ("update db2admin.member set surname='test' where
member_id=1",Connection1,true)
' Write your own code here.
' -------------------------
'End Custom Code

End Function 'Close EMPLOYER_AfterInsert @2-54C34B28




And the error message is

Technical Information (for support personnel)

a.. Error Type:
Microsoft VBScript compilation (0x800A0414)
Cannot use parentheses when calling a Sub
/test1/EMPLOYER_maint_events.asp, line 12, column 90
CCExecSQL ("update db2admin.member set surname='test' where
member_id=1",Connection1,true)
--------------------------------------------------------------------------
---------------^



DonB
Posted: 07/23/2002, 4:13 AM

It is a "function" not a "sub" so try

Dim strRetVal
strRetVal = CCExecSQL(...)


Tuong Do
Posted: 07/23/2002, 4:21 PM

Thanks Don

"DonB" <7432D63DBB01D03A196B1EDD80E8@comcast.net> wrote in message
news:ahjdpn$mpo$1@news.codecharge.com...
> It is a "function" not a "sub" so try
>
> Dim strRetVal
> strRetVal = CCExecSQL(...)
>
>
>


   


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

MS Access to Web

Convert MS Access to Web.
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.