Re: Informix and 255 fields

pmckenzie@primeco.com wrote: > > I have a table that contains more than 255 fields. Access can not access more > than 255 fields. Is there any form of a select statement where I can select > field[1] to field[x]. > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Not sure exactly what the problem is, but a variant on other suggestions is: SELECT field1||field2 as field_joined ... (not sure which version this || came in, after 4.0 for sure) This allows you to assemble fields so you can get the information out of more than 255 fields back to Access, where you can no doubt disassemble them. If Access is giving you problems, had you considered using another front-end program? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 -- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/