deletes first & last names from my new records

Archived from the Xataface Users forum.

etgraphicd2 — Fri May 28, 2010 10:24 am

Dataface deletes first and last names from my new records when I click submit to insert new record. And refuses to allow the record to be inserted.
Does anyone know why?

Tried DaDaBIK and it does enter the new record into the database, but it also excludes the info from the first and last name fields.

Any help would be greatly appreciated.

Thanks a lot

---

shannah — Fri May 28, 2010 10:32 am

Can you post the relevant table definition, fields.ini file, and delegate class? It is hard to comment without some more info.

---

etgraphicd2 — Fri May 28, 2010 10:47 am

I am new to xataface…I just used a default installation.
delegate class is whatever is default, I guess.
xataface version 1.2.4
I was trying to edit a standard users listing in MSQL database from xataface app.
where would I find the “delegate class” info to provide to you?

---

shannah — Fri May 28, 2010 12:02 pm

What is the table’s SQL definition?

---

etgraphicd2 — Fri May 28, 2010 12:50 pm

Do you mean alphanumeric settings for those fields?
They are set to Varchar…..alphanumeric.

Is this what you meant?’
Thanks

---

shannah — Fri May 28, 2010 1:00 pm

It should look something like:

Code: Select all

create table users (     user_id int(11) not null auto_increment primary key,    username varchar(32) ... ) ...

---

etgraphicd2 — Fri May 28, 2010 1:16 pm

problem solved… had blank space between “first” and “name” in database table; removed space by inserting underscore “first_name” and did the same for “last_name”.
and it works fine now.