deletes first & last names from my new records

[etgraphicd2]

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]

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

[etgraphicd2]

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]

What is the table's SQL definition?

[etgraphicd2]

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

Is this what you meant?'
Thanks

[shannah]

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]

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.