From 2570226fbac3e26b1e94896b50d1db4bc1aa3308 Mon Sep 17 00:00:00 2001 From: wei <> Date: Sun, 17 Dec 2006 22:20:50 +0000 Subject: Add TDataSourceConfig, TSqlMapConfig, TActiveRecordConfig --- demos/sqlmap/protected/App_Data/person.xml | 29 ++++++++++++++-- demos/sqlmap/protected/App_Data/personHelper.xml | 42 ----------------------- demos/sqlmap/protected/App_Data/test.db | Bin 5120 -> 3072 bytes 3 files changed, 26 insertions(+), 45 deletions(-) delete mode 100644 demos/sqlmap/protected/App_Data/personHelper.xml (limited to 'demos/sqlmap/protected/App_Data') diff --git a/demos/sqlmap/protected/App_Data/person.xml b/demos/sqlmap/protected/App_Data/person.xml index 4ffe44d9..b5b94175 100644 --- a/demos/sqlmap/protected/App_Data/person.xml +++ b/demos/sqlmap/protected/App_Data/person.xml @@ -1,5 +1,6 @@ - + + - \ No newline at end of file + + insert into PERSON + (PER_FIRST_NAME, PER_LAST_NAME, PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M) + values + (#FirstName#, #LastName#, #BirthDate#, #WeightInKilograms#, #HeightInMeters#) + + + + update PERSON set + PER_FIRST_NAME = #FirstName#, + PER_LAST_NAME = #LastName#, + PER_BIRTH_DATE = #BirthDate#, + PER_WEIGHT_KG = #WeightInKilograms#, + PER_HEIGHT_M = #HeightInMeters# + where PER_ID = #ID# + + + + delete from PERSON + where PER_ID = #value# + + + diff --git a/demos/sqlmap/protected/App_Data/personHelper.xml b/demos/sqlmap/protected/App_Data/personHelper.xml deleted file mode 100644 index ea2d4302..00000000 --- a/demos/sqlmap/protected/App_Data/personHelper.xml +++ /dev/null @@ -1,42 +0,0 @@ - - - - - - - - insert into PERSON - (PER_ID, PER_FIRST_NAME, PER_LAST_NAME, - PER_BIRTH_DATE, PER_WEIGHT_KG, PER_HEIGHT_M) - values - (#ID#, #FirstName#, #LastName#, - #BirthDate#, #WeightInKilograms#, #HeightInMeters#) - - - - update PERSON set - PER_FIRST_NAME = #FirstName#, - PER_LAST_NAME = #LastName#, - PER_BIRTH_DATE = #BirthDate#, - PER_WEIGHT_KG = #WeightInKilograms#, - PER_HEIGHT_M = #HeightInMeters# - where PER_ID = #ID# - - - - delete from PERSON - where PER_ID = #value# - - - diff --git a/demos/sqlmap/protected/App_Data/test.db b/demos/sqlmap/protected/App_Data/test.db index a40c91fe..8778160a 100644 Binary files a/demos/sqlmap/protected/App_Data/test.db and b/demos/sqlmap/protected/App_Data/test.db differ -- cgit v1.2.3