Обсуждение: Syntax upgrade problem: from 6.0 to 6.4

Поиск
Список
Период
Сортировка

Syntax upgrade problem: from 6.0 to 6.4

От
mapaquin@cca.qc.ca (Marc Andre Paquin)
Дата:
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

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~