TTable.Append problem.

Our program needs to be able to run against 2 different databases,
Pervasive.SQL and MSSQL server. We have earlier used Titan to connect to
Pervasive.SQL. Titan have a class TTbTable that's Titan's "TTable" class. To
minimize the rewrite of the application, I would like to use TTable to
connect to our database on a Pervasive.SQL server og MSSQL server. This
would minimize the need to change our code. Our database can be located on a
Pervasive.SQL server, or a MSSQL server.

I almost have a working test program, the only difficulty is creating new
records in MSSQL server using TTable.Append.

I do this:
myTTable.Append;
myTTable.FieldByName('Name'):='Name';
myTTable.Post;

There are other fields in my table, but I don't want to fill them all. This
gives me an exception, telling me that I have to fill all the fields (one by
one).
I then tried this:

For i:=0 to myTTable.FieldDefs.Count-1 do
begin
myTTable.FieldDefs[i].Required := false;
End;

myTTable.Append;
myTTable.FieldByName('Name'):='Name';
myTTable.Post;

But I still get the same exception (EDatabaseError: Field "RECNUM" must have
a value). Our RECNUM field is a "Identity integer column" in our SQL server
database, and so, we should not need to fill in a value for this
column/field. If I fill out the RECNUM field, I get another exception, that
basically tells me that I should not place anything in this field.

The above code works fine against the Pervasive.SQL database. I can locate,
edit and delete records in our MSSQL database, but not insert new records.

TIA
Karl


.

Relevant Pages

  • Re: Resetting User Password
    ... > Please let me know if there's anyway i can reset the ... Can you stop the MSSQL server on the user's machine? ... database files and attach to another MSSQL Server engine without any ... you don't need any password to attach these files. ...
    (microsoft.public.sqlserver.security)
  • Re: TTable.Append problem.
    ... Titan have a class TTbTable that's Titan's "TTable" class. ... connect to our database on a Pervasive.SQL server og MSSQL server. ... I am trying to rewrite using TADOQuery instead. ...
    (alt.comp.lang.borland-delphi)
  • Re: TTable.Append problem.
    ... Titan have a class TTbTable that's Titan's "TTable" class. ... To minimize the rewrite of the application, I would like to use TTable to connect to our database on a Pervasive.SQL server og MSSQL server. ... Our RECNUM field is a "Identity integer column" in our SQL server database, and so, we should not need to fill in a value for this column/field. ...
    (alt.comp.lang.borland-delphi)
  • Performance of datatable.select() func against database query or the xquery
    ... Using MsSQL SERVER 2005. ... what i m doing is querying the database only once at the application_start event of the global.asax file and storing the records in dataset...and further no query to database is done for this data. ... wherever I need this data I fetch it from the dataset...through datatable.selectmethod.this is done several time for a single page request and the website is high traffic portal. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi threads issue with JDBC running on BEA Weblogic 8.1 SP4
    ... I am trying to update a specific column in a row on MSSQL server 2005 database via MSSQL Server 2005 JDBC Driver. ... 3- When I do this update transaction from one thread, it works and everything going well and data stored successfully in the database but when I run more than ... active connection ...
    (microsoft.public.sqlserver.jdbcdriver)