Re: [dba-users] Report Builder documentation

2007-10-04 Thread Drew Jensen
Manuel NAUDIN wrote: Hello, I'm looking for a comprehensive documentation of the report builder extension. The only documentation i have found is : http://wiki.services.openoffice.org/wiki/SUN_Report_Builder and a few explanations in the OOo help but would appreciate something with more

[dba-users] A laugh to start the day - was - Re: [dba-users] Report Builder documentation

2007-10-05 Thread Drew Jensen
Ocke Janssen - Sun Microsystems Inc. wrote: What should I say. :-) Today I slept a little bit longer and started at 7:15 o'clock. Sorry.:-) - oj Sleeping in is a good thing.. OK - an OT quick story, just to give you a little laugh to end the week. Got to the business of actually moving

Re: [dba-users] Calculated fields in report with Report Builder?

2007-10-09 Thread Drew Jensen
Damn...I wrote almost that identical function..but forget and used commas Aging is a terrible thing...LOL Ocke Janssen wrote: Hi Paolo, Paolo wrote: After my last post I've also realized that values from the first row of every group won't be added to the total. So the results are wrong

Re: [dba-users] Calculated fields in report with Report Builder?

2007-10-10 Thread Drew Jensen
Howdy Ya'll, Paolo, there was a saying when I was growing up - The only way to learn to swim is to jump in the pool. Don't worry about making a splash, everyone here is already wet. :) Paolo wrote: Hi Ariel, thanks for your answer. You've guessed my thoughts and now I feel more confident

[dba-users] Updates to wiki pages

2007-10-11 Thread Drew Jensen
HI, Got an email from Paolo - The wiki looks like a formal place that should not be updated by mere users... Is it a Bazaar or a Cathedral? That is the question inside the community of late isn't it. So far, IMO, the guys in the black robes are winning. So sad. @Paolo - read down, I

[dba-users] WIKI page links

2007-10-11 Thread Drew Jensen
OK - be careful here media wiki sees a difference between the two links http://wiki.services.openoffice.org/wiki/Base/Reports http://wiki.services.openoffice.org/wiki/Base/Reports/ and these two http://wiki.services.openoffice.org/wiki/Base/Reports/Examples

[dba-users] Update to wiki page

2007-10-11 Thread Drew Jensen
Hi, Another updated added function names to the page at http://wiki.services.openoffice.org/wiki/SUN_Report_Builder#Supported_Functions Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL

Re: [dba-users] Updates to wiki pages

2007-10-11 Thread Drew Jensen
Frank Schönheit - Sun Microsystems Germany wrote: Hi Drew, Got an email from Paolo - The wiki looks like a formal place that should not be updated by mere users... Is it a Bazaar or a Cathedral? That is the question inside the community of late isn't it. So far, IMO, the guys in the

Re: [dba-users] Updates to wiki pages

2007-10-11 Thread Drew Jensen
I'll try to phrase the questions about the jdbc log entries - after I have had two more cups of coffee... Ah - speaking of talking politics, and needing more coffee to wake up, I mistakenly sent that email with the aside line to [EMAIL PROTECTED] is alive and well if you ask me...and I am

[dba-users] Mid-level tutorial

2007-10-11 Thread Drew Jensen
One last thing before I head off to something else. I got the first draft of the first couple of chapters for a Mid-level Base Tutorial from the individual I've helping over at the Documentation project. You guys are really gonna like this if it keeps going the way it has been so far. Also

Re: [dba-users] Updates to wiki pages

2007-10-11 Thread Drew Jensen
Ocke Janssen - Sun Microsystems Inc. wrote: I add the description for the functions which are available in the libformula($VERSION).jar and the java file which creates the output. :-) - oj Sweet! I volunteer to do the examples for the ROUND category then. ;p

Re: [dba-users] Updates to wiki pages

2007-10-11 Thread Drew Jensen
Hi Ariel, Ariel is my exact name Sorry, really didn't mean to turn into a font like that. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dba-users] Report Builder Performance

2007-10-11 Thread Drew Jensen
Darren Norris wrote: Hi Ariel, Ran a report usng JDBC connection to table in MySQL. Table with 8000 records. Selected 7 fields (mix of varchar, number, date and integer).Labelling option- accepted all defaults.Group- by 3 variables (date, integer, varchar)Sort options- accepted all defaults

Re: [dba-users] Report Builder Performance

2007-10-11 Thread Drew Jensen
Darren Norris wrote: psSorry my error. Yes I did just use the report wizard. I downloaded the Sun Report Builder and tried again. Sorry have to put details just in case I did something stupid. With BASE - open same JDBC connection to MySQL. Insert - new report Select table I

Re: [dba-users] Calculated fields in report with Report Builder?

2007-10-12 Thread Drew Jensen
Hi Paolo, I haven't updated the wiki pages, but for now. You can download a database I have set up for you at http://www.paintedfrogceramics.com/OpenOffice/SRB/Paolo.odb In the database you will find a single report. The report uses functions to create the sub totals, a grand total, for

Re: [dba-users] Calculated fields in report with Report Builder?

2007-10-12 Thread Drew Jensen
Manuel NAUDIN wrote: I have discovered that the fonction does not return the same result wether the text field it's bound to is inserted in the group header or group footer. If the text field is in the group footer, it works fine, but if the text field is in the group header, only first value of

Re: [dba-users] Calculated fields in report with Report Builder?

2007-10-12 Thread Drew Jensen
Hi Manuel So, assuming that we aren't missing something here and we will be corrected later. If you need to do that today, then I would say you need to create you summary back in the query that will be used to supply the report result set. You would create one query that generates the

[dba-users] Screen shot of Base for Web Site

2007-10-13 Thread Drew Jensen
Hi, A while back on the Dev list I started a thread that lead in part to a request from the Marketing Project Lead, John McCreesh for an alternative screen shot of the Base module. The exact request was: Please send me an alternative - about 750x520 in .png format, ideally from XP so as to

[dba-users] Wiki updated with Base data types

2007-10-15 Thread Drew Jensen
HI, Another update to the wiki http://wiki.services.openoffice.org/wiki/Base/Data_Types I really need folks to check this page over for accuracy... Thanks much Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional

Re: [dba-users] Re: Wiki updated with Base data types

2007-10-16 Thread Drew Jensen
Andreas Saeger wrote: So we have synonymous groups Numeric/Decimal, Real/Float/Double, Image/Binary and Other/Object, right? For better readability the table should merge equivalent types into single lines. Binary (fix) should get a description just like Text (fix): Stores exactly the length

Re: [dba-users] db backed form: upgrade oo.org 2.0 to 2.3 - form becomes read only

2007-10-17 Thread Drew Jensen
Adrian von Bidder wrote: Hi! I have a DB-backed form (sybase over jdbc on Linux), and upgrading from oo.org 2.0 to 2.3 (and I later also updated upgrading from jvm 1.5 to 1.6 and Sybase jConnect from 5.x to 6.0), the form now suddenly is read only. Anyobdy knows where to look? Strangely,

Re: [dba-users] base report wizrd

2007-10-17 Thread Drew Jensen
Drew Jensen wrote: Elizabeth Rimmer wrote: I am using open office 2.3, using windows. I am trying to create a report from a query (very simple) in base. It has two columns, headed: title and status and should reveal the titles of works which have the status 'marketable'. Under title I have

Re: [dba-users] Connecting to MySQL 5 from JDBC

2007-10-17 Thread Drew Jensen
of installation are you talking about. Is this a client server, or are you connecting on localhost? Which version of MySQL ( 5.0.x or 5.1.x ) and which JDBC version driver are you using? Finally, what client application are you trying to connect from? Drew Jensen

Re: [dba-users] Connecting to MySQL 5 from JDBC

2007-10-17 Thread Drew Jensen
Alexandro Colorado wrote: On Wed, 17 Oct 2007 22:05:23 -0500, Drew Jensen [EMAIL PROTECTED] wrote: Alexandro Colorado wrote: Sorry for the cross posting but I am not sure if the user is as active. I am having issues connecting to MySQL using JDBC. I get an error message: Communication

Re: [dba-users] Connecting to MySQL 5 from JDBC

2007-10-17 Thread Drew Jensen
Alexandro Colorado wrote: On Wed, 17 Oct 2007 23:12:07 -0500, Drew Jensen [EMAIL PROTECTED] wrote: Alexandro Colorado wrote: I select MySQL type then via JDBC. The driver said it loaded succesfully and then the user and database was ok. I put to localhost (tried 127.0.0.1 with the same

Re: [dba-users] Confusion on MySQL instruction

2007-10-17 Thread Drew Jensen
Alexandro Colorado wrote: On Wed, 17 Oct 2007 23:16:35 -0500, Drew Jensen [EMAIL PROTECTED] wrote: Alexandro Colorado wrote: I was looking at the dba.openoffice.org tips for MySQL but I found the following: via JDBC: (These steps are only valid for the MySQL connector) Get the newest JDBC

Re: [dba-users] Connecting to MySQL 5 from JDBC

2007-10-17 Thread Drew Jensen
Alexandro Colorado wrote: Also, any other notes in your experience with mysql specially on being able to insert fields and modifying data? Yeah..well, there is a fair bit of information at the old OOoforum ( it makes me mad to have to leave it behind ) Anyway, that is changing some as the

Re: [dba-users] Connecting to MySQL 5 from JDBC

2007-10-17 Thread Drew Jensen
Alexandro Colorado wrote: Ok I finally go tit working. the answer was 'comment out skip-networking' at the /etc/my.cfn file. Great, sounds like another comment for the wiki page. - To unsubscribe, e-mail: [EMAIL

Re: [dba-users] Confusion on MySQL instruction

2007-10-17 Thread Drew Jensen
Alexandro Colorado wrote: No the website that information should be deprecated otherwise it provoke 'information pollution'. Or flagged as to the version. Some folks still use version 1.x I suppose. In general though that is one of the differences between using the main site and a wiki.

Re: [dba-users] Base collapsing on MySQL date

2007-10-17 Thread Drew Jensen
Alexandro Colorado wrote: So I have a bunch of fields on a MySQL table that has a NULL value on the date-type fields. However when I open the table on Base I get an error saying: Value '-00-00' can not be represented as java.sql.Date I change the mask from MM/DD/ into -MM-DD

Re: [dba-users] Base collapsing on MySQL date

2007-10-17 Thread Drew Jensen
Alexandro Colorado wrote: So I have a bunch of fields on a MySQL table that has a NULL value on the date-type fields. However when I open the table on Base I get an error saying: Value '-00-00' can not be represented as java.sql.Date I change the mask from MM/DD/ into -MM-DD

Re: [dba-users] db backed form: upgrade oo.org 2.0 to 2.3 - form becomes read only

2007-10-18 Thread Drew Jensen
Adrian von Bidder wrote: Yes, I told oo.org to use the new jvm (what a stupid concept, imho, why not by default just use what's in /usr/bin/java or $JAVA_HOME?) dito for jconnect, I used com.sybase.jdbc3 or whatever the new classes are for jConnect 6. most likely you are using an older

[dba-users] Events on ODB files

2007-10-18 Thread Drew Jensen
Frank, I read your recent entry on GULLFoss and has a quick question. Do you plan to have assignable events at the ODB file level at the same time support for embedded basic libraries is implemented? Thanks Drew - To

Re: [dba-users] Base collapsing on MySQL date

2007-10-18 Thread Drew Jensen
Alexandro Colorado wrote: On Thu, 18 Oct 2007 00:13:03 -0500, Drew Jensen [EMAIL PROTECTED] wrote: Alexandro Colorado wrote: So I have a bunch of fields on a MySQL table that has a NULL value on the date-type fields. However when I open the table on Base I get an error saying: Value '

Re: [dba-users] Transactions in base

2007-10-21 Thread Drew Jensen
Marc Santhoff wrote: Hi, I'd like to know how base handles transaction regarding the underlying database. From some documentation (IDL-ref or dev guide) I know a newly created connection is set to autocommit by default. Does bases connection layer handle it this way? Or is it switched in the

Re: [dba-users] MySQL and OOo permission problems

2007-10-22 Thread Drew Jensen
Alexandro Colorado wrote: I want to know the status on MySQL-OOo permission problems that used to rule on 2.1 and before. I just used 2.3 and experience no problem wiht MySQL but I want to know if there are other systems that could experience this problem nowadays. Hello Alexandro, First ,

Re: [dba-users] Date field default to current date

2007-10-22 Thread Drew Jensen
Tobias Weiblen wrote: As of OOo 2.2, this neat feature got removed... I have to enter the date manually now for every single entry, which is not really convenient. Unfortunately, I am not firm in OOo Basic. Well, actually I might as well just go over this. I am pretty sure I know the answer

Re: [dba-users] Documentation of PostgreSQL

2007-10-22 Thread Drew Jensen
Alexandro Colorado wrote: Hi, I want to know if anyone is running OOo with a PostgreSQL conection. I would like to document the conection process and common issues that the driver currently have. Also maybe have some common workarounds. Thanks. Good morning Alexandro, How are you today?

Re: [dba-users] Documentation of PostgreSQL

2007-10-22 Thread Drew Jensen
Alexandro Colorado wrote: On Tue, 23 Oct 2007 00:16:31 -0500, Drew Jensen [EMAIL PROTECTED] wrote: There are number of people active on this and the dba dev lists that use postgres. I've been using it pretty much daily for the last 2 months or so in setting up the new user community forum

Re: [dba-users] Documentation of PostgreSQL

2007-10-22 Thread Drew Jensen
Well, see I just now went and looked and what do you know they released a new version less then two months ago. So I was just all wet in what I thought. I'll have to give it a try. - To unsubscribe, e-mail: [EMAIL PROTECTED]

Re: [dba-users] Documentation of PostgreSQL

2007-10-22 Thread Drew Jensen
Alexandro Colorado wrote: On Tue, 23 Oct 2007 00:16:31 -0500, Drew Jensen [EMAIL PROTECTED] wrote: However, I'm not sure how Simon and Mechtilde would want to do this. For example they might prefer this off of the Database root instead? So I wanted to run it by them here first

Re: [dba-users] Documentation of PostgreSQL

2007-10-23 Thread Drew Jensen
Drew Jensen wrote: Well, see I just now went and looked and what do you know they released a new version less then two months ago. So I was just all wet in what I thought. I'll have to give it a try. Just downloaded the latest sdbc driver and used Extension Manager to install it, restarted

Re: [dba-users] Moving Dinbandu's data

2007-10-23 Thread Drew Jensen
Howdy all, A new installment in what is becoming a saga, and a badge of shame for myself. A few days ago in another thread I put up a couple of basic routines to scrub a line of data from a CSV and use this to load the scrubbed line to a base file. That was for Dinabnu's use. Still trying

Re: [dba-users] Documentation of PostgreSQL

2007-10-24 Thread Drew Jensen
... Drew Jensen wrote: Drew Jensen wrote: Well, see I just now went and looked and what do you know they released a new version less then two months ago. So I was just all wet in what I thought. I'll have to give it a try. Just downloaded the latest sdbc driver and used Extension Manager

Re: [dba-users] Moving Dinbandu's data

2007-10-25 Thread Drew Jensen
Frank Schönheit - Sun Microsystems Germany wrote: Hi Drew, Anyone want to venture a guess as to what is going on? Just a wild guess - what would happen if an error occurs during writing the input line to the error file? (Don't know enough about Basic to say whether this is a stupid

Re: [dba-users] Moving Dinbandu's data

2007-10-25 Thread Drew Jensen
hmmm- let me change something I said in that last email. The real problem - a very poor design of the loader on my part. No notification as to where the program was at in processing the file, and a no concern to performance on my part. No batching, no use of explicit commits for example.

Re: [dba-users] Moving Dinbandu's data

2007-10-25 Thread Drew Jensen
Marc Santhoff wrote: Am Donnerstag, den 25.10.2007, 22:04 -0400 schrieb Drew Jensen: At that point he simply opened a data view window and hand entered the data with copy paste for the varchar and memo fields, and just updated the boolean fields, of the six records. Handling data

Re: [dba-users] Moving Dinbandu's data

2007-10-26 Thread Drew Jensen
Hehe. *Everything* needs an RFE. You know, I won't even take my feet from my desk without an issue in IZ ... :) Wow, then each developer has got his own coffee machine on his desk ? Paradise !!! :-) Alex Well, I was going for levity there, and Alex's further humor points

[dba-users] Re: Mid-level tutorial

2007-10-26 Thread Drew Jensen
Hi Sorry for clogging up your inbox but I should correct this right now. For the record, the author of this work is named Mariano not the name I seemed to have made up from thin air in the last email. - To unsubscribe,

Re: [dba-users] memo field in query-unexpected behavior

2007-10-27 Thread Drew Jensen
Manuel NAUDIN wrote: a simple query PROD_QUERY created in sql mode with direct sql on : SELECT id_prod, prod_name || ' ' || prod_details AS product description FROM PRODUCTS What is unexpected (to me at least) is that if the prod_details field is empty, product_description is empty too,

Re: [dba-users] memo field in query-unexpected behavior

2007-10-27 Thread Drew Jensen
Manuel NAUDIN wrote: SELECT id_prod, CONCAT( prod_name, CONCAT( ' ', prod_details) ) AS product description FROM PRODUCTS ok, those imbricated CONCAT() are so error prone that I try not to use them ;-) +1 I'll have to double check the parentheses Thanks (the other way round

[dba-users] Irony

2007-10-29 Thread Drew Jensen
Updated the new Forum site this evening Took advantage of the ability to have a forum redirect to another location - So, used a bunch of URLs ot static pages on the wiki for the documentation guides... O:-) Each module in OpenOffice.org has a separate main forum heading Each of these has

Re: [dba-users] Documentation of PostgreSQL

2007-10-30 Thread Drew Jensen
Tim wrote: Alexandro Colorado wrote: On Wed, 24 Oct 2007 10:46:00 -0500, Christoph Lukasiak [EMAIL PROTECTED] wrote: Well instead of deciding the Wiki page name for it. I think that it will be cool if you go to the postgresql wiki and also submit this OOo-PostgreSQL implementaiton:

Re: [dba-users] Documentation of PostgreSQL

2007-10-30 Thread Drew Jensen
Alexandro Colorado wrote: Just as a FYI, installed Kubuntu 7.1 recently on a couple of machines. The postgresql sdbc driver is installed by default under these distributions - Base isn't :-( but when you install Base it pulls it right in. That's pretty neat althought should we document

Re: [dba-users] Short cuts / function key's for Base

2007-11-02 Thread Drew Jensen
Base = Main Window --- [ALT] [a] [u] Start Table Wizard [ALT] [q] [u] Start Query Wizard [ALT] [m] [u] Start Form Wizard [ALT] [r] [u] Start Report Wizard [ALT] [r] [c] Start Report Builder Embedded Form - [F4] Open data source window for this

Re: [dba-users] Short cuts / function key's for Base

2007-11-02 Thread Drew Jensen
Frank Schönheit - Sun Microsystems Germany wrote: Hi Drew, Main Window --- [ALT] [a] [u] Start Table Wizard [ALT] [q] [u] Start Query Wizard [ALT] [m] [u] Start Form Wizard [ALT] [r] [u] Start Report Wizard [ALT] [r] [c] Start Report Builder Not

Re: [dba-users] Re: Date field default to current date

2007-11-04 Thread Drew Jensen
OKie Odkie...I'll get part two together tonight. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dba-users] error message

2007-11-06 Thread Drew Jensen
Frank Schönheit - Sun Microsystems Germany wrote: Hi Drew, a couple people reporting this same type of problem all using 2.3 and all having the problem with system generated FKs...I'll read it in detail tonight and see if I can find a commonality that I can reproduce and enter an issue.

Re: [dba-users] Variable height for text fields in Sun Report Builder?

2007-11-27 Thread Drew Jensen
Regina Henschel wrote: HI Paolo, Paolo schrieb: After a while away, I'm back playing with OO Base and Sun Report builder. Now I have one question: is it possible to have variable height report fields? That is, every report line I'm printing includes a memo text, and the content here could

[dba-users] RSS feed from Base forum

2007-11-27 Thread Drew Jensen
Just a quick FYI Have taken the first steps towards adding RSS and ATOM syndication to the Community Forum - still lots to do but for anyone interested you can start getting a feed for recent posts to the Base section with

Re: [dba-users] contact Drew Jensen

2007-11-27 Thread Drew Jensen
Dinbandhu wrote: Hello all, I've been attempting to contact Drew Jensen but am not getting success. I think perhaps my e-mails are not getting through to him for some reason. If one of you could kindly try forwarding this note to him from your own account, then my hope is he will be able

Re: [dba-users] RSS syndication for Base forums

2007-11-28 Thread Drew Jensen
Thanks for the feed back - it doesn't seem to be working correctly does it, I'll be working on the code for the actual syndication program this weekend. Let me tell you what it is I am trying to achieve here as you ( along with the other OpenOffice.org core groups ) are one of prime targets.

Re: [dba-users] ThisComponent AND Macros in Database Documents

2007-12-15 Thread Drew Jensen
Greetings, Frank Schönheit - Sun Microsystems Germany wrote: After digging deeper into the topic, I somewhat changed my mind and in fact think we need to introduce another global variable, to differ between the document where the macro is located and the document from where the macro was

Re: [dba-users] ThisComponent AND Macros in Database Documents

2007-12-17 Thread Drew Jensen
OK - I decided I should send this along before someone chides me for a comment in the last email. The keyboard does not work with forum controls. It doesn't matter if those are on a stand alone Writer document, a Calc document or an embedded Base form. It is not that it does not work with

Re: [dba-users] TOP/LIMIT

2007-12-18 Thread Drew Jensen
Michael Baranov wrote: Hi! I'm using OO 2.3.0 on Ubuntu Gutsy and building a little private accounting DB. The engine is embedded HSQLDB. However, I came across a problem : I can't make TOP/LIMIT to work with queries. Tried all sane and insane combinations like: SELECT TOP 3 * FROM ... SELECT

[dba-users] Update to wiki page

2007-12-18 Thread Drew Jensen
Got part of the update to the page http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#Modifiers finished. Just the part of the LIMIT and TOP modifiers for the moment. Drew

Re: [dba-users] How to copy paste a query result?

2008-01-02 Thread Drew Jensen
Dinbandhu wrote: Hello, I use Base to maintain the mailing list for our daily newsletter. The mailing list is produced by a query. I need to be able to run the query, highlight copy the resultant list of addresses, and then paste that address list into my Thunderbird address book. But when I

Re: [dba-users] How to copy paste a query result?

2008-01-02 Thread Drew Jensen
Dinbandhu wrote: Hello Drew, Many thanks for your helpful reply. I got stuck at one point-- please see below. On Wed, 2008-01-02 at 13:10 -0500, Drew Jensen wrote: Hello Swarup You can not copy from the data grid view like that, as you have found. You can do something else

Re: [dba-users] Macros in Database Documents - Milestone 1

2008-01-04 Thread Drew Jensen
Frank Schönheit - Sun Microsystems Germany wrote: Hi, the announcement in GullFOSS will have to wait 'til next week (I'm officially on vacation ATM :), but I wanted to let interested parties here know that you can get your hands on milestone 1 of the Macros in Database Documents feature.

Re: [dba-users] Does Base suck?

2008-01-09 Thread Drew Jensen
I was going to comment on a few things in Andreas' and Frank's emails, and still want to, but this first. Erwin Tenhumburg's latest blog entry is about an announcement of another linux based consumer latptop, by Exerex, to be sold in Walmart stores. Quote: I'm pretty sure that all these

Re: [dba-users] Does Base suck?

2008-01-09 Thread Drew Jensen
Sorry if this is a double post - but I sent the first time from an address not subscribed to the list and never get responses so don't know... I was going to comment on a few things in Andreas' and Frank's emails, and still want to, but this first. Erwin Tenhumburg's latest blog entry is

Re: [dba-users] Does Base suck?

2008-01-09 Thread Drew Jensen
{ again sorry if this is a double postarrgh ) I also wanted to add this to the mix. This is the latest post from a current topic thread at OOoForum - the poster owens a small watch repair business. Emphasis added: I am getting more fired up with ooBase and my watchmaking project comes

Re: [dba-users] Drew's mail addresses

2008-01-09 Thread Drew Jensen
Frank Schönheit - Sun Microsystems Germany wrote: Hi Drew, Since I got tired of moderating your mails from this other address, I added it to the list of allowed posters recently ... ;) My apologies :( - To unsubscribe,

Re: [dba-users] How to print only current record through a button on form which calls the report.

2008-01-10 Thread Drew Jensen
Frank Schönheit - Sun Microsystems Germany wrote: Hi Ariel, Well my idea here would be to have a report bound to a certain query of the form SELECT ... FROM ... WHERE ..., and to modify this query's WHERE clause to filter for the form's current record (e.g. to SELECT ... FROM ... WHERE (

Re: [dba-users] Base usage???

2008-01-10 Thread Drew Jensen
Mechtilde wrote: Hello Drew Drew Jensen schrieb: I see a problem in the discussion Only dba.openoffice.org has as a users as a dev activ mailing list. The other modul project lists has only very few postings (like writer or calc Regards Mechtilde Good point - the user mailing lists

Re: [dba-users] Base usage???

2008-01-10 Thread Drew Jensen
Alexandro Colorado wrote: IF there was a list for users I think it would be much better since there are many questions (user base). I think we can just promote it on OOoForum which is where I see most of the user-base questions that people have of the module. Also I would love to see a

[dba-users] problem with Macros in ODB build

2008-01-10 Thread Drew Jensen
OK - this is a bit off topic but it is happening so I'll report it here, as a heads up. This is using an ODB file first created in Nov 05 - whatever release that was? A Master/Sub form, the sub-forum has a table grid control. The grid uses drop down list boxes in two columns. Everything is

[dba-users] Totally off topic - but since I started it...

2008-01-11 Thread Drew Jensen
Module / Topics ( Subjects ) www.OOoForum.org ~ Dec 2002 Writer = 16738 Calc = 10198 Base = 4736 Impress = 592 Draw = 922 Math = 537 deutsches Forum rund um OpenOffice.org ~ June 2003 Writer = 5493 Calc = 3392 Base = 1322 Impress = 592 Draw = 268 Math = 163 Dansk OpenOffice.org Forum ~ Oct

Re: [dba-users] Re: Totally off topic - but since I started it...

2008-01-11 Thread Drew Jensen
Andreas Saeger wrote: Writer CalcBaseImprDrawMath DEN 57% 26% 6% 6% 3% 3% FRA 37% 32% 21% 7% 3% 1% GER 49% 30% 12% 5% 2% 1% NOR 68% 17% 6% 6% 3% 0% ooof50%

[dba-users] No I haven't gone soft...

2008-01-17 Thread Drew Jensen
Noticed there is a new team formed in OO.o. - Performance. Looked at the wiki page http://wiki.services.openoffice.org/wiki/Performance wait for it *** Where's Base? - To unsubscribe,

Re: [dba-users] Magnifique Mon Ami

2008-01-17 Thread Drew Jensen
Drew Jensen wrote: Sub title to this post - Sometimes unintended consequences work out for the good! There are a couple of threads dealing with Base over all that I have been both wanting to comment on and avoiding as I know that at times I seem to just hit the negative. Current problem

Re: [dba-users] Base shortcomings

2008-01-18 Thread Drew Jensen
Good man! Well, i'm able to add another column to the end of the columns by clicking on one of the fields. This adds another column with the name of one of the other columns (the name is the same as the one i clicked on). However none of the fields in this column is editable -- i

Re: [dba-users] Base shortcomings

2008-01-18 Thread Drew Jensen
Drew Jensen wrote: Good man! Well, i'm able to add another column to the end of the columns by clicking on one of the fields. This adds another column with the name of one of the other columns (the name is the same as the one i clicked on). However none of the fields

Re: [dba-users] Re: SELECT in OOo mode vs. pass through

2008-01-21 Thread Drew Jensen
AKAIK it would be completely possible to develop a new sdbc driver to connect *directly* to MySQL, just like the case you mention with PostgreSQL, with no need to use ODBC or JDBC. Well... now that Sun spend u$s 1 billion on MySQL I wonder if some MySQL developers can work together with the

Re: [dba-users] Macros in OOo OOH build m5

2008-01-29 Thread Drew Jensen
Reizinger Zoltán wrote: Frank, Yesterday I poked with Drews, macro example from this link, with OOoM4 and worked well(and with 2.3, and with drews 2.3.1, too): http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=2002 Today I downloaded m5 and not working with example database on

Re: [dba-users] Macros in OOo OOH build m5

2008-01-29 Thread Drew Jensen
Reizinger Zoltán wrote: Frank, Yesterday I poked with Drews, macro example from this link, with OOoM4 and worked well(and with 2.3, and with drews 2.3.1, too): http://user.services.openoffice.org/en/forum/viewtopic.php?f=13t=2002 Today I downloaded m5 and not working with example database on

[dba-users] Name that field - does size really matter?

2008-01-30 Thread Drew Jensen
If I may ask a few philosophical questions and get some of your collective wisdom., thank you. A few thoughts as setup for the questions first. Base is: - a desktop database manager - a database front end / BI (reports for those that don't like buzzwords) design tool - a GUI based IDE - a

Re: [dba-users] Name that field - does size really matter?

2008-01-31 Thread Drew Jensen
Reizinger Zoltán wrote: Drew Jensen írta: I answer to your thoughts partially. As I say, verbose column names indeed. But when you use the form wizard against that table you get nice meaningful labels. Same for reports. None of that, run the wizard now go back and select each label

Re: [dba-users] Name that field - does size really matter?

2008-01-31 Thread Drew Jensen
Marc Santhoff wrote: Hi Drew, Am Donnerstag, den 31.01.2008, 01:43 -0500 schrieb Drew Jensen: [...] The first step of course is to turn the UML diagram into an actual physical schema - and - therein is the question. May I ask: what tool do you (and others, if so) use for making UML

Re: [dba-users] Name that field - does size really matter?

2008-01-31 Thread Drew Jensen
Reizinger Zoltán wrote: When I use wizard in Hungarian version of OOo the generated tables use half translated to Hungarian, English field name translated to the meaningful names, but without accented characters. OH - you are talking about the Create Table Wizard aren't you. Hmmm, that

Re: [dba-users] Name that field - does size really matter?

2008-01-31 Thread Drew Jensen
Alex Thurgood wrote: True, and it does save time on form building, but on queries using SQL it's one PITA having to type in so much, with the risk of mistyping or having to put everything in quotes (OK, most CLI shells have tab completion if the db supports that feature, so maybe I'm being a

Re: [dba-users] Name that field - does size really matter?

2008-01-31 Thread Drew Jensen
Reizinger Zoltán wrote: It is not a bug, It's based on a good practice, OOo could be used on different systems(win, linux), with different coding system, using, Latin-2,Central European, Windows-1250 or UTF-8 where accented characters have different cods. If you create database table with

Re: [dba-users] Name that field - does size really matter?

2008-01-31 Thread Drew Jensen
Jim Carter wrote: Drew - I highly approve of the approach. It has the merit of Northwind - i.e. more stuff than you will use, but it works! One of the things I am excited about is that the Professor Casanova is not an database guy or IT consultant/trainer - he is a Therapist and he chose

Re: [dba-users] International Addresses ( was: Name that field - does size really matter?)

2008-01-31 Thread Drew Jensen
Leaving sorting aside - if the fields changed to: Address VARCHAR(200), City VARCHAR(100), State VARCHAR(50), Postal code VARCHAR(20), Country VARCHAR(50) Phone VARCHAR(30) Better? Good enough? for handling mailing addresses around the globe? Yes I plagiarized that right from the Base

[dba-users] Base in a multi-user environment?

2008-01-31 Thread Drew Jensen
That question comes up a lot actually - at OOoForum at the Community Forum on the [EMAIL PROTECTED] mailing list. It came up on the mailing list again today. As usual a helpful person was reasonably quick to answer NO and I understand the reason for that of course. But for a while now I have

Re: [dba-users] Base in a multi-user environment?

2008-02-01 Thread Drew Jensen
Kelvins next message. Hi Drew and Dan, First off, a big thank you for such an enlightening response though I have to admit that I am about 30 - 40 % lost in your response. I don't think any of the MS help desk, which probably is a call center buried deep in the darkest of a third world

[dba-users] Foreign Keys - To ID or not to ID?

2008-02-06 Thread Drew Jensen
OK - another question for some group wisdom.. Having created the second cut of the schema for the database: tutorial_example_clinic.odb The decision is now about lookup tables - To use an integer ID or not... For instance here are two lookup tables: -- PhoneType is a lookup table -- for use

Re: [dba-users] How to print only current record through a button on form which calls the report.

2008-02-06 Thread Drew Jensen
Took a stab a full explanation for doing this... http://user.services.openoffice.org/en/forum/viewtopic.php?f=39t=2391 Drew - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [dba-users] Open a Query from a Basic Script

2008-02-08 Thread Drew Jensen
Alex Thurgood wrote: Drew Jensen a écrit : Hi Drew, I am hoping someone can help with this. Need to open a ( execute ) a query from a Basic script. Not sure if I am on the right track - aconnection.queries.getByName( queryName ) That gets me the query definition and this has the function

Re: [dba-users] Base in a multi-user environment?

2008-02-08 Thread Drew Jensen
Well, it looks like I scared off the fellow asking about this on the users mailing list ( actually he sent a reply that pretty much says just that ). I used to many 3 letter acronyms I think. However, on the Forum there is a user successfully running a 5 user Base application against MySQL in

  1   2   3   4   5   >