Thank you Troy. Thank you Bill. Thank you Razzak. If you guys are using autonum tables with Tango 2K then I must be doing something wrong. Follow up question. How can I ask Oterro for its version through Tango. Is there an Oterro command like "SHOW VERSION" in RBase? TIA, Manuel Troy Sosamon wrote: > Manuel, > > I have no problems inserting rows with autonumbered columns. > What version of Oterro do you have? I am using 2.00.02, and it fixed several > odd problems I was having w/ 2.00.01. I have not had a chance to test the > beta version of Oterro. > > fyi, my autonumbered rows are indexed, but I do not use constraints or > primary/foreign keys. > > Make sure on your insert you are not trying to insert a value in that column. > Also make sure if you are inserting dates, that you do not put quotes on the > dates. Tango defaults to putting quotes around dates and times. > > Troy > > >===== Original Message From [EMAIL PROTECTED] ===== > >Hello Everyone, > > > >Still having problems with autonum tables and Tango. > > > >The row is inserted but the Autonum column is null > >............................................................................. > ........................................ > > > >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. > >............................................................................. > ............................. > > > > > > > > > >In another area of my application the row failed creation (I believe due > >to the no null in the PK constraint) where autonum is used. The web > >page generates the following messages: > >............................................................................. > ........................................................... > > > >Error > >An error occurred while processing your request: > >File: users.taf > >Position: Insert > >Class: DBMS > >Main Error Number: 2227 > >[RBTI][Oterro ODBC Driver][VFIMdrBASE]Value for SYSiLoggedID cannot be > >null. > >23000 > >File: users.taf > >Position: Insert > >Class: DBMS > >Main Error Number: 2110 > >[RBTI][Oterro ODBC Driver][VFIMdrBASE] Resources required by command are > >not available. > >S1000 > >File: users.taf > >Position: Insert > >Class: DBMS > >Main Error Number: 2110 > >[RBTI][Oterro ODBC Driver][VFIMdrBASE] Resources required by command are > >not available. > >S1000 > >File: users.taf > >Position: Insert > >Class: Internal > >Main Error Number: -101 > >General error during data source operation. > >............................................................................. > ............................... > > > >I turned on the ODBC tracing on but the log file was never created. > > > >I disconnected everything to the database except the Tango service and > >condition did not change. > > > >I shut down the NT server and afterward everything is working. The ODBC > >tracing file is created and working. I will be leaving it on and will > >check it if it fails again. I have been very busy doing developmental > >work on the system. I do not know if the failure was triggered by my > >developmental work or simple the OtV2.5 has not address the issue with > >autonum tables. > > > >If this continues I will have to invest a lot of time to create a > >workaround system to simulate autonum. Before I do this I want to ask a > >question to the group in Tango land. Am I the only fool using autonum > >tables with Tango 2000? Go ahead be brutal and let me know. > >Thanks, > >Manuel > > > > > > > > > > > > > >"A. Razzak Memon" wrote: > > > >> Manuel, > >> > >> I would suggest to turn on SQLLOG Trace for detailed -ERROR- message > >> along with the syntax created by direct DBMS action in R:Tango 2000. > >> > >> Let me know. > >> > >> Good Luck! > >> > >> Very Best Regards, > >> > >> Razzak. > >> > >> At 12:14 PM 9/18/01 -0700, Manuel de Aguiar wrote: > >> > > >> >General error during data source operation. > >> > > >> >I also tried using the TANGO DIRECT DBMS with the same > >> >negative results. > >> > >> ===================================-============================ > >> Official R:BASE List Server: mailto:[EMAIL PROTECTED] > >> RBTI Events/Training: http://www.rbase2000.com/events > >> R:DCC Members: http://www.rbase2000.com/rdcc > >> ================================================================ > >> R:BASE, Oterro & R:Tango are registered trademarks of RBTI. > >> ==================================-=============================
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
