beakerman29
New Member
Let the oddity begin....I am able to create a table in a database using the SQL Create Table method. noticed that It doesn't show up in either my data dictionary or for any other user besides the one the one that created it. With that said a query on systables was in order. I did a query and interestingly enough it returns my table with the ODBC user as the creator and the name I specified as the owner. It doesn't matter if the user actually exists in the database for it to set it as the owner. Now if you try as another user to see this table it does not display in there tables but as the original user you can both read and write data to the table. The odd part is that I looked at the systable of my table and another that was working correctly and noticed that the field has_ucnstrs is set to Y in the table that isn't working. Anybody got an idea of what this is and what I might be doing wrong