Issue 19373 - Autovalue in Forms doesn't work
Summary: Autovalue in Forms doesn't work
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 Beta
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: marc.neumann
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-09-10 09:33 UTC by wnickl
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description wnickl 2003-09-10 09:33:01 UTC 
When generate a form over auto-pilot to a data source witch has a primary key as
auto value the following problem occurs.
You can jump threw the datasets but you can't insert a new dataset.
The following error is shown if you want save a new dataset.

Error writing data to database.
Input required in field 'ID'.
Please enter value.

When you add an new dataset in the Table direct all works fine.

The connected database is MySQL with Data source "MySQL" with Myodbc.
Comment 1 Frank Schönheit 2003-09-10 10:51:41 UTC 
correcting sub component
(http://www.openoffice.org/issues/describecomponents.cgi?component=Database%20access)
and default owner
Comment 2 marc.neumann 2003-09-11 11:34:45 UTC 
hi wnickl,

I have no problem to add new record into a mysql table via a form. I
have tested on Windows XP with myodbc 2.5 and on linux with a myodbc
driver.

What structure has your table?
Is the autovalue field present in the form?
Is the issue still occur in the OOo 1.1 RC4 build?

Thanks in advance
Marc
Comment 3 hans_werner67 2004-02-02 12:19:39 UTC 
change subcomponent to 'none'
Comment 4 marc.neumann 2004-04-27 11:08:00 UTC 
close