begining in sql

[newapocalipsis]

i´m begining i sql into ms-foxpro and i´m attempting to change an existing record with update... but it append one more record and i dont want that, i want to replace the existing data in record. Golden Dragon Is Coming Soon...

 

[jjgraf]

Update can not append a new record period, that is what Insert is used for.

I will need to look at your Sql command to see what Happend to help you.


Are you using Remote Views or Sql-Passthrough?

 

[newapocalipsis]

i´m trying to use only sql, in time to normal programming in foxpro for using databases.

update raygoza set clave=10,nombre='juan',edad=12 Golden Dragon Is Coming Soon...

 

[jjgraf]

OK i just created a table raygoza on my SQL 7.0 and 2000 server with three fields 'clave' being a Integer type 'nombre' char type, and 'edad' integer type

I ran it through Query Analyzer, created a SP, and ran it through Foxpro via SP and Sql Passthough.

I cannot create the problem you have.

I have no idea.

i need more info

Server Type NT4.0, Win9X, W2K or WinXP?
Sql Server ver?
foxpro ver including Service Pack installed?
ODBC or OLE DB ver ?

How are you calling or Sending this SQL command to the MS SQL server?

 

[tlbroadbent]

Where is the criteria for your Update query. You should have a Where clause or SQL Server will atempt to update all records in the table. Does the following query do what you want?

update raygoza set nombre='juan',edad=12
where clave = 10 Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.