Digital Workshop

I am writting a publication, and need to know if it is possible for Opus to create tables within MS Access and rename the table to the User's name.

Probably, yes. You can do that over ODBC which is what you'll use for your Opus connection. Though, as there is not an Opus action, you'll have to use the Opus Script method and workout the exact SQL code needed for creating a new table.

If you've not used Scripting for database before, then I'd search the forum as there will be examples relating to connection and sending and receiving data.

</mack>

I've been searching the forum for more than a couple of days with no luck. The best I got was:

$connect = mysql_connect("FILEDSN=C:\Users\Anton\Documents\connection1.dsn;")
$db = mysql_select_db("Candidates Detail",$connect);
$query = "CREATE TABLE employees (FirstName varchar(15),LastName varchar(15),Age int)";
$result = mysql_query($query, $connect);

and

var myDB = new Database("FILEDSN=C:\Users\Anton\Documents\connection1.dsn;")
var Rset = myDB.ExecuteSQL("CREATE TABLE employees (FirstName varchar(15),LastName varchar(15),Age int)")

but both examples did nothing.

Did you check that the connection was sound and that you can do something basic, like select data from an existing table?

I tried a simple example and it worked using:



</mack>

I see know I cant connect to my database using script after publishing, them my DSN is incorrect, I am using the correct path though "FILEDSN=C:\Users\Anton\Documents\connection1.dsn;" is the error is in this line?

var myDB = new Database("FILEDSN=C:\Users\Anton\Documents\connection1.dsn;")

Thank You Mackavi for your time and help, without you I would have never solve this problem.

The correct code is:

var myDB = new Database("FILEDSN=C:\\Backup\\CBT\\Published\\J281 Ross Operators\\Data\\database.dsn");
myDB.ExecuteSQL("CREATE TABLE " + COMMAND_PARAM_2 + " (street varchar(15))");

Glad it's working.

</mack>

I need your help again haha..

I am trying to create a table with the users name and idnumber as the name of the table, the code works fine except when the user's name got a space somewhere then no table will be created in MSACCESS (I don't know why), do do you know the solution to this problem, or how can I force the "loginuser" to leave out all the spaces or be replaced by a underscore



Please help.

Mackavi gave you a solution in your other post on the same/similar topic --- using split and join to replace spaces with underscore characters. e.g., john tachkov ===> john_tachkov

But you probably have to dig a little deeper and monitor what values your variables are carrying when you attempt to CONCATENATE strings.

Suggest you use Debug.trace and examine some of the strings or numbers your fields or variables hold. You will have to go further than just looking at them --- do some tests to ACTUALLY SEE what an arithmatic operation returns, and what a string concatenation returns. You may have to convert some data explicitly to strings... in order to concatenate and achieve the expected output.

Thank you Lar,

using split and join to replace spaces worked like a charm.