Hello,
I have posted a question a week ago concerning a column name problem and you helped
me solve the problem. Hey!
I had to recreate a database that already exist in version 6.0 and transfer data to
6.4
I had tables like this:
(no int4, city varchar(32), country varchar(32))
but the creation of this table on version 6.4 had to be done with:
create table city ("no" int4, city varchar(32), country varchar(32)); (note the "
in "no")
But now that every thing was created and that data has been transferred, all my 3
years programs making html pages with SQL request are crashing... A simple query
with select has the same problem: no must be "no" and of course this is a major
problem. Why don't I have this limitation in version 6.0 (no problem creating or
using column name no). This is terrible when upgrading and finding this kind of
problem... IS THERE A WAY AROUND THIS?
Thank you very much because rebuilding several programs with many hundreds of line
code is crazy!!! (I have my finger crossed!)
--
Marc André Paquin, adjoint au chef T. I.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Centre Canadien d'Architecture | C C A
http://cca.qc.ca
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~