Re: InformixIDS9.4 ODBC driver query

Unfortunately I'm writing an application using ODBC and I can't assume that my users are going to create their tables a particular way ... Alex Nebojsa Sevo <DELETE_mips@zg.tel.hr> wrote in message news:<ga74kvsmndcjf9r1ut7378jat2tqpihuu6@4ax.com>... > On 19 Aug 2003 01:07:56 -0700, azp74@hotmail.com (Alex) wrote: > > >> > >> When a constraint is created on a table, Informix will create an > >> underlying index whose first character is a space. The constraint > >> name will be prefaced with a 'u'. > > > >Not what I wanted to hear but thanks anyway! > >Is this documented anywhere? > Sory, I missed original message, but I think that better for you will be to: > 1. create table without constraints > 2. create indexes for your primary, unique and / or foreign key constraints > 3. alter table to create constraints. > > If you that you can give names to your indexes and constraints as you want > > Nebojsa > ------------------------------------ > Remove spam block (DELETE_) to reply

On 21 Aug 2003 00:30:50 -0700, azp74@hotmail.com (Alex) wrote: You are giving to users to create permanent tables?! What sort of application si that? Nebojsa >Unfortunately I'm writing an application using ODBC and I can't assume >that my users are going to create their tables a particular way ... > >Alex > ------------------------------------ Remove spam block (DELETE_) to reply