Re: Re[2]: Puzzling ODBC Error ...
You can get around that by creating a constraint after creating the index.
That way the index will have a name.
Koen.
-----Original Message-----
From: sujata_soman_at_omm-la2-infotech-001@internet.omm.com
<sujata_soman_at_omm-la2-infotech-001@internet.omm.com>
To: informix-list@rmy.emory.edu <informix-list@rmy.emory.edu>;
koen.vanderelst@advalvas.be <koen.vanderelst@advalvas.be>
Date: donderdag 9 oktober 1997 22:20
Subject: Re[2]: Puzzling ODBC Error ...
}
} The biggest problem with this is that dbschema does not report this
} index. I've been having this problem with a software called Data
} Architect, which generates indexes on the informix database. These
} indexes are given random numbers as names.
} So, I agree, give your indexes a name, atleast makesure that they
} start with a non-blank character. ( By the way, a direct create index
} on informix will not allow anything else )
}
} Sujata
}
}
}______________________________ Reply Separator
_________________________________
}Subject: Re: Puzzling ODBC Error ...
}Author: "Koen Van der Elst" <koen.vanderelst@advalvas.be> at internet
}Date: 10/8/97 11:34 PM
}
}
}Another nice feature of MS-ACCES 2 is that it freaks out on indexes wich
are
}not names.
}When you issue a create index statement, informix generates a name that
}starts with a blank. Give your indexes a name!
}
}Koen
}
}
}
}
}