General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Yes, quite a mess. I finally got to see version 6. It still sucks.
Thanks,
Michelle
>That's the least of the kinds of problems you'll run into trying to work with SBT. In my (limited) experience, it's a real mess...
>
>
>>That's it! Thanks. I guess it always worked by coincidence before because I would give the index the same name as the field and never used a compound index before. Dang SBT...
>>
>>Thanks,
>>
>>Michelle
>>
>>
>>>Invno1 isn't a fieldname in arytrn01, is it? It's just the name of an index, right? SET RELATION needs a relation expression, not the index name from the parent table. I think your relation nees to look something like this:
>>>
>>> SET RELATION TO (invno + STR(lineno,4)) INTO temp
>>>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only