>Yes Im converting from foxpro 9 to vb.net 2003. Sorry forgot to mention that. The code I posted for foxpro does in fact work, but not the converted code.
In fox thios code will works because it is translated by the fox itself. In .NET it is translated by VFPOLEDB provider.
go to
http://www.microsoft.com/downloads/details.aspx?familyid=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en, install this file and see if this make any difference.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.