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.
>> ==================================-=============================
