Benoît Minisini wrote: >> I made the change to source and update before and after index. Now I get >> error 'No field". I checked database and the table and index is created, >> but what is the error for? What is the number "23" before the "No field" >> error in the debug output? >> > > The error comes from the second Update(). Remove it. > > Update() is called only for creating a new table. Maybe its name was not well > chosen... > > Regards, > > I removed the second update and the code works!
Do you know syntax for .Indexes.Add for more than column for an index. Randy :-) =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Scanned with Copfilter Version 0.84beta3a (ProxSMTP 1.6) AntiSpam: SpamAssassin 3.2.3 AntiVirus: ClamAV 0.91.2/8992 - Sat Feb 14 10:43:07 2009 by Markus Madlener @ http://www.copfilter.org ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user