Re: String lengths in the SQL backend

2008-11-12 Thread Marcus Wolschon
Well, my 2ct here: I am using the account-code to store item-numbers/item-barcodes (assets) or account-numbers (bank-accounts). Item-numbers can get quite long (think the serial-number identifying a laptop) but 32 characters should be okay, as long as it's not 32 byte (think Unicode). How far has

Re: String lengths in the SQL backend

2008-11-12 Thread Ian Smith-Heisters
On Wed, Nov 12, 2008 at 6:11 PM, Derek Atkins <[EMAIL PROTECTED]> wrote: > Hi, > > Quoting Eric Anopolsky <[EMAIL PROTECTED]>: > >> I'm not familiar with gnucash's data structures so I'm not 100% sure >> what a "code" is, but would it be possible to identify each account by >> an int or a bigint in

Re: String lengths in the SQL backend

2008-11-12 Thread Derek Atkins
Hi, Quoting Eric Anopolsky <[EMAIL PROTECTED]>: > I'm not familiar with gnucash's data structures so I'm not 100% sure > what a "code" is, but would it be possible to identify each account by > an int or a bigint instead of a code? Then this secondary table could > have the "account int" as its f

Re: String lengths in the SQL backend

2008-11-12 Thread Eric Anopolsky
On Wed, 2008-11-12 at 10:24 -0500, Phil Longstaff wrote: > For those on the gnucash user list, a new SQL backend is in development. An > issue has arisen, and I need to get input from users, not just developers. > > Rolf Leggewie has run into some problems with the SQL backend > (http://bugzill

Re: String lengths in the SQL backend

2008-11-12 Thread Roland Roberts
Phil Longstaff wrote: > For those on the gnucash user list, a new SQL backend is in development. An > issue has arisen, and I need to get input from users, not just developers. > > Rolf Leggewie has run into some problems with the SQL backend > (http://bugzilla.gnome.org/show_bug.cgi?id=560165)

Re: String lengths in the SQL backend

2008-11-12 Thread Donald Allen
On Wed, Nov 12, 2008 at 11:48 AM, Phil Longstaff <[EMAIL PROTECTED]> wrote: > On November 12, 2008 11:22:34 am Donald Allen wrote: >> >> Why is mysql an issue? I thought the backend was going to be sqlite3? >> Perhaps you are doing a generic sql layer, designed to talk any one of >> many target dat

Re: String lengths in the SQL backend

2008-11-12 Thread Graham Leggett
Phil Longstaff wrote: I'd have to look back, but I think Derek's reply was the only one. I'd like to open the topic again, because of Rolf's problem. Can anyone think of a reason that account code size limit cannot be reduced to a smaller value (e.g. 32)? Will anyone ever enter an account

Re: String lengths in the SQL backend

2008-11-12 Thread Phil Longstaff
On November 12, 2008 12:11:13 pm Donald Allen wrote: > On Wed, Nov 12, 2008 at 11:48 AM, Phil Longstaff <[EMAIL PROTECTED]> wrote: > > On November 12, 2008 11:22:34 am Donald Allen wrote: > >> Why is mysql an issue? I thought the backend was going to be sqlite3? > >> Perhaps you are doing a generi

Russian translation update

2008-11-12 Thread Сергей Беляшов
This is update of russian translation for current 2.2 branch (rev. 17688). Best regards, Sergey Belyashov russian.patch.gz Description: GNU Zip compressed data ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/l

Re: String lengths in the SQL backend

2008-11-12 Thread Phil Longstaff
On November 12, 2008 11:22:34 am Donald Allen wrote: > > Why is mysql an issue? I thought the backend was going to be sqlite3? > Perhaps you are doing a generic sql layer, designed to talk any one of > many target databases, or the specific target database has changed? It uses a library which supp

Re: String lengths in the SQL backend

2008-11-12 Thread Herbert Thoma
Mike or Penny Novack schrieb: >> . >> I'd have to look back, but I think Derek's reply was the only one. I'd like >> to open the topic again, because of Rolf's problem. Can anyone think of a >> reason that account code size limit cannot be reduced to a smaller value >> (e.g. >> 32)? Wil

Re: String lengths in the SQL backend

2008-11-12 Thread Paul Schwartz
I've worked with several accounting packages, and I would find it very strange if someone could not adapt their procedures to live with 32 for the length of the account code. Paul --- On Wed, 11/12/08, Phil Longstaff <[EMAIL PROTECTED]> wrote: > From: Phil Longstaff <[EMAIL PROTECTED]> > Subj

Re: String lengths in the SQL backend

2008-11-12 Thread Donald Allen
On Wed, Nov 12, 2008 at 10:24 AM, Phil Longstaff <[EMAIL PROTECTED]> wrote: > For those on the gnucash user list, a new SQL backend is in development. An > issue has arisen, and I need to get input from users, not just developers. > > Rolf Leggewie has run into some problems with the SQL backend >

Re: String lengths in the SQL backend

2008-11-12 Thread Mike or Penny Novack
>. >I'd have to look back, but I think Derek's reply was the only one. I'd like >to open the topic again, because of Rolf's problem. Can anyone think of a >reason that account code size limit cannot be reduced to a smaller value (e.g. >32)? Will anyone ever enter an account code longer

String lengths in the SQL backend

2008-11-12 Thread Phil Longstaff
For those on the gnucash user list, a new SQL backend is in development. An issue has arisen, and I need to get input from users, not just developers. Rolf Leggewie has run into some problems with the SQL backend (http://bugzilla.gnome.org/show_bug.cgi?id=560165) - he wants to add another SQL

Re: trunk doesn't compile

2008-11-12 Thread Casey Cichon
Christian Stimming wrote: > Am Freitag, 31. Oktober 2008 06:00 schrieb Casey Cichon: > >>> .libs/split-register-control.o cc1: warnings being treated as errors >>> split-register-control.c: In function â: >>> split-register-control.c:1149: warning: â may be used uninitialized in >>> this functio

Writing Reports - Schreiben von Berichten in Gnucash

2008-11-12 Thread Norbert Bachl
Hello Development-Team, I would like to create an invoice with a logo an maybe some other features. For this reason I would appreaciate your help. Greatings Norbert Pt! Schon vom neuen WEB.DE MultiMessenger gehört? Der kan

Re: Importing Data

2008-11-12 Thread Marcus Wolschon
2008/11/11, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > Hello there, > > I don't know which of these two groups is the right one for my question so > I'm sorry to contact both of them... > > I just want to know if it's possible to do a data import from an external > software tool. > The reason: I'm de

Re: Date and timezone problem

2008-11-12 Thread Rolf Leggewie
Derek Atkins wrote: > So something is doing the conversion improperly somewhere. Alright. So how do we go about this to find out? And how should I fix it? ___ gnucash-devel mailing list gnucash-devel@gnucash.org https://lists.gnucash.org/mailman/listi