Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mSportsman
  • Content: Threads
  • Order by date
  1. mSportsman

    C# Pervasive Data Provider Update command causing Syntax error, but not on development machine.

    I am developing a C#.NET app using the three tier data model. On my development machine, this works flawlessly. One other machines with same OS. An exception occurs - "Pervasive.Data.SqlClient.Lna.k: [LNA][ODBC Engine Interface]Syntax Error." ... This is the full message Other info I got...
  2. mSportsman

    Trouble with foreign Keys

    Could someone please help me see what is going on and how to fix this problem? My database was working fine then this is what I did: I needed to add a new column to a table which contains a Foreign Key to another table with a primary key. I used the PCC's edit table function, and deleted the FK...
  3. mSportsman

    Strange Problem with Identity field

    I am having a problem where @@IDENTITY is returning null after a record has been successfully inserted into a table that contains an IDENTITY Column. The methods I have tried always work again a test database. The same methods sometimes work against the production data, but sometimes they do...

Part and Inventory Search

Back
Top