Hi Manuel,
I am assuming that you are not including the PK/Autonum column in the Tango
insert?
Can I see the insert statement (right click on action and select SQL option)
Ben Johansen
----- Original Message -----
From: "Manuel de Aguiar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 20, 2001 11:19 PM
Subject: Re: TANGO INSERT ON PK/AUTONUM TABLE. - Razzak's Reply
> 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.
> > ==================================-=============================
>
