Page 1 of 1

Limit to number of fields in table?

Posted: Wed May 29, 2002 11:07 am
by jkj2001
I've got someone who wants to create a 113(!) column table in Texis. Other than telling him this is really bad database design, are there any limits in Texis which would prevent this from working?

I know there used to be a 50 field limit, if memory serves, don't know if it's still there, or if there are other technical reasons you can give me to pass along to this gent for paring down his field list.

Our texis version is 3.01.992447526. Thanks!

Limit to number of fields in table?

Posted: Wed May 29, 2002 11:50 am
by John
There is no fixed limit to the number of columns in the table, however when doing SELECTs you can currently retrieve 100 at a time into Vortex or the application.

Limit to number of fields in table?

Posted: Wed May 29, 2002 1:26 pm
by jkj2001
Thanks for the info. Just so I'm clear, are you saying that a "select *" statement will retrieve a max of 100 columns?

Also, do you know what the limits are in creating a virtual field-- in terms of the number of fields you can put in there, character limit, etc? If memory serves, there's a limit to how long the virtual field "name" can be.

Thanks again

Limit to number of fields in table?

Posted: Thu May 30, 2002 2:38 pm
by John
You can put as many fields as you want in there. Some early versions of Texis on some platforms were limited to about 70 fields in the virtual field name, which no longer applies.