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.
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.
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.
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.
