Re: [dabo-users] Data Types in Bizobj

2008-11-18 Thread Paul McNett
Roger Lovelock wrote: > Worked perfectly - many thanks! Great! > By the way - I seem to be learning about dabo from the bottom up ie details > as I strike them, which may be a fairly slow process, is there any top down > approach available (fully understand the problems of limited time availabl

Re: [dabo-users] Data Types in Bizobj

2008-11-18 Thread Roger Lovelock
)? Ta - Original Message - From: "Paul McNett" <[EMAIL PROTECTED]> To: "Dabo Users list" Sent: Wednesday, November 19, 2008 12:20 PM Subject: Re: [dabo-users] Data Types in Bizobj > Roger Lovelock wrote: >> I like the idea of setting up my D

Re: [dabo-users] Data Types in Bizobj

2008-11-18 Thread Roger Lovelock
Thanks - I'll give that a go! - Original Message - From: "Paul McNett" <[EMAIL PROTECTED]> To: "Dabo Users list" Sent: Wednesday, November 19, 2008 12:20 PM Subject: Re: [dabo-users] Data Types in Bizobj > Roger Lovelock wrote: >> I like the i

Re: [dabo-users] Data Types in Bizobj

2008-11-18 Thread Paul McNett
Roger Lovelock wrote: > I like the idea of setting up my DataStructure in my code rather than > changing my database (since, at least in theory, it could be in use by other > apps and I don't want to break them). As I generated my Bizobj from within > the ClassDesigner the code is not in the biz

[dabo-users] Data Types in Bizobj

2008-11-18 Thread Roger Lovelock
I like the idea of setting up my DataStructure in my code rather than changing my database (since, at least in theory, it could be in use by other apps and I don't want to break them). As I generated my Bizobj from within the ClassDesigner the code is not in the biz folder, but instead is in the

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Uwe Grauer
Roger Lovelock wrote: > I tried to do that initially by copying the pattern of code from the > AppWizard to the ClassDesigner, but found that there was no method > immediately available in Bizobj to load the definition from a DataStructure. > Obviously it must be able to be done, but at this sta

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Roger Lovelock
Thanks - I'll give it a go. Rodgy - Original Message - From: "Paul McNett" <[EMAIL PROTECTED]> To: "Dabo Users list" Sent: Wednesday, November 19, 2008 8:59 AM Subject: Re: [dabo-users] Data Types in bizObj > Roger Lovelock wrote: >> I t

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Paul McNett
Roger Lovelock wrote: > I tried to do that initially by copying the pattern of code from the > AppWizard to the ClassDesigner, but found that there was no method > immediately available in Bizobj to load the definition from a DataStructure. > Obviously it must be able to be done, but at this sta

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Roger Lovelock
would probably take me a lot of research to find out how so I didn't pusue it. Rodgy - Original Message - From: "Paul McNett" <[EMAIL PROTECTED]> To: "Dabo Users list" Sent: Wednesday, November 19, 2008 8:28 AM Subject: Re: [dabo-users] Data Typ

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Paul McNett
Roger Lovelock wrote: >Just read email from Paul - sounds like the path to go down is to try > DECIMAL(12,2). But if you don't want to change the db definition, you've already discovered that you can override the field type by setting biz.DataStructure appropriately. FWIW, I *always* expli

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Roger Lovelock
Ed, Just read email from Paul - sounds like the path to go down is to try DECIMAL(12,2). Rodgy - Original Message - From: "Ed Leafe" <[EMAIL PROTECTED]> To: "Dabo Users list" Sent: Wednesday, November 19, 2008 2:32 AM Subject: Re: [dabo-users] D

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Roger Lovelock
Thanks, sounds right, I'll give it a go and let you know! Rodgy - Original Message - From: "Paul McNett" <[EMAIL PROTECTED]> To: "Dabo Users list" Sent: Wednesday, November 19, 2008 3:20 AM Subject: Re: [dabo-users] Data Types in bizObj > Ed L

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Roger Lovelock
problem is with the interpretation of the SQLite schema? Rodgy - Original Message - From: "Ed Leafe" <[EMAIL PROTECTED]> To: "Dabo Users list" Sent: Wednesday, November 19, 2008 2:32 AM Subject: Re: [dabo-users] Data Types in bizObj > On Nov

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Paul McNett
Ed Leafe wrote: > On Nov 17, 2008, at 11:51 PM, Roger Lovelock wrote: > >> SQL for table from SQLite Administrator shown below :- >> >> CREATE TABLE MembershipTypes ( MTypeID INTEGER, MTypeDesc >> VARCHAR2(30) NOT NULL, MTypeDues NUMBER(32,2) NOT NULL, >> primary key (MTypeID)) > > > Wh

Re: [dabo-users] Data Types in bizObj

2008-11-18 Thread Ed Leafe
On Nov 17, 2008, at 11:51 PM, Roger Lovelock wrote: > SQL for table from SQLite Administrator shown below :- > > CREATE TABLE MembershipTypes ( MTypeID INTEGER, MTypeDesc > VARCHAR2(30) NOT NULL, MTypeDues NUMBER(32,2) NOT NULL, > primary key (MTypeID)) What version of SQLite is this?

[dabo-users] Data Types in bizObj

2008-11-17 Thread Roger Lovelock
Hi Ed, SQL for table from SQLite Administrator shown below :- CREATE TABLE MembershipTypes ( MTypeID INTEGER, MTypeDesc VARCHAR2(30) NOT NULL, MTypeDues NUMBER(32,2) NOT NULL, primary key (MTypeID)) Although my recollection when I set the database up was that the MTypeID field was IDENTITY