On 6/24/04 7:36 PM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> You can only pick a format when the "Update after
> editing" button is checked.
> What was in the failed query? The only thing I can
> think of right away is that you didn't set the primary
> key in the query builder.
The primar
I am using MySQL. But if we cannot pass a user defined variable to the
database query builder then it makes the database-linked controls kind of
weak. I hope that you complete that user interface soon.
Perhaps I can use the database-liked controls in combination by viewing
subsets of records with
Jan:
On 6/24/04 7:36 PM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> You can only pick a format when the "Update after
> editing" button is checked.
Just noticed that answer. What I was trying to say is that the format radio
buttons are mysteriously disabled after you check the "Update aft
On 6/29/04 11:50 AM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> You can use the same query for a table to show a list
> of records, and individual fields to display details
> -- though you'll have to turn on the Record set
> caching option.
> As for the update problem, I'm sure we'll find
Jan:
How do you get the -- revRecordCountOfQuery(somevariable)
To work? (I tried inserting all kinds of things in the somevariable and got
nothing).
I want to have my various changes of the query using
revSetSQLOfQuery "Connect",tSQLStatement to also put the subset of the
records found in a fi
--- Bill <[EMAIL PROTECTED]> wrote:
> Jan:
>
> On 6/24/04 7:36 PM,
> "[EMAIL PROTECTED]"
> <[EMAIL PROTECTED]> wrote:
>
> > You can only pick a format when the "Update after
> > editing" button is checked.
>
> Just noticed that answer. What I was trying to say
> is that the format radio
> butto
--- Bill <[EMAIL PROTECTED]> wrote:
> I am using MySQL.
Heh, that's what I use for testing and updating the
codebase -- I'll try and simulate the error in the
next couple of days.
> But if we cannot pass a user defined variable to the
> database query builder then it makes the
> database-linked c
Hi Jan, what exactly does "revSetSQLOfQuery" function, ?
Thanks.
On Tuesday, June 29, 2004, at 06:57 AM, Jan Schenkel wrote:
--- Bill <[EMAIL PROTECTED]> wrote:
I am using MySQL.
Heh, that's what I use for testing and updating the
codebase -- I'll try and simulate the error in the
next couple of da
--- [EMAIL PROTECTED] wrote:
> Hi Jan, what exactly does "revSetSQLOfQuery"
> function, ?
> Thanks.
That command permanently changes the SQL statement of
an automated database query, executes this query and
refreshes the fields linked to it.
It is currently the only way to achieve dynamic
queries
At 3:57 AM -0700 6/29/2004, Jan Schenkel wrote:
> But if we cannot pass a user defined variable to the
database query builder then it makes the
database-linked controls kind of weak. I hope that
you
complete that user interface soon.
It isn't straightforward to implement a clear
interface for t
On Jul 22, 2004, at 4:46 PM, Bill wrote:
Jan:
How do you get the -- revRecordCountOfQuery(somevariable)
To work? (I tried inserting all kinds of things in the somevariable
and got
nothing).
I want to have my various changes of the query using
revSetSQLOfQuery "Connect",tSQLStatement to also pu
--- Bill <[EMAIL PROTECTED]> wrote:
> Jan:
>
> How do you get the --
> revRecordCountOfQuery(somevariable)
> To work? (I tried inserting all kinds of things in
> the somevariable and got
> nothing).
>
The parameter is the name of a query ; for example :
get revRecordCountOfQuery("Connect")
--- Andre Garzia <[EMAIL PROTECTED]> wrote:
>
> [snip]
>
> I am with 2.5beta and my version is missing the
> Database Query Builder
> I think, so I advise to stick to 2.2 till 2.5 leave
> beta stage, at
> least for apps involving DB
>
> Cheers
> andre
>
I'm not sure I understand what you mea
Andre:
-- revRecordCountOfQuery(somevariable)
>> how To work it?
>> ofter running revSetSQLOfQuery "Connect",tSQLStatement to also put the
TOTAL COUNT OF THE subset of the
>> records found in a field.
>>
>
> Just like me, you're using "undocumented" Database Query Builder
> functions, they ch
--- Bill <[EMAIL PROTECTED]> wrote:
> Thanks for the quick reply. I'm trying to get
> another of the undocumented
> functions to work. I don't want all the records from
> a search put in a field
> I just want the total found returned and a pointer
> number returned as the
> user goes through them.
On Jul 23, 2004, at 8:24 AM, Jan Schenkel wrote:
I'm not sure I understand what you mean : the Database
Query Builder is still in the 'Tools' menu and the
'Database' panels are in the inspector palette.
What is missing ?
Jan Schenkel.
Jan,
I could swear that my tools menu was missing Database Query
--- Andre Garzia <[EMAIL PROTECTED]> wrote:
>
> Jan,
>
> I could swear that my tools menu was missing
> Database Query Builder
> man, I think I was to fuzzy... I looked there, and
> thought: "okay, this
> is beta, no support for Database Queries yet...".
> Sorry my mistake.
>
> Andre
>
O
Thanks Jan,
Every time I get an answer from you it not only solves my problem but adds
lots of new features and ideas to my project.
Bill
On 7/23/04 8:44 AM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
> As the user steps through the table field, the
> individual record fields will be autm
18 matches
Mail list logo