In many years of programming in Vortex, this is the first time I have encountered this problem.
I have created a table containing 141 variables, some with fairly long names (e.g. 16 characters), and many are type varchar(2) (although many of the varchar data content lengths are actually 40 to 60 characters long).
The problem I have encountered is incorrect storage and retrieval of data for a given variable, and it seems sporadic -- some records are correct and some are not. By this I mean that it seems like values are being picked up and stored (or retrieved) from other than the named variable in a given record.
My program is complex, so there's always a chance it's a bug in my program, however, I wondered if I might be bumping some TEXIS table limit like a maximum number of variables in a table, or how many characters a varchar(2) variable can hold, or the length of variable names, etc.
It would be possible (though inconvenient) for me to break this one table into two or more tables if that's the solution.
I'd appreciate any suggestions.
Thanks.
I have created a table containing 141 variables, some with fairly long names (e.g. 16 characters), and many are type varchar(2) (although many of the varchar data content lengths are actually 40 to 60 characters long).
The problem I have encountered is incorrect storage and retrieval of data for a given variable, and it seems sporadic -- some records are correct and some are not. By this I mean that it seems like values are being picked up and stored (or retrieved) from other than the named variable in a given record.
My program is complex, so there's always a chance it's a bug in my program, however, I wondered if I might be bumping some TEXIS table limit like a maximum number of variables in a table, or how many characters a varchar(2) variable can hold, or the length of variable names, etc.
It would be possible (though inconvenient) for me to break this one table into two or more tables if that's the solution.
I'd appreciate any suggestions.
Thanks.