Yes I do use Oracle quite often. This particular time I am selecting from a VFP table. Somtimes I interchange SQL syntax between Oracle and VFP. The only time it bites me [usually] is when I use VFP syntax for Oracle retrievals in SQL*Plus.
>Cool. I'm glad it's working, looking forward to seeing what you ended up with.
>
>Off-topic. I noticed you are using straight SQL for the select. Is this for C/S? I thought you did a lot of remote to Oracle?
>
>>I am continuing to
perfect this class. I will post my
final version here when done. I am getting real 2-D arrays to work -- aList[1,1], aList[1,2], aList[2,1], aList[2,2], etc.
>>
>>>Same here.
>>>
>>>>I am using VFP 6 SP3. What are you using?
>>>>
>>>>>Hmm... Mine has been working fine and I haven't been doing that.
>>>>>This is the code in the init.
>>>>>
>>>>>
DoDefault()
>>>>>
>>>>>select abbrev from states order by 1 into array This.aList
>>>>>
>>>>>local lnResult
>>>>>lnResult = 1
>>>>>if !empty( This.ControlSource )
>>>>> lnResult = ascan( This.aList, eval( This.ControlSource ) )
>>>>>endif
>>>>>
>>>>>if lnResult = 0
>>>>> local lnLen
>>>>> lnLen = alen( This.aList, 1 ) + 1
>>>>> dimension This.aList[ lnLen, 1 ]
>>>>> This.aList[ lnlen ] = eval( This.ControlSource )
>>>>> asort( This.aList )
>>>>>endif
>>>>>
Mark McCasland
Midlothian, TX USA