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]
