I get "Too many variables" error when I run this SELECT command. The results of my SELECT are in an array which is tied to a listbox. I get the error before form containing the listbox appears. This SELECT occurs in the Form Init.
Any idea why this error is happening? I don't see it.
Here's my code:
SELECT master.incident, master.patnum, master.patqty, master.name_last, master.name_first, ;
master.sitename, master.addr1a, master.citya, ;
master.mcoid, master.date, arrest.sca_ctr, arrest.closed, arrest.incident ;
FROM master JOIN arrest ON master.incident = arrest.incident ;
ORDER BY master.date INTO ARRAY slister
The listbox has ColumnCount set to 12 and ColumnWidths set to 25,25,25,....
Thanks for your help.
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.