Hi.

I've got a problem with the Symbian-DBMS, i can't insert data by SQL.
Well, that's my code:

PHP Code:
TInt CDBase::CreateDB()
{
    
User::LeaveIfError(DBFs.Connect());
    
DBFs.MkDirAll(dbFileName.DriveAndPath());
    
ErrorCode DB.Create(DBFs,dbFileName.FullName());
    if(
ErrorCode != KErrNone)
    {
        
DBError 1;
    }
    else
    {
        
ErrorCode DB.Execute(_L("CREATE TABLE zeit (zID COUNTER, morgens VARCHAR(8), mittags VARCHAR(8), abends VARCHAR(8), nachts VARCHAR(8))"));
        if(
ErrorCode == KErrNone)
        {
            
ErrorCode DB.Execute(_L("CREATE TABLE meds (medname VARCHAR(255))"));
            if(
ErrorCode == KErrNone)
            {
                
ErrorCode DB.Execute(_L("INSERT INTO meds (medname) VALUES ('Schwul')"));
                if(
ErrorCode == KErrNone)
                {
                    
DBError 0;
                }
                else
                {
                    
DBError 1;
                }
            }
            else
            {
                
DBError 1;
            }
        }
        else
        {
            
DBError 1;
        }
    }

    return 
DBError;

At the insert, i'm getting an error. The errorcode is 1.
Please help, would be very kind of you.

Thanks!