CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Hand-Coded Custom Insert

Print topic Send  topic

Author Message
klwillis


Posts: 428
Posted: 06/01/2004, 1:21 PM

Assuming I have . . .

1)A database named DBPersons.
2)A table in the database named Family.
3)Two fields in the Family table - firstname and lastname.

Also, two text control fields, fname and lname, are
used to post the values to be used when inserting
the values for the firstname and lastname database fields.

Using as many of the already defined classes and
functions in Code Charge Studio (2.2.3.60), how could
I most easily hand-code an insert for these two fields fields
into the database?

NOTE:
I need to handcode this since the data will be submitted
and the insert performed on a different form.

Using the custom insert event will not work, since I need
to do this prior to the new page being shown completely.

Ideas on how I can do this best are appreciated. :-)

_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"

Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006
View profile  Send private message
Martin
Posted: 06/03/2004, 11:16 PM

Hello.
Take a look at the Help. (F1)
Examles and Techniques - Programming - Working with Databases -
Execute Custom SQL

You must ad the HandCode in after Insert or after Update from your Form.

sorry about my english

Greets martin
klwillis


Posts: 428
Posted: 06/04/2004, 7:42 AM

Your English is good, but that's not the answer I was looing for.

I don't think this can be done, but a work around is inserting the
data on the first form and then sending the data as session variables
to the second form.

I was trying to get around from using session variables,
but it's more work trying to avoid using them.

_________________
Kevin Willis, VP/CIO
HealthCare Information Technology Specialist
http://www.nexushealthcare.com
"Fast - Convenient - Quality-Care"

Medical Software Consulting Services
Email : klwillis@nexushealthcare.com
Skype : klwillis2006
View profile  Send private message

Add new topic Subscribe to topic   


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

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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