create_sbme1table_from_db1table

I'm trying to use this function to copy a table definition from one
sbme1 file to another.  I'm getting error 6 (UDP Error) and that
starts me thinking that if I need to serve this file.  I thought the
db1util functions would work on sbme files also.  Do they have to be
served as PPCS to use this function?

Additionally, I guess I will have to debug the db1util project to see
what is happening.  Where do I find tabelemanagement.sma so I can do
that? It has a red X on that file in the project view window and I
cannot find it anywhere.  

Also, how do I add thise files to the current project so that I can
trace through from my app into create_sbme1table_from_db1table.  Do I
just add the additional sma files to my project?

Hello Niel,
Thanks for the speedy and comprehensive response.  I have not seen the
email yet.  Could it be you did not remove the NOSPAM from my usenet
email addy?

-Dan

On Fri, 10 Aug 2007 13:40:09 +0100, Neil Robinson <neil@simpol.com>
wrote:

>Dan Jinks wrote:
>> I'm trying to use this function to copy a table definition from one
>> sbme1 file to another.  I'm getting error 6 (UDP Error) and that
>> starts me thinking that if I need to serve this file.  I thought the
>> db1util functions would work on sbme files also.  Do they have to be
>> served as PPCS to use this function?
>
>No. The error you are getting is a locking error. If you look at the
>source of the db1util.sma, at the top you will see that error 6 is
>iIMEX_ERR_SBMEOBJLOCKED. This is only output at the point where the
>function attempts to lock the target SBM file. I have updated this code
>just now to only attempt to lock if it is unlocked, and to only unlock
>if it had to lock. I am also sending you the tablemanagement.sma via
>email. It will be in the next release. Unfortunately, although it was
>added to the project, it was not added to the install script.
>
>> Additionally, I guess I will have to debug the db1util project to see
>> what is happening.  Where do I find tabelemanagement.sma so I can do
>> that? It has a red X on that file in the project view window and I
>> cannot find it anywhere.  
>
>See your email.
>
>> Also, how do I add thise files to the current project so that I can
>> trace through from my app into create_sbme1table_from_db1table.  Do I
>> just add the additional sma files to my project?
>
>To debug an SML that you are using in your project, and for which you
>have the source, just go to the project head in the tree, right click on
>the *.smj file in Project View. Select the "Import Modules from
Project"
>item, and then click on the *.smj of the project source for the SML.
>That will add it to the modules below in the tree, and will allow you to
>set break points and inspect variables and such as if it were part of
>the project. It won't let you make changes to the source of the imported
>project however.
>
>Ciao, Neil

Dan Jinks wrote:
> I'm trying to use this function to copy a table definition from one
> sbme1 file to another.  I'm getting error 6 (UDP Error) and that
> starts me thinking that if I need to serve this file.  I thought the
> db1util functions would work on sbme files also.  Do they have to be
> served as PPCS to use this function?

No. The error you are getting is a locking error. If you look at the
source of the db1util.sma, at the top you will see that error 6 is
iIMEX_ERR_SBMEOBJLOCKED. This is only output at the point where the
function attempts to lock the target SBM file. I have updated this code
just now to only attempt to lock if it is unlocked, and to only unlock
if it had to lock. I am also sending you the tablemanagement.sma via
email. It will be in the next release. Unfortunately, although it was
added to the project, it was not added to the install script.

> Additionally, I guess I will have to debug the db1util project to see
> what is happening.  Where do I find tabelemanagement.sma so I can do
> that? It has a red X on that file in the project view window and I
> cannot find it anywhere.  

See your email.

> Also, how do I add thise files to the current project so that I can
> trace through from my app into create_sbme1table_from_db1table.  Do I
> just add the additional sma files to my project?

To debug an SML that you are using in your project, and for which you
have the source, just go to the project head in the tree, right click on
the *.smj file in Project View. Select the "Import Modules from
Project"
item, and then click on the *.smj of the project source for the SML.
That will add it to the modules below in the tree, and will allow you to
set break points and inspect variables and such as if it were part of
the project. It won't let you make changes to the source of the imported
project however.