Thank you Troy and Razzak, I turned EVERYTHING off and start it up again and now the same code works fine? Go figure! I did request the Oterro beta version 2.5 and will install it to see how it works. Thank you again, Manuel Troy Sosamon wrote: > My autonumber works? > I have R:Tango 2000 and I think oterro 2.00.1 is installed on my web server. > The web server is Win 2000 Server running IIS 5. > > Troy > > >===== Original Message From [EMAIL PROTECTED] ===== > >Hello Tango Lovers, > > > >QUESTION: Can an autonumber table be used through Tango RELIABLY? > > > > > >I cannot figure this problem out! > >I am ready to feed the kitty if this is a "slap on the forehead" > >issue...................... > > > >I have a table in RBase with five columns. The first column is an > >autonumber column. In my tango insert I set the other four columns to > >legitimate values. When the browser executes the request it returns the > >following error. > >------------------------------------------------------------------------ > > > >Error > > > >An error occurred while processing your request: > > > >File: Quotes.taf > >Position: InsertPrtPRD > >Class: DBMS > >Main Error Number: 2110 > > > >[RBTI][Oterro ODBC Driver][VFIMdrBASE] Resources required by command are > >not available. > >S1000 > > > >File: Quotes.taf > >Position: InsertPrtPRD > >Class: Internal > >Main Error Number: -101 > > > >General error during data source operation. > >----------------------------------------------------------------------------- > --------------------------- > > > >If I user the SQL Query and execute the insert command: > > > >INSERT PrtPDF (LoggedID,LogName,SrchTxt,RepName) VALUES > >(1000,'MD','50000',SalesQuote') > > > >It returns either > >2045 (RBTI)(OTerror ODBC Driver) -ERROR- Syntax is incorrect for the > >command > > or other times ???????? > >Incorrect number of values for this table (118)21S01 > > > >OBSERVATIONS: > >This was working fine and it just stop? > >The autonumber column JobID is not in the insert command. > >I tried replacing the INSERT OBJECT with a DIRECT_DBMS object and the > >both behave in the same manner. > > > >Help TIA, > >Manuel > > Troy Sosamon > Denver Co > [EMAIL PROTECTED]
begin:vcard n:de Aguiar;Manuel tel;fax:(323)661-7698 tel;work:(323)660-3511 x-mozilla-html:FALSE url:http://www.mdenterprises.net org:M|D Enterprises adr:;;2412 No. Commonwealth Avenue;Los Angeles;California;90027-1206;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Developer note;quoted-printable:The information contained in this e-mail may be privileged, confidential,=0D=0Aand protected from disclosure. If you are not the intended recipient, you=0D=0Aare hereby notified that any dissemination, distribution or duplication of=0D=0Athis communication is strictly prohibited. If you have received this=0D=0Acommunication in error, please notify the sender immediately and delete all=0D=0Acopies.=0D=0A=0D=0Ahttp://www.mdenterprises.net=0D=0Ahttp:/www.databasedeveloper.com=0D=0Ahttp://www.MdrBASE.com=0D=0A x-mozilla-cpt:;-1 end:vcard
