OpenEuphoria

db_insert/db_create_table/db_select_table

• Posted by rubis at fem.unicamp.br Jun 15, 2002
• 451 views

I just discovered that the command (db_create_table) didn't set the current 
table in a euphoria database as it says in the database.htm document. It 
needs the command db_select_table before any db_insert, or else I will get 
a missing variable key_pointer.

As I lost some hours trying to discover what was going wrong, I think this 
is a good idea to share.

This does not work:

include database.e
integer db
db=db_create("banana.edb",DB_LOCK_NO)
db= db_open("banana.edb",DB_LOCK_NO)
db_create_table("table")
db_insert(x1,x2)



but this works:

include database.e
integer db
db=db_create("banana.edb",DB_LOCK_NO)
db= db_open("banana.edb",DB_LOCK_NO)
db_create_table("table")
db_select_table("table")
db_insert(x1,x2)


Please, correct me if I'm wrong.
bye

Rubens