I am using PB5, Win98 and SQL Anywhere 5.5 but I presume that there shouldn't be
significant difference.
The only way I manage to get similar error is to proceed the table name without
creator name. As I can see from your code example, this is the case. You should
use the syntax: creator.table_name as first argument.
There is another inconsistency in the function: the help claims to return number
of elements in the array, but, in fact, it returns SQLCode. Check it in your
version of PB !
Have a nice day !
Zvonimir Kuntic
[EMAIL PROTECTED]
----- Original Message -----
From: Jill M. Claus <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, 29. August 2000. 21:03
Subject: PFCSIG of_DistinctValues problem
> I am using PB7, NT4, and Sybase11.
>
> I want to populate an array with all of the distinct values in a particular
column of a particular table. When I run the following code:
>
> // populate an array with all distinct
> // branch_id's in gldb_summary table
> String ls_branches[ ]
> gl_return = SQLCA.of_DistinctValues("gldb_summary", "branch_id", ls_branches)
>
> I get the following error:
>
> Error Number 20.
> Error Text = Database command has not been successfully prepared.
> Window/Menu/Object = pfc_n_tr.
> Error Object/Control = pfc_n_tr.
> Script = of_distinctvalues.
> Line in Script = 41.
>
> I've verified that the arguments I'm passing are valid. The code that
connects to my database is located in the script of my object n_cst_fwappmanager
and it runs without error. So I'm not sure what the preceding error is
referring to.
>
> Any help would be greatly appreciated.
>
> Thanks,
> Jill
>
>
>
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
>
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
