I apparently did something wrong in my modification of the Access Stored Procedures template. I saw the advisory in the comments section of the Template Code to rename the template if I wanted to customize it. I went to the properties slide-out for the Template and changed the name and saved it. It did not seem to be taking effect (I hadn't found the Refresh button yet for the Template Browser), so I tried using the New Guid button, thinking this might be a way to make the system see it as a new template.
My code changes work (I was changing the way it names the procedures) except now all of the column data types are using what appear to be SQL Server types instead of Access types. Here is an example:
- Code: Select all
CREATE PROC upd_Area ( [_AreaID] Long, [_Area] Text, [_Active] Bit, [_Created] DateTime) AS
SET [fstrArea] = [_Area] , [fynActive] = [_Active] , [fdatCreated] = [_Created]
WHERE ([fintAreaID] = [_AreaID])
Notice how it is using data types such as Long, Text, and Bit.
- using the beta 220.127.116.11
- connection set to an Access database
- trying to generate stored procs to save in the database (by the way, saving the procs to the database does not work--I had to create a utility to do this myself)
- the default Access Stored Procedures template was working fine in regard to the data types before I started making the changes described above
- everything looks normal in terms of data types in MyMeta Browser, DbTarget Mappings, and Language Mappings
- the Output Language of the modified Template is still set to \"Jet SQL\"
Where did I go wrong?
I'm going to try next starting with a fresh Access Stored Procedures template if I can figure out a way to get it to pull down a new one from your web site.