Creating a CDX table in an ADS data dictionary in XBASE++
Creating a CDX table in an ADS data dictionary in XBASE++
I want to create tables on the fly into a Data dictionary in my app so I don't have to manually create 6 tables every time I add a table. I've tried DBCREATE( ) using the dictionary dacsession but it creates it in the default free table session. I'm trying a CREATE TABLE ...IN DATABASE SQL statement but it's erroring saying the user doesn't have rights, even though the dictionary setting is unrestricted. Is there a way to do this?
Re: Creating a CDX table in an ADS data dictionary in XBASE+
Have you tried making your dictionary user ID AdsSys?
The eXpress train is coming - and it has more cars.
Re: Creating a CDX table in an ADS data dictionary in XBASE+
I will give it a try.
Re: Creating a CDX table in an ADS data dictionary in XBASE+
USER() is 'anonymous.' I added ";user ID = adssys" to my DacSession() connection string. Still comes back 'anonymous.'
I probably can't address this further until Monday.
I probably can't address this further until Monday.
Re: Creating a CDX table in an ADS data dictionary in XBASE+
Skype me on Monday.
The eXpress train is coming - and it has more cars.
Re: Creating a CDX table in an ADS data dictionary in XBASE+
It was syntax in my connection string. ";UID=AdsSys" did the trick. I can now create a table in the dictionary. Thanks, Roger.