Re: [dba-dev] No saving of form data when inserted into controls with api-commands

2007-05-16 Thread Frank Schönheit - Sun Microsystems Germ any
Hello Peter, the wide variety of answers here show that the concepts are clearly too ... complex. in a form which is connected to a server db I filled some text fields with api. The content of these fields are not saved by clicking the Save record-button. Only typing or pasting seems to

Re: [dba-dev] Self-referencing foreign keys

2007-05-16 Thread Frank Schönheit - Sun Microsystems Germa ny
Hello Dany, I was trying to create a foreign key in a table that references its own primary key. The UI for Relationships does not seem to allow this. Is this feature supported at the moment? If not, is there a workaround? or will it be supported in the future? No. Yes. Perhaps. The

Re: [dba-dev] Confusion in MySql driver limitations Base 2.0.n

2007-05-16 Thread Frank Schönheit - Sun Microsystems Germa ny
Hello Mike, I'm using com.mysql.jdbc.Driver, version 5.0.5, from the MySQL website, mysql-connector-java-5.0.5-bin.jar I only get back an error message under Tools Relationships that says: The Database does not support Relationships, But MySQL does support relationships, so is this

Re: [dba-dev] Queries in Base

2007-05-16 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Dan, Maybe I do not understand SQL well enough, but I have a problem. I have a table for fuel that I buy as well as the odometer reading when it is bought. I would like to calculate the fuel economy (quantity of fuel divided by the distance traveled). How do I subtract the

Re: [dba-dev] No saving of form data when inserted into controls with api-commands

2007-05-16 Thread Peter Eberlein
Hi, Thanks to Mathias, Andrew and last but not least Frank for your detailed explanations. Regards Peter - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dba-dev] Confusion in MySql driver limitations Base 2.0.n

2007-05-16 Thread Alex Thurgood
Hi Mike, But MySQL does support relationships, so is this error mal formed? Has this been solved and I'm doing something wrong in driver permissions? Is there a workaround besides hard-coding updates by Macro or other? Is there a solution planned in the future, if there is no present

Re: [dba-dev] Confusion in MySql driver limitations Base 2.0.n

2007-05-16 Thread Alex Thurgood
Le samedi 28 avril 2007 20:MM, [EMAIL PROTECTED] a écrit : Doh !!! Forget my last e-mail Mike, didn't look at the OP until after I sent it - of course, you are one and the same. Sorry :-) Alex - To unsubscribe, e-mail: [EMAIL

Re: [dba-dev] No saving of form data when inserted into controls with api-commands

2007-05-16 Thread Marc Santhoff
Am Mittwoch, den 16.05.2007, 10:09 +0200 schrieb Frank Schönheit - Sun Microsystems Germany: Mathias' suggestion gets the most points :). The BoundField property of the control model refers to the database field which the control is bound to. Modifying this one is, speaking strictly, the only

Re: [dba-dev] Queries in Base

2007-05-16 Thread Dan Lewis
On Wednesday May 16 2007 4:23 am, Frank Schönheit - Sun Microsystems Germany wrote: Hi Dan, Maybe I do not understand SQL well enough, but I have a problem. I have a table for fuel that I buy as well as the odometer reading when it is bought. I would like to calculate the fuel

Re: [dba-dev] Interested in a New Report Designer? View GullFOSS

2007-05-16 Thread Ocke Janssen Sun Microsystems
Hi all, It's time agin to read GullFOSS http://blogs.sun.com/GullFOSS/entry/new_first_developer_snapshot_of There you'll find the link to the developer snapshot of the new report designer. Give it a try and submit issues ;-) Best regards, Ocke Ocke Janssen Sun Microsystems wrote: Hi all,

Re: [dba-dev] Queries in Base

2007-05-16 Thread andrew
Dan Lewis wrote: On Wednesday May 16 2007 4:23 am, Frank Schönheit - Sun Microsystems Germany wrote: Hi Dan, Maybe I do not understand SQL well enough, but I have a problem. I have a table for fuel that I buy as well as the odometer reading when it is bought. I would like to