Hi,
I want to create a stored procedure that will create a set of tables depending on the parameter. However, I found that I am having problem to run create table command within create procedure command. eg.
create procedure CreateTable ();
begin
create table t1 (c1 integer);
end;
I have not problem running create procedure without create table command. I can run create table command by itself (ie. no other commands and no semi-colon) without problem. However, it complaint if I put them together.
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager][SPEng]3: 'create': Syntax error
Ultimately, I would like to do something like this:
create procedure CreateTable (in :strName char(6));
beging
create table strNameA (...);
create table strNameB (...);
...
end;
Anyone can help me finding a solution? thanks!
-- llam
I want to create a stored procedure that will create a set of tables depending on the parameter. However, I found that I am having problem to run create table command within create procedure command. eg.
create procedure CreateTable ();
begin
create table t1 (c1 integer);
end;
I have not problem running create procedure without create table command. I can run create table command by itself (ie. no other commands and no semi-colon) without problem. However, it complaint if I put them together.
[Pervasive][ODBC Client Interface][LNA][Pervasive][ODBC Engine Interface][Data Record Manager][SPEng]3: 'create': Syntax error
Ultimately, I would like to do something like this:
create procedure CreateTable (in :strName char(6));
beging
create table strNameA (...);
create table strNameB (...);
...
end;
Anyone can help me finding a solution? thanks!
-- llam