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 |
|
|
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 |
|
|
|