Using Oracle - message to Frank

[Russell Woodhall]

Frank

Re: Dates, drop field, etc

Thanks for your help

1. MagicCell worked well, will there be any other formats in the next version?
2. I'm trying to show any Oracle text based field and I cannot get dropdowns working for VARCHAR or CHAR field types. I've also tried small tables with a few CHAR(10) fields. The dropdown appears but is very small and empty.
3. Your suggestion to use the 'Oracle,Server' parameter improved performance. Using ASPDB, my page which starts with a filter, takes about 17 seconds to appear. Using PureASP, it took 12 to show the grid. I mislead you with my query, I actually join 15 minor tables to the main 2,600 row table, not just eight. The performance when accessing just the main table without joins is virtually instant. I've also only selected only the fields I needed in the SQL statement. I could be expecting too much!!

4. The Oracle function to put captitals at the start of text is INITCAP. In SQLBase, the function is @PROPER. According to TECHNET, there is no similar MSSQL6.5 function. Pity. I would have thought this was a fairly universal functional requirement these days. I'll have to return back some fields to uppercase just for filtering purposes. It just removes some of the polish by being unable to keep output to the same case type.
5. When is the next version due?

Again, thanks your help Frank,

Russ

[Frank]

Russell,
1. V2 is in beta now, it'll be a short while. V2 is also a fee'ed upgrade.
MagicCell has been extended to a new height with logical capabilities.

2. This one borders me a lot. Please give me the structure of your DB. I'll construct a DB to simulate the problem. If you cna tell me the datatype, that would help a lot. Just use the datatype util that comes with ASPDB.

3. This performace of 12-17 is within range. There should be a lot of room to improve like specifying the countSQL so ASPDB doiesn't have to guess; RecordCount so ASPDB dosn't have to count etc....

4. I still have to check my ORACLE book, but is there a "command" (like SET ...)in ORACLE that enables mix case filtering ?


Frank



On 2/12/99 10:03:09 AM, Russell Woodhall wrote:
>
Frank

Re: Dates, drop field, etc

Thanks for your help

1.
> MagicCell worked well, will there be any other formats in the next
> version?
2. I'm trying to show any Oracle text based field and I
> cannot get dropdowns working for VARCHAR or CHAR field types. I've
> also tried small tables with a few CHAR(10) fields. The dropdown appears
> but is very small and empty.
3. Your suggestion to use the
> 'Oracle,Server' parameter improved performance. Using ASPDB, my
> page which starts with a filter, takes about 17 seconds to appear. Using
> PureASP, it took 12 to show the grid. I mislead you with my query, I
> actually join 15 minor tables to the main 2,600 row table, not just eight.
> The performance when accessing just the main table without joins is
> virtually instant. I've also only selected only the fields I needed in
> the SQL statement. I could be expecting too much!!

4. The Oracle
> function to put captitals at the start of text is INITCAP. In SQLBase, the
> function is @PROPER. According to TECHNET, there is no similar MSSQL6.5
> function. Pity. I would have thought this was a fairly universal
> functional requirement these days. I'll have to return back some fields
> to uppercase just for filtering purposes. It just removes some of the
> polish by being unable to keep output to the same case type.
5. When is
> the next version due?

Again, thanks your help Frank,

Russ

[Frank]

Russell,
I remember now that the VARCHAR in ORACLE present itself as type 201 to the ODBC driver. ASPDB forbids the dropdown of a MEMO field. Let me know your case and if a rule can be derived, I can make provision for that... what is the equivalent of memo field in ORACEL (VARCHAR ??).

Frank



On 2/12/99 10:03:09 AM, Russell Woodhall wrote:
>
Frank

Re: Dates, drop field, etc

Thanks for your help

1.
> MagicCell worked well, will there be any other formats in the next
> version?
2. I'm trying to show any Oracle text based field and I
> cannot get dropdowns working for VARCHAR or CHAR field types. I've
> also tried small tables with a few CHAR(10) fields. The dropdown appears
> but is very small and empty.
3. Your suggestion to use the
> 'Oracle,Server' parameter improved performance. Using ASPDB, my
> page which starts with a filter, takes about 17 seconds to appear. Using
> PureASP, it took 12 to show the grid. I mislead you with my query, I
> actually join 15 minor tables to the main 2,600 row table, not just eight.
> The performance when accessing just the main table without joins is
> virtually instant. I've also only selected only the fields I needed in
> the SQL statement. I could be expecting too much!!

4. The Oracle
> function to put captitals at the start of text is INITCAP. In SQLBase, the
> function is @PROPER. According to TECHNET, there is no similar MSSQL6.5
> function. Pity. I would have thought this was a fairly universal
> functional requirement these days. I'll have to return back some fields
> to uppercase just for filtering purposes. It just removes some of the
> polish by being unable to keep output to the same case type.
5. When is
> the next version due?

Again, thanks your help Frank,

Russ

[Russell Woodhall]

Frank

I've taken some time to try and find out if Oracle has the equiv. to an Access memo field. As you know, the Access Memo field is limited to 64,000 characters and the Oracle Varchar is 4000 bytes. Oracle has a LONG which is upto 2Gb. We use (as do many other Oracle users) VARCHAR datatypes because they are more efficent that CHAR, which is a fixed length datatype. It would be reeaally useful if VARCHAR or even CHAR field types could be considered, I'm prepared to bend the table descriptions if dropdowns would work.

How do I get filters working with joins. I want to be able to search on a field which also happens to be the foreign key in a joined table. Gives me the ambigious column error. I can get around the problem, but some guidance would be welcome.

Still very impressed.

Russ


On 2/12/99 10:53:09 AM, Frank wrote:
> Russell,
I remember now that the VARCHAR in ORACLE present itself as type
> 201 to the ODBC driver. ASPDB forbids the dropdown of a MEMO field. Let me
> know your case and if a rule can be derived, I can make provision for
> that... what is the equivalent of memo field in ORACEL (VARCHAR
> ??).

Frank



On 2/12/99 10:03:09 AM, Russell Woodhall wrote:
>
>
Frank

Re: Dates, drop field, etc

Thanks for your help

1.
>
> MagicCell worked well, will there be any other formats in the next
>
> version?
2. I'm trying to show any Oracle text based field and I
>
> cannot get dropdowns working for VARCHAR or CHAR field types. I've
>
> also tried small tables with a few CHAR(10) fields. The dropdown appears
>
> but is very small and empty.
3. Your suggestion to use the
>
> 'Oracle,Server' parameter improved performance. Using ASPDB, my
>
> page which starts with a filter, takes about 17 seconds to appear. Using
>
> PureASP, it took 12 to show the grid. I mislead you with my query, I
>
> actually join 15 minor tables to the main 2,600 row table, not just
> eight.
> The performance when accessing just the main table without joins
> is
> virtually instant. I've also only selected only the fields I
> needed in
> the SQL statement. I could be expecting too much!!

4. The
> Oracle
> function to put captitals at the start of text is INITCAP. In
> SQLBase, the
> function is @PROPER. According to TECHNET, there is no
> similar MSSQL6.5
> function. Pity. I would have thought this was a
> fairly universal
> functional requirement these days. I'll have to
> return back some fields
> to uppercase just for filtering purposes. It
> just removes some of the
> polish by being unable to keep output to the
> same case type.
5. When is
> the next version due?

Again, thanks
> your help Frank,

Russ