Multi Tables in DBMS
Login to reply to this topic.
Sat, 2006-04-29 03:25
Joined: 2005-04-21
Forum posts: 3
Hi,all.
I used a SQL statement to create a table calledWVTable1 in a database and also other tables.
Then I want to open the table WVTable using the function Open() defined in RDbTable,but the variable err return -1 and leave.
I don't know why,and i want some help.
Thanks in advance

Code:
//SQLString for create a table
_LIT(KSQLWVTable1,"CREATE TABLE WVTable1 (time DATE, POSITIVE UNSIGNED TINYINT,
ACCOUNT UNSIGNED INTEGER,MESSAGE LONG VARCHAR");


//open a table
RDbTable table;
[color=Red]TInt err = table.Open(iRecordstoreDb, _L("WVTable1"));[/color]

Best regards

lengyuecau


copyright 2003-2009 NewLC SARL