Joomla! Discussion Forums

Hi,

I am currently trying to create a component that wont use incremental ids.
Is it possible to use the typical Store, bind and load functions of the database?

I am having quite troubles in using those functions. Should i have to make something customizable for varchar keys and non incremental?


Imagine my table contains two fields... code varchar(50) and description varchar (100)

How could i make the save function of my component?



Cheers

No, you won't be able to use the typical store method.  You will have to write your own to update the data.  Assume you have some sort of index on the table you could use a REPLACE INTO statement rather than INSERT and UPDATE's.  Hope this helps.

REPLACE INTO?? Can you give an example?

What about BIND and CHECK methods?

Regards

Ok, bind and check will still work fine.  You just need to override the store method.  Use whatever methods you are comfortable with but I was just suggesting to research REPLACE INTO (http://dev.mysql.com/doc/refman/5.0/en/replace.html) as I find this useful for database table that do not have your regular single primary key.

If your "code" field is a primary key but not an auto-increment then it's probably still a good case for using REPLACE into.  Go as far as you can and then post the code for your Table class and I'll see if I can help more (will be out all day today though so will be tomorrow before I can reply).

Ok so i have my $row variable populated... What can i do now?

Instead of doing $row->store() what about now?

Regards

Can you post the code of your Table class please.

class tabela extends mosDBTable{


  var key = null;
  var description = null;

  function mosTabela (&$db){
    $this->mosDBTable('#__tabela', 'key', $db);
  }
}

No one can help on this issue?
Please


Regards