SQL Power Software Forum

It was not that the tables do not exist caused the problem, the engine try to check existence of the table first, then create them, but if you have other problem(i.e. connection problem, privilege problem etc.), the error message of checking somehow show in the log file, could you explain/check the connection problem at the top first? could you manually create the temp table? turn on the debug mode, run it again, check both log file and error file.

I hope Mario and Ovidiu don't drive in the Wonderland!

the odbc version of the match maker works with SQL serer and DB2, I don't think that will work with the PostgreSQL.

was there any error message when you tried to modify/add record on the 'Table/File format definitions' screen? or it liked just freezing no matter how do you click. can you change the column data-type/format?

on the 'data mapping' screen, if you have mapped all output columns, you may not be able to add/modify the output map item anymore, but you should be able to try to add new row to the mapping grid, just no output column available for you to choose, and you should be able to modify the the input part of the mapping, can you do those 2 ? just to make sure I understand the problem.
after all, you can check the 'refresh pl schema' and 'refresh db schema' boxes on the login screen, that may help.

as the subject

so, let's clarify the problem by using the right window titles, since your outputs are files, could you enter new row on the file format screen (window title 'Table/File format definitions'), or do you have any row here at all? could you enter new row on the 'data mapping' screen? if you have successfully read the input table (defined the input and clicked save button), and you have unmapped output fields (you have the defined/generated the file format and clicked the save button), you should be able to add new mapping row, otherwise no.

could you post your input and output information here?

I will take a look at the console next time I have the laptop.

It's the 2nd case, a while ago, I needed to setup a laptop to show the dashboard, the browser was I.E. 7, the area where the applet should be in just a white rectangle, in the I.E. setting, 'use jre xxx for applet' is checked.
then I try to install firefox, but it required some admin privs to let firefox use jre/applet( don't remember what was it, but since firefox is not really an option, I don't want to get down to that).

as the subject

I could not reproduce the problem, need more info here.
and what's the name of the duplicated transaction? and can you make sure there is no transaction named: 'MYNEXT_TEST' anywhere in your schema?

Prodoc wrote:This probably isn't really a bug, just a feature not implemented. I would second it as a request for enhancement

I think it's a bug because it works if you login as admin user.

This is a note to all of us about the problem that was posted here:

http://www.sqlpower.ca/forum/posts/list/1610.page

turned out this is a connection problem, instead of a engine's. The system was windows2003 (I think that could be any windows system). there were 2 ODBC setup shared the same name, but pointed to 2 different sybase databases, somehow, when we login from different system user id, the ODBC driver manager loaded different setup for that connection, It was very hard to notice the cause of the problem because the difference is only on the port number, and the port number is not a connection meta-data that you can read it back in a ODBC program.

So, be careful, when you have strange table count problem, think the connection!

P.S. I still can't believe how can MS let something like that happened.

not sure if this is the right place to post it, but could not think of a better place. anyway, here it's: on the left panel of the download page, the link is pointing to:
http://www.sqlpower.ca/page/architect_download_template
which will make the title on the download page wrong, maybe we can just simply remove the link on the left.

It will be nice if we can see the sample of the table content, i.e. right click on the table name, in the pop-up menu, add a new item for table content. then in the table view, we can add content filter, export content etc.