Re: [dba-dev] having trouble passing parameters to a query

2007-05-17 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Jerry, >>>I haven't had any luck on the user forum getting an answer to this >>>question. >>>Can you cc or reply to me if there is an answer, or if this is a bug? >> Wild guessing: Does changing the ":x" to "?" improve the situation? > I just tried that, with the same results. Okay, just want

Re: [dba-dev] Queries in Base

2007-05-17 Thread Frank Schönheit - Sun Microsystems Germa ny
Hi Dan, > I think I have now found a way, but it involves an extra "step" > (actually an extra query). Create a table with the following fields: > FuelID (PK), Date, FuelCost, FuelQuanity, and Odometer. Then create a > query (Query1) with these fields from the table: FuelID, FuelQuanity,

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

2007-05-17 Thread Frank Schönheit - Sun Microsystems Germ any
Hi Marc, > In general I can second your opinion, but there *are* cases where using > the control is "a good thing": > > Especially when using BASIC there is no way of converting datatyes using > an API service (at lest one I know, please tell me if so!) so you'd have > to convert each value to th

Re: [dba-dev] having trouble passing parameters to a query

2007-05-17 Thread Jerry Thomason
Frank, I just tried that, with the same results. - Original Message - From: "Frank Schönheit - Sun Microsystems Germany" <[EMAIL PROTECTED]> To: Cc: "Jerry Thomason" <[EMAIL PROTECTED]> Sent: Wednesday, May 16, 2007 3:55 AM Subject: Re: [dba-dev] having trouble passing parameters to a

Re: [dba-dev] Queries in Base

2007-05-17 Thread andrew
Hi Dan, Yes, it is a general solution for result sets containing a sequence with increments of 1. My comment was concerning imparting significance to a Primary Key ( or any key actually ) beyond that of row identification. IMO this is something to avoid if at all possible. As I said however

Re: [dba-dev] Queries in Base

2007-05-17 Thread Dan Lewis
On Wednesday May 16 2007 10:22 pm, andrew wrote: > 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